利用RMAN备份standby还原主库

1、利用RMAN连接备库

rman nocatalog target sys/sysdba@standby

 

2、利用RMAN备份standby数据库

RMAN> run{
2> allocate channel d1 device type disk;
3> backup as compressed backupset
4> incremental level=0
5> format='/u01/rmanbak/inc0_standby_%d_%U'
6> tag='inc0_standby'
7> channel=d1
8> database;
9> backup as compressed backupset
10> format='/u01/rmanbak/inc0_arch_standby_%d_%U'
11> tag='arch_standby'
12> archivelog all delete input;
13> }

 

3、在主库中利用catalog RMAN连接

rman target sys/sysdba@primary

RMAN> connect catalog cata/cata@digoal

RMAN> register database;

RMAN> crosscheck backupset;

 

4、连接备库

rman catalog cata/cata@digoal target sys/sysdba@standby

RMAN> resync catalog;

 

5、连接主库

rman catalog cata/cata@digoal target sys/sysdba@primary

RMAN> resync catalog;

RMAN> list backupset;

 

6、恢复数据（主库）

RMAN> run{
2> allocate channel d1 device type disk;
3> restore datafile 5;
4> recover datafile 5;
5> sql "alter database datafile 5 online";
6> }