adg主备库路径不同时的增量恢复

第一步：查看备库当前的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 SQL>col current_scnfor99999999999999SQL>selectcurrent_scn fromv$database;

第二步：将备库的SCN值作为主库增量备份的SCN值

RMAN>backup incremental from scn33678477903databaseformat'/u01/app/oracle/backup/bak_%U';--注意空间，多通道，服务器性能

第三步：在主库生成控制文件备份

SQL>alter database create standby controlfile as'/home/oracle/control_ora19cadg.ctl';--nfs路径会失败

第四步：将备份文件传输到备库

scp* :/u01/0401

第五步：关闭备库并重新启动到nomount模式；

SQL>shutdownimmediate;SQL>startup nomount;

第六步：在备库恢复控制文件；

RMAN>restore standby controlfile from'/u01/0401/control_ora19cadg.ctl';

第七步：备库启动到mount

SQL>alter 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(DBID=1212372715, notopen)RMAN>catalog start with'/u01/0401';RMAN>report schema;RMAN-06139: warning: controlfileis not currentforREPORT SCHEMA Report of database schemafordatabase with db_unique_name NCDBDG List of Permanent Datafiles===========================File 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...RMAN>catalog start with'+DATA';***注意多实例，如果有多实例，再继续进入几层目录*** RMAN>switch database to copy;将数据库控制文件中的数据文件指针，批量指向 RMAN 备份 swtich datafile1,2... to copy;RMAN>recover 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 SQL>RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROMSESSION;SQL>setlines222pages100col 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.