在备库上备份,在主库上恢复control file和recovery catalog的同步
rman target / catalog rco/dingjia@192.168.17.201/test1 run{ allocate channel c1 type 'sbt_tape' parms=' SBT_LIBRARY=/opt/scutech/dbackup3/lib/libobk.so, ENV=(URL=http://192.168.87.155:50306/d2/data/0d36020eecec11ea8000b49691622ac4/c7873e9aed0811ea8000b49691622ac4, EXTRA=X-Access-Key:ea5350ac00fa61d08533a729da808de0)' trace=0; backup tablespace ex1; } LIST DB_UNIQUE_NAME OF DATABASE; list backup summary for db_unique_name 'orcl1by'; changebackup tag='standby_backup_1' for db_unique_name orcl reset db_unique_name;
RMAN> host 'rm /u01/app/oracle/oradata/orcl/ex1.dbf'; host command complete RMAN> validate datafile 13; Starting validate at Sep 09 2020 11:51:13 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=378 device type=DISK channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of validate command on ORA_DISK_1 channel at 09/09/2020 11:51:14 ORA-01122: database file 13 failed verification check ORA-01110: data file 13: '/u01/app/oracle/oradata/orcl/ex1.dbf' ORA-01565: error in identifying file '/u01/app/oracle/oradata/orcl/ex1.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 RMAN> list failure; Database Role: PRIMARY List of Database Failures ========================= Failure ID Priority Status Time Detected Summary ---------- -------- --------- -------------------- ------- 1642 HIGH OPEN Sep 09 2020 11:46:03 One or more non-system datafiles are missing RMAN> advise failure; Database Role: PRIMARY List of Database Failures ========================= Failure ID Priority Status Time Detected Summary ---------- -------- --------- -------------------- ------- 1642 HIGH OPEN Sep 09 2020 11:46:03 One or more non-system datafiles are missing analyzing automatic repair options; this may take some time using channel ORA_DISK_1 analyzing automatic repair options complete Mandatory Manual Actions ======================== 1. If file /u01/app/oracle/oradata/orcl/ex1.dbf was unintentionally renamed or moved, restore it 2. If you have an export of tablespace EX1, then drop and re-create the tablespace and import the data. 3. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair Optional Manual Actions ======================= 1. Shut down, mount the database and try flush redo using ALTER SYSTEM FLUSH REDO TO 'standby name' command. Then perform a Data Guard role change (failover). Available standbys: orcl1by. Automated Repair Options ======================== no automatic repair options available RMAN> RMAN> RMAN> ALTER TABLESPACE ex1 offline immediate; Statement processed RMAN> run{ allocate channel c1 type 'sbt_tape' parms=' SBT_LIBRARY=/opt/scutech/dbackup3/lib/libobk.so, ENV=(URL=http://192.168.87.155:50306/d2/data/0d36020eecec11ea8000b49691622ac4/c7873e9aed0811ea8000b49691622ac4, EXTRA=X-Access-Key:ea5350ac00fa61d08533a729da808de0)' trace=0; restore tablespace ex1; } 2> 3> 4> 5> 6> 7> released channel: ORA_DISK_1 allocated channel: c1 channel c1: SID=378 device type=SBT_TAPE channel c1: DBackup3 Oracle MMS Library Starting restore at Sep 09 2020 11:51:45 channel c1: starting datafile backup set restore channel c1: specifying datafile(s) to restore from backup set channel c1: restoring datafile 00013 to /u01/app/oracle/oradata/orcl/ex1.dbf channel c1: reading from backup piece 66v9vp9q_1_1 channel c1: piece handle=66v9vp9q_1_1 tag=TAG20200909T114458 channel c1: restored backup piece 1 channel c1: restore complete, elapsed time: 00:00:01 Finished restore at Sep 09 2020 11:51:48 released channel: c1 RMAN> recover tablespace ex1; Starting recover at Sep 09 2020 11:53:12 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=378 device type=DISK starting media recovery archived log for thread 1 with sequence 279 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2020_09_08/o1_mf_1_279_hogz5ylq_.arc archived log for thread 1 with sequence 280 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2020_09_08/o1_mf_1_280_hoh3qxk1_.arc archived log for thread 1 with sequence 281 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2020_09_08/o1_mf_1_281_hoh7bow0_.arc archived log for thread 1 with sequence 282 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2020_09_09/o1_mf_1_282_hohw8y8y_.arc archived log for thread 1 with sequence 283 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2020_09_09/o1_mf_1_283_hoj818t1_.arc archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2020_09_08/o1_mf_1_279_hogz5ylq_.arc thread=1 sequence=279 archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2020_09_08/o1_mf_1_280_hoh3qxk1_.arc thread=1 sequence=280 archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2020_09_08/o1_mf_1_281_hoh7bow0_.arc thread=1 sequence=281 media recovery complete, elapsed time: 00:00:01 Finished recover at Sep 09 2020 11:53:14 RMAN> ALTER TABLESPACE ex1 online; Statement processed RMAN> validate tablespace ex1; Starting validate at Sep 09 2020 11:53:35 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00013 name=/u01/app/oracle/oradata/orcl/ex1.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:01 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 13 OK 0 1 129 2488395 File Name: /u01/app/oracle/oradata/orcl/ex1.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 127 Finished validate at Sep 09 2020 11:53:37 RMAN>