作者 阿九【转载时请务必以超链接形式标明文章原始出处和作者信息】
RAC对单实例数据库的DATAGUARD配置,主要步骤有12步,如下:
1、主库全库备份
备份脚本
$ cat rman_full_20121221.sh
#!/bin/ksh
export ORACLE_HOME=/oracle/db10g
export PATH=$ORACLE_HOME/bin:$PATH
su - oracle -c "rman target / catalog zgdb/zgdb@tsm cmdfile /usr/tivoli/tsm/client/oracle/sched/rman_full_20121221.rcv msglog /usr/tivoli/tsm/client/oracle/sched/rman_full_20121221.log append"
$ cat rman_full_20121221.rcv
run {
allocate channel d1 type disk format '/expdpbak/full_db_20121221_1.dbf';
allocate channel d2 type disk format '/expdpbak/full_db_20121221_2.dbf';
allocate channel d3 type disk format '/expdpbak/full_db_20121221_3.dbf';
allocate channel d4 type disk format '/expdpbak/full_db_20121221_4.dbf';
backup as compressed backupset database tag='FULL_DB_20121221';
rel
$ cat rman_full_20121221.sh
#!/bin/ksh
export ORACLE_HOME=/oracle/db10g
export PATH=$ORACLE_HOME/bin:$PATH
su - oracle -c "rman target / catalog zgdb/zgdb@tsm cmdfile /usr/tivoli/tsm/client/oracle/sched/rman_full_20121221.rcv msglog /usr/tivoli/tsm/client/oracle/sched/rman_full_20121221.log append"
$ cat rman_full_20121221.rcv
run {
allocate channel d1 type disk format '/expdpbak/full_db_20121221_1.dbf';
allocate channel d2 type disk format '/expdpbak/full_db_20121221_2.dbf';
allocate channel d3 type disk format '/expdpbak/full_db_20121221_3.dbf';
allocate channel d4 type disk format '/expdpbak/full_db_20121221_4.dbf';
backup as compressed backupset database tag='FULL_DB_20121221';
rel