利用rman搭建DG备用库

1、在主库备份数据文件：

      backup database format='/let/rman_bak/%d_%s.dbf' include current controlfile for standby;

2、将备份文件拷贝到备库相同的目录/let/rman_bak下

3、将备库启动到mount状态下

      SQL>startup nomount;

      SQL>alter database mount standby database;

4、在备库利用rman恢复出备用库

      rman target /

      RMAN> catalog start with '/data/rman_bak'; 

 
      RMAN> restore database;

5、由于从Primary数据库复制文件时并没有复制Online Redologs，因此需将主库的重做日志文件redo.log联机状态拷至备库

6、在备库需手动创建备库重做日志

alter database add standby logfile group 4 ('/u01/app/oradata/orcl11g/std_redo04.log') size 50m;

alter database add standby logfile group 5 ('/u01/app/oradata/orcl11g/std_redo05.log') size 50m;

alter database add standby logfile group 6 ('/u01/app/oradata/orcl11g/std_redo06.log') size 50m;

alter database add standby logfile group 7 ('/u01/app/oradata/orcl11g/std_redo07.log') size 50m;

如果已经存在，则先删除在重建，否则报错：ORA-19527: physical standby redo log must be renamed。

SQL> alter database drop logfile group 4;
SQL> alter database drop logfile group 5;
SQL> alter database drop logfile group 6;
SQL> alter database drop logfile group 7;

7、将备库启动至日志应用模式下

alter database recover managed standby database disconnect from session;