|
第三阶段New Feature/OCM Exam Preparation(31-59)
TSPITR在线恢复删除表空间:
- RMAN> run {
- 2> sql "alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''";
- 3> recover tablespace users until time '2017-09-29:20:07:09'
- 4> auxiliary destination '/u01/app/oracle/oradata';
- 5> }
- sql statement: alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''
- Starting recover at 2017-09-29:20:09:47
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=144 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=205 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=19 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=81 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=145 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=206 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=20 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=82 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=146 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=141 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- Creating automatic instance, with SID='cydb'
- initialization parameters used for automatic instance:
- db_name=ORCL
- db_unique_name=cydb_tspitr_ORCL
- compatible=11.2.0.0.0
- db_block_size=8192
- db_files=200
- sga_target=280M
- processes=50
- db_create_file_dest=/u01/app/oracle/oradata
- log_archive_dest_1='location=/u01/app/oracle/oradata'
- #No auxiliary parameter file used
- starting up automatic instance ORCL
- Oracle instance started
- Total System Global Area 292278272 bytes
- Fixed Size 2227744 bytes
- Variable Size 100663776 bytes
- Database Buffers 184549376 bytes
- Redo Buffers 4837376 bytes
- Automatic instance created
- contents of Memory Script:
- {
- # set requested point in time
- set until time "2017-09-29:20:07:09";
- # restore the controlfile
- restore clone controlfile;
- # mount the controlfile
- sql clone 'alter database mount clone database';
- # archive current online log
- sql 'alter system archive log current';
- # avoid unnecessary autobackups for structural changes during TSPITR
- sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
- # resync catalog
- resync catalog;
- }
- executing Memory Script
- executing command: SET until clause
- Starting restore at 2017-09-29:20:10:23
- allocated channel: ORA_AUX_DISK_1
- channel ORA_AUX_DISK_1: SID=80 device type=DISK
- allocated channel: ORA_AUX_DISK_2
- channel ORA_AUX_DISK_2: SID=5 device type=DISK
- allocated channel: ORA_AUX_DISK_3
- channel ORA_AUX_DISK_3: SID=30 device type=DISK
- allocated channel: ORA_AUX_DISK_4
- channel ORA_AUX_DISK_4: SID=56 device type=DISK
- allocated channel: ORA_AUX_DISK_5
- channel ORA_AUX_DISK_5: SID=81 device type=DISK
- allocated channel: ORA_AUX_DISK_6
- channel ORA_AUX_DISK_6: SID=6 device type=DISK
- allocated channel: ORA_AUX_DISK_7
- channel ORA_AUX_DISK_7: SID=31 device type=DISK
- allocated channel: ORA_AUX_DISK_8
- channel ORA_AUX_DISK_8: SID=57 device type=DISK
- allocated channel: ORA_AUX_SBT_TAPE_1
- channel ORA_AUX_SBT_TAPE_1: SID=82 device type=SBT_TAPE
- channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_AUX_SBT_TAPE_2
- channel ORA_AUX_SBT_TAPE_2: SID=7 device type=SBT_TAPE
- channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_AUX_SBT_TAPE_1: restoring control file
- channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-1343950367-20170929-01
- channel ORA_AUX_SBT_TAPE_1: piece handle=c-1343950367-20170929-01 tag=TAG20170929T200013
- channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
- channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
- output file name=/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_dwwg239o_.ctl
- Finished restore at 2017-09-29:20:10:51
- sql statement: alter database mount clone database
- sql statement: alter system archive log current
- sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;
- starting full resync of recovery catalog
- full resync complete
- contents of Memory Script:
- {
- # set requested point in time
- set until time "2017-09-29:20:07:09";
- # set destinations for recovery set and auxiliary set datafiles
- set newname for clone datafile 1 to new;
- set newname for clone datafile 3 to new;
- set newname for clone datafile 2 to new;
- set newname for clone tempfile 1 to new;
- set newname for datafile 4 to new;
- # switch all tempfiles
- switch clone tempfile all;
- # restore the tablespaces in the recovery set and the auxiliary set
- restore clone datafile 1, 3, 2, 4;
- switch clone datafile all;
- }
- executing Memory Script
- executing command: SET until clause
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- renamed tempfile 1 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_%u_.tmp in control file
- Starting restore at 2017-09-29:20:10:58
- using channel ORA_AUX_DISK_1
- using channel ORA_AUX_DISK_2
- using channel ORA_AUX_DISK_3
- using channel ORA_AUX_DISK_4
- using channel ORA_AUX_DISK_5
- using channel ORA_AUX_DISK_6
- using channel ORA_AUX_DISK_7
- using channel ORA_AUX_DISK_8
- using channel ORA_AUX_SBT_TAPE_1
- using channel ORA_AUX_SBT_TAPE_2
- channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_AUX_SBT_TAPE_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_%u_.dbf
- channel ORA_AUX_SBT_TAPE_1: reading from backup piece 1ls4tgjd_1_1
- channel ORA_AUX_SBT_TAPE_2: starting datafile backup set restore
- channel ORA_AUX_SBT_TAPE_2: specifying datafile(s) to restore from backup set
- channel ORA_AUX_SBT_TAPE_2: restoring datafile 00001 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_%u_.dbf
- channel ORA_AUX_SBT_TAPE_2: restoring datafile 00002 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_%u_.dbf
- channel ORA_AUX_SBT_TAPE_2: reading from backup piece 1ks4tgjd_1_1
- channel ORA_AUX_SBT_TAPE_1: piece handle=1ls4tgjd_1_1 tag=0T_INCR0_WHOLE
- channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
- channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
- channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_AUX_SBT_TAPE_1: restoring datafile 00004 to +DATA
- channel ORA_AUX_SBT_TAPE_1: reading from backup piece 1osfmr2e_1_1
- channel ORA_AUX_SBT_TAPE_2: piece handle=1ks4tgjd_1_1 tag=0T_INCR0_WHOLE
- channel ORA_AUX_SBT_TAPE_2: restored backup piece 1
- channel ORA_AUX_SBT_TAPE_2: restore complete, elapsed time: 00:00:35
- channel ORA_AUX_SBT_TAPE_1: piece handle=1osfmr2e_1_1 tag=TAG0929
- channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
- channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
- Finished restore at 2017-09-29:20:11:59
- datafile 4 switched to datafile copy
- input datafile copy RECID=7 STAMP=956002319 file name=+DATA/orcl/datafile/users.259.956002313
- datafile 1 switched to datafile copy
- input datafile copy RECID=8 STAMP=956002319 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_dwwg367y_.dbf
- datafile 3 switched to datafile copy
- input datafile copy RECID=9 STAMP=956002319 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_dwwg375k_.dbf
- datafile 2 switched to datafile copy
- input datafile copy RECID=10 STAMP=956002319 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_dwwg368j_.dbf
- contents of Memory Script:
- {
- # set requested point in time
- set until time "2017-09-29:20:07:09";
- # online the datafiles restored or switched
- sql clone "alter database datafile 1 online";
- sql clone "alter database datafile 3 online";
- sql clone "alter database datafile 2 online";
- sql clone "alter database datafile 4 online";
- # recover and open resetlogs
- recover clone database tablespace "USERS", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;
- alter clone database open resetlogs;
- }
- executing Memory Script
- executing command: SET until clause
- sql statement: alter database datafile 1 online
- sql statement: alter database datafile 3 online
- sql statement: alter database datafile 2 online
- sql statement: alter database datafile 4 online
- Starting recover at 2017-09-29:20:11:59
- using channel ORA_AUX_DISK_1
- using channel ORA_AUX_DISK_2
- using channel ORA_AUX_DISK_3
- using channel ORA_AUX_DISK_4
- using channel ORA_AUX_DISK_5
- using channel ORA_AUX_DISK_6
- using channel ORA_AUX_DISK_7
- using channel ORA_AUX_DISK_8
- using channel ORA_AUX_SBT_TAPE_1
- using channel ORA_AUX_SBT_TAPE_2
- starting media recovery
- archived log for thread 1 with sequence 108 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_108.330.955992987
- archived log for thread 1 with sequence 109 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_109.331.955993405
- archived log for thread 1 with sequence 110 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_110.329.955999557
- archived log for thread 1 with sequence 111 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_111.332.955999557
- archived log for thread 1 with sequence 112 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_112.333.955999567
- archived log for thread 1 with sequence 113 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_113.328.955999567
- archived log for thread 1 with sequence 114 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_114.327.955999569
- archived log for thread 1 with sequence 115 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_115.326.955999571
- archived log for thread 1 with sequence 116 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_116.325.956000511
- archived log for thread 1 with sequence 117 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_117.324.956001639
- archived log for thread 1 with sequence 118 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_118.323.956001641
- archived log for thread 1 with sequence 119 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_119.322.956001643
- archived log for thread 1 with sequence 120 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_120.321.956001647
- archived log for thread 1 with sequence 121 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_121.320.956001647
- archived log for thread 1 with sequence 122 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_122.319.956001649
- archived log for thread 1 with sequence 123 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_123.318.956001857
- archived log for thread 1 with sequence 124 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_124.317.956001865
- archived log for thread 1 with sequence 125 is already on disk as file +FRA/orcl/archivelog/2017_09_29/thread_1_seq_125.316.956002257
- channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
- channel ORA_AUX_SBT_TAPE_1: restoring archived log
- archived log thread=1 sequence=107
- channel ORA_AUX_SBT_TAPE_1: reading from backup piece 1ms4tgk7_1_1
- channel ORA_AUX_SBT_TAPE_1: piece handle=1ms4tgk7_1_1 tag=0T_INCR0_WHOLE
- channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
- channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
- archived log file name=/u01/app/oracle/oradata/1_107_816169635.dbf thread=1 sequence=107
- channel clone_default: deleting archived log(s)
- archived log file name=/u01/app/oracle/oradata/1_107_816169635.dbf RECID=109 STAMP=956002337
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_108.330.955992987 thread=1 sequence=108
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_109.331.955993405 thread=1 sequence=109
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_110.329.955999557 thread=1 sequence=110
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_111.332.955999557 thread=1 sequence=111
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_112.333.955999567 thread=1 sequence=112
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_113.328.955999567 thread=1 sequence=113
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_114.327.955999569 thread=1 sequence=114
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_115.326.955999571 thread=1 sequence=115
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_116.325.956000511 thread=1 sequence=116
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_117.324.956001639 thread=1 sequence=117
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_118.323.956001641 thread=1 sequence=118
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_119.322.956001643 thread=1 sequence=119
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_120.321.956001647 thread=1 sequence=120
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_121.320.956001647 thread=1 sequence=121
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_122.319.956001649 thread=1 sequence=122
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_123.318.956001857 thread=1 sequence=123
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_124.317.956001865 thread=1 sequence=124
- archived log file name=+FRA/orcl/archivelog/2017_09_29/thread_1_seq_125.316.956002257 thread=1 sequence=125
- media recovery complete, elapsed time: 00:00:21
- Finished recover at 2017-09-29:20:12:47
- database opened
- contents of Memory Script:
- {
- # make read only the tablespace that will be exported
- sql clone 'alter tablespace USERS read only';
- # create directory for datapump import
- sql "create or replace directory TSPITR_DIROBJ_DPDIR as ''
- /u01/app/oracle/oradata''";
- # create directory for datapump export
- sql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''
- /u01/app/oracle/oradata''";
- }
- executing Memory Script
- sql statement: alter tablespace USERS read only
- sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/oradata''
- sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/oradata''
- Performing export of metadata...
- EXPDP> Starting "SYS"."TSPITR_EXP_cydb":
- EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
- EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
- EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
- EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
- EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
- EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
- EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
- EXPDP> Master table "SYS"."TSPITR_EXP_cydb" successfully loaded/unloaded
- EXPDP> ******************************************************************************
- EXPDP> Dump file set for SYS.TSPITR_EXP_cydb is:
- EXPDP> /u01/app/oracle/oradata/tspitr_cydb_95771.dmp
- EXPDP> ******************************************************************************
- EXPDP> Datafiles required for transportable tablespace USERS:
- EXPDP> +DATA/orcl/datafile/users.259.956002313
- EXPDP> Job "SYS"."TSPITR_EXP_cydb" successfully completed at 20:13:20
- Export completed
- contents of Memory Script:
- {
- # shutdown clone before import
- shutdown clone immediate
- }
- executing Memory Script
- database closed
- database dismounted
- Oracle instance shut down
- Performing import of metadata...
- IMPDP> Master table "SYS"."TSPITR_IMP_cydb" successfully loaded/unloaded
- IMPDP> Starting "SYS"."TSPITR_IMP_cydb":
- IMPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
- IMPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
- IMPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
- IMPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
- IMPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
- IMPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
- IMPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
- IMPDP> Job "SYS"."TSPITR_IMP_cydb" successfully completed at 20:13:40
- Import completed
- contents of Memory Script:
- {
- # make read write and offline the imported tablespaces
- sql 'alter tablespace USERS read write';
- sql 'alter tablespace USERS offline';
- # enable autobackups after TSPITR is finished
- sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';
- # resync catalog
- resync catalog;
- }
- executing Memory Script
- sql statement: alter tablespace USERS read write
- sql statement: alter tablespace USERS offline
- sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;
- starting full resync of recovery catalog
- full resync complete
- Removing automatic instance
- Automatic instance removed
- auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_dwwg61xb_.tmp deleted
- auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_dwwg60do_.log deleted
- auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_dwwg6037_.log deleted
- auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_dwwg5zs3_.log deleted
- auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_dwwg368j_.dbf deleted
- auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_dwwg375k_.dbf deleted
- auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_dwwg367y_.dbf deleted
- auxiliary instance file /u01/app/oracle/oradata/ORCL/controlfile/o1_mf_dwwg239o_.ctl deleted
- Finished recover at 2017-09-29:20:13:43
- RMAN> backup tablespace users;
- Starting backup at 2017-09-29:20:16:08
复制代码 13a 13b 和15连续做的复杂实验:
13a出题过程:
13a做题过程:
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 17:34:24 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected to an idle instance.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 6664212480 bytes
- Fixed Size 2240944 bytes
- Variable Size 3640659536 bytes
- Database Buffers 3003121664 bytes
- Redo Buffers 18190336 bytes
- ORA-00205: error in identifying control file, check alert log for more info
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 17:35:46 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (not mounted)
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 17:36:01 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (not mounted)
- RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
- connected to recovery catalog database
- RMAN> list backup of controlfile;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 203 Full 9.50M SBT_TAPE 00:00:16 2017-05-22:20:42:24
- BP Key: 208 Status: AVAILABLE Compressed: NO Tag: TAG20170522T204208
- Handle: c-1343950367-20170522-00 Media: station90-000001
- Control File Included: Ckp SCN: 2026879 Ckp time: 2017-05-22:20:42:08
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 224 Full 9.50M SBT_TAPE 00:00:16 2017-10-01:17:31:09
- BP Key: 228 Status: AVAILABLE Compressed: NO Tag: LABS-13A-CONTR-BEFORE-CREA
- Handle: 1osfufmd_1_1 Media: station90-000001
- Control File Included: Ckp SCN: 2146263 Ckp time: 2017-10-01:17:30:53
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 225 Full 9.50M SBT_TAPE 00:00:15 2017-10-01:17:31:35
- BP Key: 229 Status: AVAILABLE Compressed: NO Tag: TAG20171001T173119
- Handle: c-1343950367-20171001-00 Media: station90-000001
- Control File Included: Ckp SCN: 2146285 Ckp time: 2017-10-01:17:31:20
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 261 Full 9.50M SBT_TAPE 00:00:16 2017-10-01:17:32:27
- BP Key: 265 Status: AVAILABLE Compressed: NO Tag: LABS-13A-CONTR-AFTER-CREA
- Handle: 1qsfufor_1_1 Media: station90-000001
- Control File Included: Ckp SCN: 2146685 Ckp time: 2017-10-01:17:32:11
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 262 Full 9.50M SBT_TAPE 00:00:16 2017-10-01:17:32:53
- BP Key: 266 Status: AVAILABLE Compressed: NO Tag: TAG20171001T173237
- Handle: c-1343950367-20171001-01 Media: station90-000001
- Control File Included: Ckp SCN: 2146701 Ckp time: 2017-10-01:17:32:37
- RMAN> restore controlfile from tag 'LABS-13A-CONTR-AFTER-CREA';
- Starting restore at 2017-10-01:17:36:35
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=130 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=194 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=6 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=70 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=131 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=195 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=7 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=71 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=132 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=8 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: restoring control file
- channel ORA_SBT_TAPE_1: reading from backup piece 1qsfufor_1_1
- channel ORA_SBT_TAPE_1: piece handle=1qsfufor_1_1 tag=LABS-13A-CONTR-AFTER-CREA
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
- output file name=+DATA/orcl/controlfile/current.260.956252225
- output file name=+FRA/orcl/controlfile/current.256.956252231
- Finished restore at 2017-10-01:17:37:14
- RMAN> alter database mount ;
- database mounted
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- released channel: ORA_SBT_TAPE_1
- released channel: ORA_SBT_TAPE_2
- RMAN> recover database;
- Starting recover at 2017-10-01:17:37:51
- Starting implicit crosscheck backup at 2017-10-01:17:37:51
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=132 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=196 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=72 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=131 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=195 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=7 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=71 device type=DISK
- Finished implicit crosscheck backup at 2017-10-01:17:37:52
- Starting implicit crosscheck copy at 2017-10-01:17:37:52
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- Finished implicit crosscheck copy at 2017-10-01:17:37:52
- searching for all files in the recovery area
- cataloging files...
- no files cataloged
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=6 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- starting media recovery
- archived log for thread 1 with sequence 118 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.323.956251919
- archived log for thread 1 with sequence 119 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.322.956251919
- archived log for thread 1 with sequence 120 is already on disk as file +DATA/orcl/onlinelog/group_3.263.816169641
- archived log file name=+FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.323.956251919 thread=1 sequence=118
- archived log file name=+FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.322.956251919 thread=1 sequence=119
- archived log file name=+DATA/orcl/onlinelog/group_3.263.816169641 thread=1 sequence=120
- media recovery complete, elapsed time: 00:00:02
- Finished recover at 2017-10-01:17:38:09
- RMAN> alter database open resetlogs;
- database opened
- new incarnation of database registered in recovery catalog
- starting full resync of recovery catalog
- full resync complete
- RMAN>
复制代码 13b出题过程:
13b做题过程:
15出题过程:
-
- ---------------------------------------------- LAB 15 ----------------------------------------------
- 15_穿越incarnation不完全恢复
- ---------------------------------------------- LAB 15 ----------------------------------------------
-
-
- ******************
- 你的主机信息如下:
- ******************
-
- station90.example.com
-
- Linux station90.example.com 2.6.32-696.el6.x86_64 a#1 SMP Tue Feb 21 00:53:17 EST 2017 x86_64 x86_64 x86_64 GNU/Linux
-
-
- Name Type Target State Host
- ------------------------------------------------------------
- ora.DATA.dg ora....up.type ONLINE ONLINE station90
- ora.FRA.dg ora....up.type ONLINE ONLINE station90
- ora....ER.lsnr ora....er.type ONLINE ONLINE station90
- ora.asm ora.asm.type ONLINE ONLINE station90
- ora.cssd ora.cssd.type ONLINE ONLINE station90
- ora.diskmon ora....on.type OFFLINE OFFLINE
- ora.evmd ora.evm.type ONLINE ONLINE station90
- ora.ons ora.ons.type OFFLINE OFFLINE
- ora.orcl.db ora....se.type ONLINE ONLINE station90
- Name Type Target State Host
- ------------------------------------------------------------
- ora.DATA.dg ora....up.type ONLINE ONLINE station90
- ora.FRA.dg ora....up.type ONLINE ONLINE station90
- ora....ER.lsnr ora....er.type ONLINE ONLINE station90
- ora.asm ora.asm.type ONLINE ONLINE station90
- ora.cssd ora.cssd.type ONLINE ONLINE station90
- ora.diskmon ora....on.type OFFLINE OFFLINE
- ora.evmd ora.evm.type ONLINE ONLINE station90
- ora.ons ora.ons.type OFFLINE OFFLINE
- ora.orcl.db ora....se.type ONLINE ONLINE station90
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 18:09:49 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> Connected.
- SQL> SQL> SQL>
- A
- --------------------
- Botang
- ****************************
- The database open mode here:
- ****************************
- D
- -
- X
- OPEN_MODE
- --------------------
- READ WRITE
- **********************************
- The database archivelog mode here:
- **********************************
- Database log mode Archive Mode
- Automatic archival Enabled
- Archive destination USE_DB_RECOVERY_FILE_DEST
- Oldest online log sequence 6
- Next log sequence to archive 8
- Current log sequence 8
- ***************************
- The database datafile here:
- ***************************
- TABLESPACE_NAME STATUS
- ------------------------------ ---------------
- SYSTEM ONLINE
- SYSAUX ONLINE
- UNDOTBS1 ONLINE
- TEMP ONLINE
- USERS ONLINE
- EXAMPLE ONLINE
- TBSOCP05_TEST2 ONLINE
- TBSOCP05_TEST3 ONLINE
- NAME STATUS
- ----------------------------------------------------------------- ---------------
- +DATA/orcl/datafile/system.256.816169553 SYSTEM
- +DATA/orcl/datafile/sysaux.257.816169553 ONLINE
- +DATA/orcl/datafile/undotbs1.258.816169553 ONLINE
- +DATA/orcl/datafile/users.259.816169553 ONLINE
- +DATA/orcl/datafile/example.265.816169651 ONLINE
- +DATA/orcl/datafile/tbsocp05_test2.267.956251909 ONLINE
- +DATA/orcl/datafile/tbsocp05_test3.268.956253241 ONLINE
- ******************************
- The database controlfile here:
- ******************************
- NAME
- -----------------------------------------------------------------
- +DATA/orcl/controlfile/current.260.956253897
- +FRA/orcl/controlfile/current.256.956253899
- **************************
- The database logfile here:
- **************************
- MEMBER
- --------------------------------------------------------------------------------
- +DATA/orcl/onlinelog/group_1.261.816169635
- +FRA/orcl/onlinelog/group_1.257.816169637
- +DATA/orcl/onlinelog/group_3.263.816169641
- +FRA/orcl/onlinelog/group_3.259.816169641
- +DATA/orcl/onlinelog/group_2.262.816169639
- +FRA/orcl/onlinelog/group_2.258.816169639
- SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
-
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 18:09:49 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> Connected.
- SQL> SQL> SQL>
- A
- --------------------
- Botang
- SYSDATE
- -------------------
- 2017-10-01:18:09:55
- **************************
- Table successfully created.
- **************************
- A
- ----------
- 1
- ********************************************************************************
- ***************************
- After the displayed moment, the table will continuously be inserted with more
- rows, but finnally be droped..
- ********************************************************************************
- ***************************
- Database log mode Archive Mode
- Automatic archival Enabled
- Archive destination USE_DB_RECOVERY_FILE_DEST
- Oldest online log sequence 8
- Next log sequence to archive 10
- Current log sequence 10
- A
- ----------
- 1
- 2
- 3
- 4
- 5
- SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
-
- CRS-2673: Attempting to stop 'ora.orcl.db' on 'station90'
- CRS-2677: Stop of 'ora.orcl.db' on 'station90' succeeded
- CRS-2500: Cannot stop resource 'ora.orcl.db' as it is not running
- CRS-4000: Command Stop failed, or completed with errors.
-
-
- ASMCMD> ASMCMD>
-
- ASMCMD> ASMCMD>
-
-
-
- ASMCMD> ASMCMD>
-
- ASMCMD> ASMCMD>
-
- ASMCMD> ASMCMD>
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 18:13:30 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> Connected to an idle instance.
- SQL> SQL> SQL> select * from sys.tname
- *
- ERROR at line 1:
- ORA-01034: ORACLE not available
- Process ID: 0
- Session ID: 0 Serial number: 0
- alter system flush buffer_cache
- *
- ERROR at line 1:
- ORA-01034: ORACLE not available
- Process ID: 0
- Session ID: 0 Serial number: 0
- BEGIN dbms_output.put_line(' '); END;
- *
- ERROR at line 1:
- ORA-01034: ORACLE not available
- Process ID: 0
- Session ID: 0 Serial number: 0
- BEGIN dbms_output.put_line('**************************** '); END;
- *
- ERROR at line 1:
- ORA-01034: ORACLE not available
- Process ID: 0
- Session ID: 0 Serial number: 0
- BEGIN dbms_output.put_line('The destory take place here: '); END;
- *
- ERROR at line 1:
- ORA-01034: ORACLE not available
- Process ID: 0
- Session ID: 0 Serial number: 0
- BEGIN dbms_output.put_line('**************************** '); END;
- *
- ERROR at line 1:
- ORA-01034: ORACLE not available
- Process ID: 0
- Session ID: 0 Serial number: 0
- BEGIN dbms_output.put_line(' '); END;
- *
- ERROR at line 1:
- ORA-01034: ORACLE not available
- Process ID: 0
- Session ID: 0 Serial number: 0
- create table ttestbotang_15 (a number) tablespace users
- *
- ERROR at line 1:
- ORA-01034: ORACLE not available
- Process ID: 0
- Session ID: 0 Serial number: 0
- SQL> Disconnected
-
-
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 18:13:30 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> Connected to an idle instance.
- SQL> ORACLE instance started.
- Total System Global Area 6664212480 bytes
- Fixed Size 2240944 bytes
- Variable Size 3640659536 bytes
- Database Buffers 3003121664 bytes
- Redo Buffers 18190336 bytes
- Database mounted.
- SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
-
- THE END
复制代码 15做题过程:
- [root@station90 桌面]# su - oracle
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 23:04:02 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> alter database open;
- alter database open
- *
- ERROR at line 1:
- ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
- ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:04:26 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN> restore datafile 1;
- Starting restore at 2017-10-01:23:04:32
- using target database control file instead of recovery catalog
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=130 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=194 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=6 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=70 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=131 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=195 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=7 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=71 device type=DISK
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:04:34
- RMAN-06026: some targets not found - aborting restore
- RMAN-06023: no backup or copy of datafile 1 found to restore
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:04:47 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
- connected to recovery catalog database
- RMAN> restore datafile 1;
- Starting restore at 2017-10-01:23:04:50
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=131 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=195 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=7 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=71 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=130 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=193 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=6 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=69 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=132 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=8 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
- channel ORA_SBT_TAPE_1: reading from backup piece 1ks4tgjd_1_1
- channel ORA_SBT_TAPE_1: piece handle=1ks4tgjd_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
- Finished restore at 2017-10-01:23:05:48
- starting full resync of recovery catalog
- full resync complete
- RMAN> recover database;
- Starting recover at 2017-10-01:23:07:40
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of recover command at 10/01/2017 23:07:40
- RMAN-06094: datafile 2 must be restored
- RMAN> restore database;
- Starting restore at 2017-10-01:23:07:55
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:07:55
- RMAN-06026: some targets not found - aborting restore
- RMAN-06023: no backup or copy of datafile 7 found to restore
- RMAN-06023: no backup or copy of datafile 6 found to restore
- RMAN> restore datafile 2,3,4,5;
- Starting restore at 2017-10-01:23:08:03
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.816169553
- channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
- channel ORA_SBT_TAPE_1: reading from backup piece 1ls4tgjd_1_1
- channel ORA_SBT_TAPE_2: starting datafile backup set restore
- channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_2: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.257.816169553
- channel ORA_SBT_TAPE_2: restoring datafile 00004 to +DATA/orcl/datafile/users.259.816169553
- channel ORA_SBT_TAPE_2: reading from backup piece 1ks4tgjd_1_1
- channel ORA_SBT_TAPE_2: piece handle=1ks4tgjd_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_2: restored backup piece 1
- channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:45
- channel ORA_SBT_TAPE_1: piece handle=1ls4tgjd_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
- Finished restore at 2017-10-01:23:09:00
- starting full resync of recovery catalog
- full resync complete
- RMAN> recover database;
- Starting recover at 2017-10-01:23:09:46
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- starting media recovery
- media recovery failed
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of recover command at 10/01/2017 23:09:47
- ORA-00283: recovery session canceled due to errors
- RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
- start
- ORA-00283: recovery session canceled due to errors
- ORA-19909: datafile 1 belongs to an orphan incarnation
- ORA-01110: data file 1: '+DATA/orcl/datafile/system.259.956271921'
- RMAN> restore datafile 1;
- Starting restore at 2017-10-01:23:09:57
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- skipping datafile 1; already restored to file +DATA/orcl/datafile/system.259.956271921
- Finished restore at 2017-10-01:23:09:57
- RMAN> recover database;
- Starting recover at 2017-10-01:23:10:02
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- starting media recovery
- media recovery failed
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of recover command at 10/01/2017 23:10:03
- ORA-00283: recovery session canceled due to errors
- RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
- start
- ORA-00283: recovery session canceled due to errors
- ORA-19909: datafile 1 belongs to an orphan incarnation
- ORA-01110: data file 1: '+DATA/orcl/datafile/system.259.956271921'
- RMAN> list incarnation of database;
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 16 ORCL 1343950367 PARENT 1 2009-08-15:00:16:43
- 1 2 ORCL 1343950367 PARENT 945184 2013-05-23:09:47:15
- 1 288 ORCL 1343950367 CURRENT 2146743 2017-10-01:17:41:47
- RMAN> reset database to incarnation 2
- 2> ;
- database reset to incarnation 2
- target database incarnation not found in control file
- RMAN> reset database to incarnation 2;
- database reset to incarnation 2
- target database incarnation not found in control file
- RMAN> reset database to incarnation 16;
- database reset to incarnation 16
- target database incarnation not found in control file
- RMAN> list incarnation of database;
- database reset to incarnation 288
- starting full resync of recovery catalog
- full resync complete
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 16 ORCL 1343950367 PARENT 1 2009-08-15:00:16:43
- 1 2 ORCL 1343950367 PARENT 945184 2013-05-23:09:47:15
- 1 288 ORCL 1343950367 CURRENT 2146743 2017-10-01:17:41:47
- RMAN> recover database;
- Starting recover at 2017-10-01:23:11:21
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- starting media recovery
- media recovery failed
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of recover command at 10/01/2017 23:11:22
- ORA-00283: recovery session canceled due to errors
- RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
- start
- ORA-00283: recovery session canceled due to errors
- ORA-19909: datafile 1 belongs to an orphan incarnation
- ORA-01110: data file 1: '+DATA/orcl/datafile/system.259.956271921'
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:11:32 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN> recover database;
- Starting recover at 2017-10-01:23:11:34
- using target database control file instead of recovery catalog
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=132 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=193 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=69 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=131 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=195 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=6 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=71 device type=DISK
- starting media recovery
- media recovery failed
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of recover command at 10/01/2017 23:11:36
- ORA-00283: recovery session canceled due to errors
- RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
- start
- ORA-00283: recovery session canceled due to errors
- ORA-19909: datafile 1 belongs to an orphan incarnation
- ORA-01110: data file 1: '+DATA/orcl/datafile/system.259.956271921'
- RMAN> list incarnation of database;
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 1 ORCL 1343950367 CURRENT 2146743 2017-10-01:17:41:47
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:11:53 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
- connected to recovery catalog database
- RMAN> list backup of archivelog all;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 199 2.25M SBT_TAPE 00:00:16 2017-05-22:20:41:07
- BP Key: 204 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
- Handle: 1js4tgij_1_1 Media: station90-000001
- List of Archived Logs in backup set 199
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 106 2025187 2017-05-22:20:25:21 2026772 2017-05-22:20:40:40
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 202 256.00K SBT_TAPE 00:00:17 2017-05-22:20:42:00
- BP Key: 207 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
- Handle: 1ms4tgk7_1_1 Media: station90-000001
- List of Archived Logs in backup set 202
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 107 2026772 2017-05-22:20:40:40 2026853 2017-05-22:20:41:42
- RMAN> restore archivelog all;
- Starting restore at 2017-10-01:23:12:14
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=132 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=195 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=71 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=131 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=196 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=6 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=72 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=7 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- archived log for thread 1 with sequence 108 is already on disk as file +FRA/orcl/archivelog/2017_09_30/thread_1_seq_108.330.956054831
- archived log for thread 1 with sequence 109 is already on disk as file +FRA/orcl/archivelog/2017_09_30/thread_1_seq_109.331.956073239
- archived log for thread 1 with sequence 110 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_110.329.956188847
- archived log for thread 1 with sequence 111 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_111.332.956199775
- archived log for thread 1 with sequence 112 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_112.333.956210433
- archived log for thread 1 with sequence 113 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_113.328.956226935
- archived log for thread 1 with sequence 114 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915
- archived log for thread 1 with sequence 115 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_115.326.956251915
- archived log for thread 1 with sequence 116 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_116.325.956251917
- archived log for thread 1 with sequence 117 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_117.324.956251917
- archived log for thread 1 with sequence 118 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.321.956252509
- archived log for thread 1 with sequence 119 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.320.956252509
- archived log for thread 1 with sequence 120 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_120.319.956252509
- archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_5.318.956253941
- archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_6.311.956253941
- archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_7.310.956253941
- archived log for thread 1 with sequence 8 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_8.309.956254199
- archived log for thread 1 with sequence 9 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_9.308.956254199
- archived log for thread 1 with sequence 10 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_10.307.956254211
- archived log for thread 1 with sequence 12 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_12.305.956254213
- archived log for thread 1 with sequence 13 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_13.304.956254213
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:12:26
- RMAN-06026: some targets not found - aborting restore
- RMAN-06025: no backup of archived log for thread 1 with sequence 11 and starting SCN of 2168471 found to restore
- RMAN> restore archivelog sequence 106;
- Starting restore at 2017-10-01:23:13:12
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:13:12
- RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the repository
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:13:21 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
- connected to recovery catalog database
- RMAN> list backup of archivelog all;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 199 2.25M SBT_TAPE 00:00:16 2017-05-22:20:41:07
- BP Key: 204 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
- Handle: 1js4tgij_1_1 Media: station90-000001
- List of Archived Logs in backup set 199
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 106 2025187 2017-05-22:20:25:21 2026772 2017-05-22:20:40:40
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 202 256.00K SBT_TAPE 00:00:17 2017-05-22:20:42:00
- BP Key: 207 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
- Handle: 1ms4tgk7_1_1 Media: station90-000001
- List of Archived Logs in backup set 202
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 107 2026772 2017-05-22:20:40:40 2026853 2017-05-22:20:41:42
- RMAN> restore archivelog sequence 106;
- Starting restore at 2017-10-01:23:13:39
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=130 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=196 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=7 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=71 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=131 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=195 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=6 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=72 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=132 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=8 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:13:51
- RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the repository
- RMAN> restore archivelog sequence 107;
- Starting restore at 2017-10-01:23:14:21
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:14:21
- RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the repository
- RMAN> restore archivelog sequence 107 thread 1;
- Starting restore at 2017-10-01:23:14:32
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:14:32
- RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the repository
- RMAN> list incarnation of archivelog all;
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-00558: error encountered while parsing input commands
- RMAN-01009: syntax error: found "archivelog": expecting one of: "database"
- RMAN-01007: at line 1 column 21 file: standard input
- RMAN> list backup of archivelog all;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 199 2.25M SBT_TAPE 00:00:16 2017-05-22:20:41:07
- BP Key: 204 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
- Handle: 1js4tgij_1_1 Media: station90-000001
- List of Archived Logs in backup set 199
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 106 2025187 2017-05-22:20:25:21 2026772 2017-05-22:20:40:40
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 202 256.00K SBT_TAPE 00:00:17 2017-05-22:20:42:00
- BP Key: 207 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
- Handle: 1ms4tgk7_1_1 Media: station90-000001
- List of Archived Logs in backup set 202
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 107 2026772 2017-05-22:20:40:40 2026853 2017-05-22:20:41:42
- RMAN> restore archivelog all from tag '0T_INCR0_WHOLE';
- Starting restore at 2017-10-01:23:15:17
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- archived log for thread 1 with sequence 108 is already on disk as file +FRA/orcl/archivelog/2017_09_30/thread_1_seq_108.330.956054831
- archived log for thread 1 with sequence 109 is already on disk as file +FRA/orcl/archivelog/2017_09_30/thread_1_seq_109.331.956073239
- archived log for thread 1 with sequence 110 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_110.329.956188847
- archived log for thread 1 with sequence 111 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_111.332.956199775
- archived log for thread 1 with sequence 112 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_112.333.956210433
- archived log for thread 1 with sequence 113 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_113.328.956226935
- archived log for thread 1 with sequence 114 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915
- archived log for thread 1 with sequence 115 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_115.326.956251915
- archived log for thread 1 with sequence 116 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_116.325.956251917
- archived log for thread 1 with sequence 117 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_117.324.956251917
- archived log for thread 1 with sequence 118 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.321.956252509
- archived log for thread 1 with sequence 119 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.320.956252509
- archived log for thread 1 with sequence 120 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_120.319.956252509
- archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_5.318.956253941
- archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_6.311.956253941
- archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_7.310.956253941
- archived log for thread 1 with sequence 8 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_8.309.956254199
- archived log for thread 1 with sequence 9 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_9.308.956254199
- archived log for thread 1 with sequence 10 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_10.307.956254211
- archived log for thread 1 with sequence 12 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_12.305.956254213
- archived log for thread 1 with sequence 13 is already on disk as file +FRA/orcl/archivelog/2017_10_01/thread_1_seq_13.304.956254213
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:15:17
- RMAN-06026: some targets not found - aborting restore
- RMAN-06025: no backup of archived log for thread 1 with sequence 11 and starting SCN of 2168471 found to restore
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 23:15:55 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> recover database until cancel using backup controlfile;
- ORA-00283: recovery session canceled due to errors
- ORA-19909: datafile 1 belongs to an orphan incarnation
- ORA-01110: data file 1: '+DATA/orcl/datafile/system.259.956271921'
- SQL> alter database backup controlfile to trace as '/home/oracle/control1.sql';
- Database altered.
- SQL> shutdown abort
- ORACLE instance shut down.
- SQL>
- -----------------------------------
- CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS ARCHIVELOG
- MAXLOGFILES 16
- MAXLOGMEMBERS 3
- MAXDATAFILES 100
- MAXINSTANCES 8
- MAXLOGHISTORY 292
- LOGFILE
- GROUP 1 (
- '+DATA/orcl/onlinelog/group_1.261.816169635',
- '+FRA/orcl/onlinelog/group_1.257.816169637'
- ) SIZE 50M BLOCKSIZE 512,
- GROUP 2 (
- '+DATA/orcl/onlinelog/group_2.262.816169639',
- '+FRA/orcl/onlinelog/group_2.258.816169639'
- ) SIZE 50M BLOCKSIZE 512,
- GROUP 3 (
- '+DATA/orcl/onlinelog/group_3.263.816169641',
- '+FRA/orcl/onlinelog/group_3.259.816169641'
- ) SIZE 50M BLOCKSIZE 512
- DATAFILE
- '+DATA/orcl/datafile/system.259.956271921',
- '+DATA/orcl/datafile/sysaux.265.956272109',
- '+DATA/orcl/datafile/undotbs1.258.956272109',
- '+DATA/orcl/datafile/users.257.956272109',
- '+DATA/orcl/datafile/example.256.956272109',
- '+DATA/orcl/datafile/tbsocp05_test2.267.956251909',
- '+DATA/orcl/datafile/tbsocp05_test3.268.956253241'
- CHARACTER SET AL32UTF8
- ;
- -- Configure RMAN configuration record 1
- VARIABLE RECNO NUMBER;
- EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON');
- -- Configure RMAN configuration record 2
- VARIABLE RECNO NUMBER;
- EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEFAULT DEVICE TYPE TO','''SBT_TAPE''');
- -- Configure RMAN configuration record 3
- VARIABLE RECNO NUMBER;
- EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');
- --------------------------
- SQL> conn / as sysdba
- Connected.
- SQL> @control1.sql
- CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS ARCHIVELOG
- *
- ERROR at line 1:
- ORA-01503: CREATE CONTROLFILE failed
- ORA-01189: file is from a different RESETLOGS than previous files
- ORA-01110: data file 6: '+DATA/orcl/datafile/tbsocp05_test2.267.956251909'
- BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON'); END;
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
- ORA-06512: at line 1
- BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEFAULT DEVICE TYPE TO','''SBT_TAPE'''); END;
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
- ORA-06512: at line 1
- BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON'); END;
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
- ORA-06512: at line 1
- BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET'); END;
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
- ORA-06512: at line 1
- BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','''SBT_TAPE'' PARALLELISM 2 BACKUP TYPE TO BACKUPSET'); END;
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
- ORA-06512: at line 1
- BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','1 DEVICE TYPE ''SBT_TAPE'' PARMS ''ENV=(OB_MEDIA_FAMILY=station90)'''); END;
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
- ORA-06512: at line 1
- BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','2 DEVICE TYPE ''SBT_TAPE'' PARMS ''ENV=(OB_MEDIA_FAMILY=station90)'''); END;
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
- ORA-06512: at line 1
- BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('RETENTION POLICY','TO RECOVERY WINDOW OF 1 DAYS'); END;
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
- ORA-06512: at line 1
- ORA-01507: database not mounted
- ALTER DATABASE OPEN RESETLOGS
- *
- ERROR at line 1:
- ORA-01507: database not mounted
- ALTER TABLESPACE TEMP ADD TEMPFILE '+DATA/orcl/tempfile/temp.269.956253949' REUSE
- *
- ERROR at line 1:
- ORA-01109: database not open
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ vim control1.sql
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 23:19:58 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> @control1.sql
- Control file created.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- ORA-00279: change 2026814 generated at 05/22/2017 20:41:17 needed for thread 1
- ORA-00289: suggestion : +FRA
- ORA-00280: change 2026814 for thread 1 is in sequence #107
- ORA-00283: recovery session canceled due to errors
- ORA-19906: recovery target incarnation changed during recovery
- ORA-01112: media recovery not started
- ALTER DATABASE OPEN RESETLOGS
- *
- ERROR at line 1:
- ORA-01152: file 3 was not restored from a sufficiently old backup
- ORA-01110: data file 3: '+DATA/orcl/datafile/undotbs1.258.956272109'
- ALTER TABLESPACE TEMP ADD TEMPFILE '+DATA/orcl/tempfile/temp.269.956253949' REUSE
- *
- ERROR at line 1:
- ORA-01109: database not open
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ vim control1.sql
- [oracle@station90 ~]$ ls
- afiedt.buf copytape-root.sh oradiag_oracle select_t04209_uname.sql ulcase_good 文档
- asm create_t04209_uname.sql osb.txt t05310-2.sql update2_t04209_uname.sql 下载
- asm2 dir1 pwd.sql t05310.sql update_t04209_uname.sql 音乐
- backup dir2 rac_tns test 公共的 桌面
- control13b-after.sql export.log rcat.sql tnsnames.ora 模板
- control15a.sql import.log revertape-root.sh ttio.rcv 视频
- control1.sql mail save_files u90.dmp 图片
- [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:20:58 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
- connected to recovery catalog database
- RMAN> restore archivelog sequence 107 thread 1;
- Starting restore at 2017-10-01:23:21:04
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=130 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=194 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=6 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=70 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=195 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=7 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=71 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=131 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=196 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=72 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:21:17
- RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the repository
- RMAN> list incarnation of database;
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 16 ORCL 1343950367 PARENT 1 2009-08-15:00:16:43
- 1 2 ORCL 1343950367 PARENT 945184 2013-05-23:09:47:15
- 1 288 ORCL 1343950367 CURRENT 2146743 2017-10-01:17:41:47
- RMAN> reset database to incarnation 2;
- database reset to incarnation 2
- RMAN> restore archivelog sequence 107 thread 1;
- Starting restore at 2017-10-01:23:21:40
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log restore to default destination
- channel ORA_SBT_TAPE_1: restoring archived log
- archived log thread=1 sequence=107
- channel ORA_SBT_TAPE_1: reading from backup piece 1ms4tgk7_1_1
- channel ORA_SBT_TAPE_1: piece handle=1ms4tgk7_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
- Finished restore at 2017-10-01:23:22:06
- RMAN> list incarnation of database;
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 16 ORCL 1343950367 PARENT 1 2009-08-15:00:16:43
- 1 2 ORCL 1343950367 CURRENT 945184 2013-05-23:09:47:15
- 1 288 ORCL 1343950367 ORPHAN 2146743 2017-10-01:17:41:47
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:22:38 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
- connected to recovery catalog database
- RMAN> reset database to incarnation 288;
- database reset to incarnation 288
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 23:22:51 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> recover database until cancel using backup controlfile;
- ORA-00279: change 2026814 generated at 05/22/2017 20:41:17 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_107.303.956272923
- ORA-00280: change 2026814 for thread 1 is in sequence #107
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- ORA-00279: change 2026853 generated at 05/22/2017 20:41:42 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_09_30/thread_1_seq_108.330.956054831
- ORA-00280: change 2026853 for thread 1 is in sequence #108
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_107.303.956272923' no longer
- needed for this recovery
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2047121 generated at 09/30/2017 10:47:10 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_09_30/thread_1_seq_109.331.956073239
- ORA-00280: change 2047121 for thread 1 is in sequence #109
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_09_30/thread_1_seq_108.330.956054831' no longer
- needed for this recovery
- ORA-00279: change 2075627 generated at 09/30/2017 15:53:57 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_110.329.956188847
- ORA-00280: change 2075627 for thread 1 is in sequence #110
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_09_30/thread_1_seq_109.331.956073239' no longer
- needed for this recovery
- ORA-00279: change 2095928 generated at 10/01/2017 00:00:47 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_111.332.956199775
- ORA-00280: change 2095928 for thread 1 is in sequence #111
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_110.329.956188847' no longer
- needed for this recovery
- ORA-00279: change 2112955 generated at 10/01/2017 03:02:54 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_112.333.956210433
- ORA-00280: change 2112955 for thread 1 is in sequence #112
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_111.332.956199775' no longer
- needed for this recovery
- ORA-00279: change 2126559 generated at 10/01/2017 06:00:33 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_113.328.956226935
- ORA-00280: change 2126559 for thread 1 is in sequence #113
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_112.333.956210433' no longer
- needed for this recovery
- ORA-00279: change 2137343 generated at 10/01/2017 10:35:34 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915
- ORA-00280: change 2137343 for thread 1 is in sequence #114
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_113.328.956226935' no longer
- needed for this recovery
- ORA-00283: recovery session canceled due to errors
- ORA-01244: unnamed datafile(s) added to control file by media recovery
- ORA-01110: data file 6: '+DATA/orcl/datafile/tbsocp05_test2.267.956251909'
- ORA-01112: media recovery not started
- SQL> alter database datafile 6 offline ;
- Database altered.
- SQL> recover database until cancel using backup controlfile;
- ORA-00279: change 2146334 generated at 10/01/2017 17:31:49 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915
- ORA-00280: change 2146334 for thread 1 is in sequence #114
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2146609 generated at 10/01/2017 17:31:53 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_115.326.956251915
- ORA-00280: change 2146609 for thread 1 is in sequence #115
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915' no longer
- needed for this recovery
- ORA-00279: change 2146626 generated at 10/01/2017 17:31:54 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_116.325.956251917
- ORA-00280: change 2146626 for thread 1 is in sequence #116
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_115.326.956251915' no longer
- needed for this recovery
- ORA-00279: change 2146632 generated at 10/01/2017 17:31:56 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_117.324.956251917
- ORA-00280: change 2146632 for thread 1 is in sequence #117
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_116.325.956251917' no longer
- needed for this recovery
- ORA-00279: change 2146635 generated at 10/01/2017 17:31:56 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.321.956252509
- ORA-00280: change 2146635 for thread 1 is in sequence #118
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_117.324.956251917' no longer
- needed for this recovery
- ORA-00279: change 2146641 generated at 10/01/2017 17:31:57 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.320.956252509
- ORA-00280: change 2146641 for thread 1 is in sequence #119
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.321.956252509' no longer
- needed for this recovery
- ORA-00279: change 2146647 generated at 10/01/2017 17:31:59 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_120.319.956252509
- ORA-00280: change 2146647 for thread 1 is in sequence #120
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.320.956252509' no longer
- needed for this recovery
- ORA-00279: change 2146743 generated at 10/01/2017 17:41:47 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_1.317.956253247
- ORA-00280: change 2146743 for thread 1 is in sequence #1
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_120.319.956252509' no longer
- needed for this recovery
- ORA-00283: recovery session canceled due to errors
- ORA-01244: unnamed datafile(s) added to control file by media recovery
- ORA-01110: data file 7: '+DATA/orcl/datafile/tbsocp05_test3.268.956253241'
- ORA-01112: media recovery not started
- SQL> alter database datafile 7 offline;
- Database altered.
- SQL> recover database until cancel using backup controlfile;
- ORA-00279: change 2147423 generated at 10/01/2017 17:54:02 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_1.317.956253247
- ORA-00280: change 2147423 for thread 1 is in sequence #1
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2147698 generated at 10/01/2017 17:54:06 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_2.316.956253247
- ORA-00280: change 2147698 for thread 1 is in sequence #2
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_1.317.956253247' no longer needed
- for this recovery
- ORA-00279: change 2147730 generated at 10/01/2017 17:54:07 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_3.315.956253251
- ORA-00280: change 2147730 for thread 1 is in sequence #3
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_2.316.956253247' no longer needed
- for this recovery
- ORA-00279: change 2147770 generated at 10/01/2017 17:54:11 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_4.314.956253255
- ORA-00280: change 2147770 for thread 1 is in sequence #4
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_3.315.956253251' no longer needed
- for this recovery
- ORA-00279: change 2147773 generated at 10/01/2017 17:54:14 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_5.318.956253941
- ORA-00280: change 2147773 for thread 1 is in sequence #5
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_4.314.956253255' no longer needed
- for this recovery
- ORA-00279: change 2147780 generated at 10/01/2017 17:54:17 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_6.311.956253941
- ORA-00280: change 2147780 for thread 1 is in sequence #6
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_5.318.956253941' no longer needed
- for this recovery
- ORA-00279: change 2147785 generated at 10/01/2017 17:54:18 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_7.310.956253941
- ORA-00280: change 2147785 for thread 1 is in sequence #7
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_6.311.956253941' no longer needed
- for this recovery
- ORA-00279: change 2167834 generated at 10/01/2017 18:05:41 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_8.309.956254199
- ORA-00280: change 2167834 for thread 1 is in sequence #8
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_7.310.956253941' no longer needed
- for this recovery
- ORA-00279: change 2168445 generated at 10/01/2017 18:09:58 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_9.308.956254199
- ORA-00280: change 2168445 for thread 1 is in sequence #9
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_8.309.956254199' no longer needed
- for this recovery
- ORA-00279: change 2168463 generated at 10/01/2017 18:09:58 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_10.307.956254211
- ORA-00280: change 2168463 for thread 1 is in sequence #10
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_9.308.956254199' no longer needed
- for this recovery
- ORA-00279: change 2168471 generated at 10/01/2017 18:10:10 needed for thread 1
- ORA-00289: suggestion : +FRA
- ORA-00280: change 2168471 for thread 1 is in sequence #11
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_10.307.956254211' no longer
- needed for this recovery
- ORA-00308: cannot open archived log '+FRA'
- ORA-17503: ksfdopn:2 Failed to open file +FRA
- ORA-15045: ASM file name '+FRA' is not in reference form
- SQL>
- --------
- [oracle@station90 ~]$ asmcmd ls +fra/orcl/ARCHIVELOG/2017_10_01/ | sort -n -t . -k 3
- thread_1_seq_110.329.956188847
- thread_1_seq_111.332.956199775
- thread_1_seq_112.333.956210433
- thread_1_seq_113.328.956226935
- thread_1_seq_114.327.956251915
- thread_1_seq_115.326.956251915
- thread_1_seq_116.325.956251917
- thread_1_seq_117.324.956251917
- thread_1_seq_118.323.956251919
- thread_1_seq_119.322.956251919
- thread_1_seq_118.321.956252509
- thread_1_seq_119.320.956252509
- thread_1_seq_120.319.956252509
- thread_1_seq_1.317.956253247
- thread_1_seq_2.316.956253247
- thread_1_seq_3.315.956253251
- thread_1_seq_4.314.956253255
- thread_1_seq_5.313.956253259
- thread_1_seq_6.312.956253259
- thread_1_seq_5.318.956253941
- thread_1_seq_6.311.956253941
- thread_1_seq_7.310.956253941
- thread_1_seq_8.309.956254199
- thread_1_seq_9.308.956254199
- thread_1_seq_10.307.956254211
- thread_1_seq_12.305.956254213
- thread_1_seq_13.304.956254213
- thread_1_seq_107.303.956272923
- ------------------------
复制代码 关键:
- [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:20:58 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
- connected to recovery catalog database
- RMAN> restore archivelog sequence 107 thread 1;
- Starting restore at 2017-10-01:23:21:04
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=130 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=194 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=6 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=70 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=195 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=7 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=71 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=131 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=196 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=72 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 10/01/2017 23:21:17
- RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the repository
- RMAN> list incarnation of database;
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 16 ORCL 1343950367 PARENT 1 2009-08-15:00:16:43
- 1 2 ORCL 1343950367 PARENT 945184 2013-05-23:09:47:15
- 1 288 ORCL 1343950367 CURRENT 2146743 2017-10-01:17:41:47
- RMAN> reset database to incarnation 2;
- database reset to incarnation 2
- RMAN> restore archivelog sequence 107 thread 1;
- Starting restore at 2017-10-01:23:21:40
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log restore to default destination
- channel ORA_SBT_TAPE_1: restoring archived log
- archived log thread=1 sequence=107
- channel ORA_SBT_TAPE_1: reading from backup piece 1ms4tgk7_1_1
- channel ORA_SBT_TAPE_1: piece handle=1ms4tgk7_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
- Finished restore at 2017-10-01:23:22:06
- RMAN> list incarnation of database;
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 16 ORCL 1343950367 PARENT 1 2009-08-15:00:16:43
- 1 2 ORCL 1343950367 CURRENT 945184 2013-05-23:09:47:15
- 1 288 ORCL 1343950367 ORPHAN 2146743 2017-10-01:17:41:47
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 1 23:22:38 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
- connected to recovery catalog database
- RMAN> reset database to incarnation 288;
- database reset to incarnation 288
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 1 23:22:51 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> recover database until cancel using backup controlfile;
- ORA-00279: change 2026814 generated at 05/22/2017 20:41:17 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_107.303.956272923
- ORA-00280: change 2026814 for thread 1 is in sequence #107
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- ORA-00279: change 2026853 generated at 05/22/2017 20:41:42 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_09_30/thread_1_seq_108.330.956054831
- ORA-00280: change 2026853 for thread 1 is in sequence #108
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_107.303.956272923' no longer
- needed for this recovery
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2047121 generated at 09/30/2017 10:47:10 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_09_30/thread_1_seq_109.331.956073239
- ORA-00280: change 2047121 for thread 1 is in sequence #109
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_09_30/thread_1_seq_108.330.956054831' no longer
- needed for this recovery
- ORA-00279: change 2075627 generated at 09/30/2017 15:53:57 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_110.329.956188847
- ORA-00280: change 2075627 for thread 1 is in sequence #110
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_09_30/thread_1_seq_109.331.956073239' no longer
- needed for this recovery
- ORA-00279: change 2095928 generated at 10/01/2017 00:00:47 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_111.332.956199775
- ORA-00280: change 2095928 for thread 1 is in sequence #111
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_110.329.956188847' no longer
- needed for this recovery
- ORA-00279: change 2112955 generated at 10/01/2017 03:02:54 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_112.333.956210433
- ORA-00280: change 2112955 for thread 1 is in sequence #112
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_111.332.956199775' no longer
- needed for this recovery
- ORA-00279: change 2126559 generated at 10/01/2017 06:00:33 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_113.328.956226935
- ORA-00280: change 2126559 for thread 1 is in sequence #113
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_112.333.956210433' no longer
- needed for this recovery
- ORA-00279: change 2137343 generated at 10/01/2017 10:35:34 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915
- ORA-00280: change 2137343 for thread 1 is in sequence #114
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_113.328.956226935' no longer
- needed for this recovery
- ORA-00283: recovery session canceled due to errors
- ORA-01244: unnamed datafile(s) added to control file by media recovery
- ORA-01110: data file 6: '+DATA/orcl/datafile/tbsocp05_test2.267.956251909'
- ORA-01112: media recovery not started
- SQL> alter database datafile 6 offline ;
- Database altered.
- SQL> recover database until cancel using backup controlfile;
- ORA-00279: change 2146334 generated at 10/01/2017 17:31:49 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915
- ORA-00280: change 2146334 for thread 1 is in sequence #114
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2146609 generated at 10/01/2017 17:31:53 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_115.326.956251915
- ORA-00280: change 2146609 for thread 1 is in sequence #115
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915' no longer
- needed for this recovery
- ORA-00279: change 2146626 generated at 10/01/2017 17:31:54 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_116.325.956251917
- ORA-00280: change 2146626 for thread 1 is in sequence #116
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_115.326.956251915' no longer
- needed for this recovery
- ORA-00279: change 2146632 generated at 10/01/2017 17:31:56 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_117.324.956251917
- ORA-00280: change 2146632 for thread 1 is in sequence #117
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_116.325.956251917' no longer
- needed for this recovery
- ORA-00279: change 2146635 generated at 10/01/2017 17:31:56 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.321.956252509
- ORA-00280: change 2146635 for thread 1 is in sequence #118
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_117.324.956251917' no longer
- needed for this recovery
- ORA-00279: change 2146641 generated at 10/01/2017 17:31:57 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.320.956252509
- ORA-00280: change 2146641 for thread 1 is in sequence #119
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.321.956252509' no longer
- needed for this recovery
- ORA-00279: change 2146647 generated at 10/01/2017 17:31:59 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_120.319.956252509
- ORA-00280: change 2146647 for thread 1 is in sequence #120
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.320.956252509' no longer
- needed for this recovery
- ORA-00279: change 2146743 generated at 10/01/2017 17:41:47 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_1.317.956253247
- ORA-00280: change 2146743 for thread 1 is in sequence #1
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_120.319.956252509' no longer
- needed for this recovery
- ORA-00283: recovery session canceled due to errors
- ORA-01244: unnamed datafile(s) added to control file by media recovery
- ORA-01110: data file 7: '+DATA/orcl/datafile/tbsocp05_test3.268.956253241'
- ORA-01112: media recovery not started
- SQL> alter database datafile 7 offline;
- Database altered.
- SQL> recover database until cancel using backup controlfile;
- ORA-00279: change 2147423 generated at 10/01/2017 17:54:02 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_1.317.956253247
- ORA-00280: change 2147423 for thread 1 is in sequence #1
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2147698 generated at 10/01/2017 17:54:06 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_2.316.956253247
- ORA-00280: change 2147698 for thread 1 is in sequence #2
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_1.317.956253247' no longer needed
- for this recovery
- ORA-00279: change 2147730 generated at 10/01/2017 17:54:07 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_3.315.956253251
- ORA-00280: change 2147730 for thread 1 is in sequence #3
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_2.316.956253247' no longer needed
- for this recovery
- ORA-00279: change 2147770 generated at 10/01/2017 17:54:11 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_4.314.956253255
- ORA-00280: change 2147770 for thread 1 is in sequence #4
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_3.315.956253251' no longer needed
- for this recovery
- ORA-00279: change 2147773 generated at 10/01/2017 17:54:14 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_5.318.956253941
- ORA-00280: change 2147773 for thread 1 is in sequence #5
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_4.314.956253255' no longer needed
- for this recovery
- ORA-00279: change 2147780 generated at 10/01/2017 17:54:17 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_6.311.956253941
- ORA-00280: change 2147780 for thread 1 is in sequence #6
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_5.318.956253941' no longer needed
- for this recovery
- ORA-00279: change 2147785 generated at 10/01/2017 17:54:18 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_7.310.956253941
- ORA-00280: change 2147785 for thread 1 is in sequence #7
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_6.311.956253941' no longer needed
- for this recovery
- ORA-00279: change 2167834 generated at 10/01/2017 18:05:41 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_8.309.956254199
- ORA-00280: change 2167834 for thread 1 is in sequence #8
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_7.310.956253941' no longer needed
- for this recovery
- ORA-00279: change 2168445 generated at 10/01/2017 18:09:58 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_9.308.956254199
- ORA-00280: change 2168445 for thread 1 is in sequence #9
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_8.309.956254199' no longer needed
- for this recovery
- ORA-00279: change 2168463 generated at 10/01/2017 18:09:58 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_10.307.956254211
- ORA-00280: change 2168463 for thread 1 is in sequence #10
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_9.308.956254199' no longer needed
- for this recovery
- ORA-00279: change 2168471 generated at 10/01/2017 18:10:10 needed for thread 1
- ORA-00289: suggestion : +FRA
- ORA-00280: change 2168471 for thread 1 is in sequence #11
- ORA-00278: log file
- '+FRA/orcl/archivelog/2017_10_01/thread_1_seq_10.307.956254211' no longer
- needed for this recovery
- ORA-00308: cannot open archived log '+FRA'
- ORA-17503: ksfdopn:2 Failed to open file +FRA
- ORA-15045: ASM file name '+FRA' is not in reference form
- SQL> !clear
- SQL> recover database until cancel using backup controlfile;
- ORA-00279: change 2168471 generated at 10/01/2017 18:10:10 needed for thread 1
- ORA-00289: suggestion : +FRA
- ORA-00280: change 2168471 for thread 1 is in sequence #11
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- cancel
- Media recovery cancelled.
- SQL> alter database open ;
- alter database open
- *
- ERROR at line 1:
- ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
- SQL> alter database open resetlogs;
- Database altered.
- SQL> select name , status from v$datafile;
- NAME
- --------------------------------------------------------------------------------
- STATUS
- -------
- +DATA/orcl/datafile/system.259.956271921
- SYSTEM
- +DATA/orcl/datafile/sysaux.265.956272109
- ONLINE
- +DATA/orcl/datafile/undotbs1.258.956272109
- ONLINE
- NAME
- --------------------------------------------------------------------------------
- STATUS
- -------
- +DATA/orcl/datafile/users.257.956272109
- ONLINE
- +DATA/orcl/datafile/example.256.956272109
- ONLINE
- /u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006
- OFFLINE
- NAME
- --------------------------------------------------------------------------------
- STATUS
- -------
- /u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00007
- OFFLINE
- 7 rows selected.
- SQL> alter database rename file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006' to '+data/orcl/datafile/TBSOCP05_TEST2.267.956251909';
- Database altered.
- SQL> alter database rename file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00007' to '+data/orcl/datafile/TBSOCP05_TEST3.268.956253241';
- Database altered.
- SQL> alter database create datafile 6 ;
- Database altered.
- SQL> alter database create datafile 7 ;
- Database altered.
- SQL> recover datafile 6;
- ORA-00279: change 2146329 generated at 10/01/2017 17:31:49 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_114.327.956251915
- ORA-00280: change 2146329 for thread 1 is in sequence #114
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- ORA-00279: change 2146609 generated at 10/01/2017 17:31:53 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_115.326.956251915
- ORA-00280: change 2146609 for thread 1 is in sequence #115
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- ORA-00279: change 2146626 generated at 10/01/2017 17:31:54 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_116.325.956251917
- ORA-00280: change 2146626 for thread 1 is in sequence #116
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2146632 generated at 10/01/2017 17:31:56 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_117.324.956251917
- ORA-00280: change 2146632 for thread 1 is in sequence #117
- ORA-00279: change 2146635 generated at 10/01/2017 17:31:56 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_118.321.956252509
- ORA-00280: change 2146635 for thread 1 is in sequence #118
- ORA-00279: change 2146641 generated at 10/01/2017 17:31:57 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_119.320.956252509
- ORA-00280: change 2146641 for thread 1 is in sequence #119
- ORA-00279: change 2146647 generated at 10/01/2017 17:31:59 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_120.319.956252509
- ORA-00280: change 2146647 for thread 1 is in sequence #120
- ORA-00279: change 2146743 generated at 10/01/2017 17:41:47 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_1.317.956253247
- ORA-00280: change 2146743 for thread 1 is in sequence #1
- ORA-00279: change 2147698 generated at 10/01/2017 17:54:06 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_2.316.956253247
- ORA-00280: change 2147698 for thread 1 is in sequence #2
- ORA-00279: change 2147730 generated at 10/01/2017 17:54:07 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_3.315.956253251
- ORA-00280: change 2147730 for thread 1 is in sequence #3
- ORA-00279: change 2147770 generated at 10/01/2017 17:54:11 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_4.314.956253255
- ORA-00280: change 2147770 for thread 1 is in sequence #4
- ORA-00279: change 2147773 generated at 10/01/2017 17:54:14 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_5.318.956253941
- ORA-00280: change 2147773 for thread 1 is in sequence #5
- ORA-00279: change 2147780 generated at 10/01/2017 17:54:17 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_6.311.956253941
- ORA-00280: change 2147780 for thread 1 is in sequence #6
- ORA-00279: change 2147785 generated at 10/01/2017 17:54:18 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_7.310.956253941
- ORA-00280: change 2147785 for thread 1 is in sequence #7
- ORA-00279: change 2167834 generated at 10/01/2017 18:05:41 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_8.309.956254199
- ORA-00280: change 2167834 for thread 1 is in sequence #8
- ORA-00279: change 2168445 generated at 10/01/2017 18:09:58 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_9.308.956254199
- ORA-00280: change 2168445 for thread 1 is in sequence #9
- ORA-00279: change 2168463 generated at 10/01/2017 18:09:58 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_10.307.956254211
- ORA-00280: change 2168463 for thread 1 is in sequence #10
- Log applied.
- Media recovery complete.
- SQL> recover datafile 7;
- ORA-00279: change 2147418 generated at 10/01/2017 17:54:01 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_1.317.956253247
- ORA-00280: change 2147418 for thread 1 is in sequence #1
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2147698 generated at 10/01/2017 17:54:06 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_2.316.956253247
- ORA-00280: change 2147698 for thread 1 is in sequence #2
- ORA-00279: change 2147730 generated at 10/01/2017 17:54:07 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_3.315.956253251
- ORA-00280: change 2147730 for thread 1 is in sequence #3
- ORA-00279: change 2147770 generated at 10/01/2017 17:54:11 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_4.314.956253255
- ORA-00280: change 2147770 for thread 1 is in sequence #4
- ORA-00279: change 2147773 generated at 10/01/2017 17:54:14 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_5.318.956253941
- ORA-00280: change 2147773 for thread 1 is in sequence #5
- ORA-00279: change 2147780 generated at 10/01/2017 17:54:17 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_6.311.956253941
- ORA-00280: change 2147780 for thread 1 is in sequence #6
- ORA-00279: change 2147785 generated at 10/01/2017 17:54:18 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_7.310.956253941
- ORA-00280: change 2147785 for thread 1 is in sequence #7
- ORA-00279: change 2167834 generated at 10/01/2017 18:05:41 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_8.309.956254199
- ORA-00280: change 2167834 for thread 1 is in sequence #8
- ORA-00279: change 2168445 generated at 10/01/2017 18:09:58 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_9.308.956254199
- ORA-00280: change 2168445 for thread 1 is in sequence #9
- ORA-00279: change 2168463 generated at 10/01/2017 18:09:58 needed for thread 1
- ORA-00289: suggestion :
- +FRA/orcl/archivelog/2017_10_01/thread_1_seq_10.307.956254211
- ORA-00280: change 2168463 for thread 1 is in sequence #10
- Log applied.
- Media recovery complete.
- SQL> select tablespace_name ,status from dba_tablespaces;
- TABLESPACE_NAME STATUS
- ------------------------------ ---------
- SYSTEM ONLINE
- SYSAUX ONLINE
- UNDOTBS1 ONLINE
- TEMP ONLINE
- USERS ONLINE
- EXAMPLE ONLINE
- TBSOCP05_TEST2 ONLINE
- TBSOCP05_TEST3 ONLINE
- 8 rows selected.
- SQL> alter database datafile 6 online;
- Database altered.
- SQL> alter database datafile 7 online;
- Database altered.
- SQL>
复制代码
|
|