rman重建oracle dg备库

前提：

先将备库shutdown，然后删除数据文件；再把备库数据库startup nomount

主库：

#mkdir -p /u02/rmans

#chown -R oracle:oinstall /u02/rmans

备库：

startup nomount pfile='/u02/fapdbwb.pfile'

1.在主库的/u02目录下建立rmans目录，切主库日志

alter system switch logfile;

2.然后rman

rman target /

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

backup as compressed backupset full database format '/opt/oracle/backup/dbback/db_%d_%T_%U';

release channel c1;

release channel c2;

release channel c3;

}

3.在主库生成控制文件

ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/u02/rmans/stb.ctl';

4.在备库将控制文件放到数据库目录下，启动备库

scp -P 34567 /u02/rmans/* 182.199.4.194:/u02/rmansweb

cp control01.ctl /u02/oradata/oradb/orcl

cp control01.ctl /u02/oradata/oradb/orcl/control02.ctl

startup mount pfile='/u02/fapdbwb.pfile'

5.在备库rman恢复

rman target /

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

restore database;

release channel c1;

release channel c2;

release channel c3;

}

6.在备库创建spfile，确认应用的最新归档日志，后续的归档日志在不在，以及归档日志是否全，不全需要从主库传过去，如没传，则把主库密码策略拷过去

create spfile from pfile='/u02/rmans/fapdbwb.pfile';

select THREAD#,MAX(SEQUENCE#) FROM V$LOG_HISTORY GROUP BYTHREAD#;

scp 1_18700_3829463927.dbf ......

7.启动数据库（备库）

alter database open;

8.启动mrp

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY PARALLEL 2 USING CURRENT LOGFILE DISCONNECT FROM SESSION;

9.检验数据

主库执行：

create table test20251020 as select * from v$parameter where rownum <=50;

commit;

备库看是否有该表；

drop table test20251020;