Oracle Physical Dataguard环境使用RMAN备份和恢复
由于Physical Dataguard使用的是块恢复技术来保持和PRIMARY的一致性,因此可以在STANDBY
上进行rman备份,从而减轻PRIMARY的压力.当PRIMARY出现数据库故障时,可以使用在STANDBY上
的备份来进行恢复.
先决条件:需要配置catalog.
在PRIMARY上以catalog方式连接,并且注册数据库
[oracle@PRIMARY admin]$ $ORACLE_HOME/bin/rman target / catalog
> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> configure db_unique_name CP connect identifier 'cp';
new RMAN configuration parameters:
CONFIGURE DB_UNIQUE_NAME 'cp' CONNECT IDENTIFIER 'cp';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure db_unique_name cepstby connect identifier 'cepstby';
new RMAN configuration parameters:
CONFIGURE DB_UNIQUE_NAME 'cepstby' CONNECT IDENTIFIER 'cepstby';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
查看已注册的数据库信息,rman自动识别数据库角色等信息.
RMAN> list db_unique_name of database;
List of Databases
DB Key DB Name DB ID