第一步查看备库当前的SCN值SQL*Plus: Release19.0.0.0.0 - Production on Thu Apr211:15:382026Version19.21.0.0.0 Copyright(c)1982,2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release19.0.0.0.0 - Production Version19.21.0.0.0 SQLcol current_scnfor99999999999999SQLselectcurrent_scn fromv$database;第二步将备库的SCN值作为主库增量备份的SCN值RMANbackup incremental from scn33678477903databaseformat/u01/app/oracle/backup/bak_%U;--注意空间多通道服务器性能第三步在主库生成控制文件备份SQLalter database create standby controlfile as/home/oracle/control_ora19cadg.ctl;--nfs路径会失败第四步将备份文件传输到备库scp* :/u01/0401第五步关闭备库并重新启动到nomount模式SQLshutdownimmediate;SQLstartup nomount;第六步在备库恢复控制文件RMANrestore standby controlfile from/u01/0401/control_ora19cadg.ctl;第七步备库启动到mountSQLalter databasemount;--rman支持第八步将备库注册备份集实际数据文件注册控制文件中查看修正控制文件中的文件路径,完成恢复Recovery Manager: Release19.0.0.0.0 - Production on Thu Apr211:14:432026Version19.21.0.0.0 Copyright(c)1982,2019, Oracle and/or its affiliates. All rights reserved. connected to target database: ORA19C(DBID1212372715, notopen)RMANcatalog start with/u01/0401;RMANreport schema;RMAN-06139: warning: controlfileis not currentforREPORT SCHEMA Report of database schemafordatabase with db_unique_name NCDBDG List of Permanent DatafilesFile Size(MB)Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------10SYSTEM *** DATA/MUST_RENAME_THIS_DATAFILE_1.4294967295.429496729520NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_2.4294967295.429496729530SYSAUX *** DATA/MUST_RENAME_THIS_DATAFILE_3.4294967295.429496729540UNDOTBS1 *** DATA/MUST_RENAME_THIS_DATAFILE_4.4294967295.429496729550UNDOTBS2 *** DATA/MUST_RENAME_THIS_DATAFILE_5.4294967295.429496729570USERS *** DATA/MUST_RENAME_THIS_DATAFILE_6.4294967295.429496729594967295.429496729580NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_7.4294967295.429496729590NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_8.4294967295.4294967295100NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_9.4294967295.4294967295110NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_10.4294967295.4294967295120NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_11.4294967295.4294967295130NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_12.4294967295.4294967295140NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_13.4294967295.4294967295150NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_14.4294967295.4294967295160NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_15.4294967295.4294967295170NNC_INDEX01 *** DATA/MUST_RENAME_THIS_DATAFILE_16.4294967295.4294967295180NNC_INDEX01 *** DATA/MUST_RENAME_THIS_DATAFILE_17.4294967295.4294967295190NNC_INDEX01 *** DATA/MUST_RENAME_THIS_DATAFILE_18.4294967295.4294967295200NNC_DATA01 *** DATA/MUST_RENAME_THIS_DATAFILE_18.4294967295.4294967295...RMANcatalog start withDATA;***注意多实例如果有多实例再继续进入几层目录*** RMANswitch database to copy;将数据库控制文件中的数据文件指针批量指向 RMAN 备份 swtich datafile1,2... to copy;RMANrecover database noredo;用备份进行恢复 RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROMSESSION;--先追scn追平之后down掉启动RAC两节点数据库alter databaseopen;SQL*Plus: Release19.0.0.0.0 - Production on Thu Apr211:15:382026Version19.21.0.0.0 Copyright(c)1982,2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release19.0.0.0.0 - Production Version19.21.0.0.0 SQLRECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROMSESSION;SQLsetlines222pages100col client_pidfora10selectinst_id,thread#,process,status,client_pid,sequence#,BLOCK#,BLOCKS,DELAY_MINS from gv$managed_standby;INST_ID THREAD# PROCESS STATUS CLIENT_PID SEQUENCE# BLOCK# BLOCKS DELAY_MINS---------- ---------- --------- ------------ ---------- ---------- ---------- ---------- ----------11ARCH CLOSING19990138878179872613010DGRD ALLOCATED N/A000010DGRD ALLOCATED N/A000011ARCH CLOSING199961388782573441434011ARCH CLOSING20002138878077824258011ARCH CLOSING200211388783471041234011ARCH CLOSING20023138877849152326011ARCH CLOSING20027138877047104166012ARCH CLOSING20031127828540961970011ARCH CLOSING20036138877771680363012ARCH CLOSING20038127828443008587011ARCH CLOSING20040138877586016321011RFS IDLE106194000011RFS IDLE102364000011RFS RECEIVING10621913887841180411012RFS RECEIVING11703312782861585618010RFS IDLE106210000010RFS IDLE106206000010RFS IDLE106204000010RFS IDLE106200000010RFS IDLE106208000010RFS IDLE106214000010RFS IDLE106212000010RFS IDLE106217000010RFS IDLE106202000010RFS IDLE81901000010RFS IDLE81915000010RFS IDLE81907000010RFS IDLE81905000010RFS IDLE104654000010RFS IDLE81899000010RFS IDLE81897000010RFS IDLE104651000010RFS IDLE81917000011MRP0 APPLYING_LOG N/A138878411763409600035rows selected.