Oracle DataGuard(Physical)的一些管理命令 (2)

rman target /
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/ora_tmp/backup_%U';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ora_tmp/ctl_%F';
backup database format '/ora_tmp/hsta_%U.db';
exit;

 

2.在备份环境恢复control文件

cp 生产环境的'ctl_%F' 到备份环境下

rman target /
startup nomount;
restore controlfile from '/ora_tmp/ctl_c-668643720-20090807-00';
alter database mount;
restore database;

3.生成standby controlfile
conn / as sysdba
alter database create standby controlfile as '/ora_tmp/standby.ctl';

4.复制到standby数据库环境上
$cp /ora_tmp/standby.ctl control01.ctl
$cp /ora_tmp/standby.ctl control02.ctl
$cp /ora_tmp/standby.ctl control03.ctl
conn / as sysdba

alter database mount standby database;

 

alter system set log_archive_dest_state_2=enable;   原为 DEFER
alter database recover managed  standby database disconnect

主机启动
alter system switch logfile;

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10670663/viewspace-611919/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10670663/viewspace-611919/