Oracle DataGurard 配置和使用中常用命令有哪些 ?

Oracle · andrew · 于 2年前发布 · 1365 次阅读

如题


共收到 3 条回复 Oracle DataGurard 常用命令
ruyi#12年前 0 个赞

dataguard应用日志和停止应用

alter database recover managed standby database disconnect;
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect;
ruyi#22年前 0 个赞

更改配置

alter system set log_archive_config='DG_CONFIG=(std02,tmsstd,tms51)'scope=both; 
alter system set log_archive_dest_2='service=std02 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=std02' ; 
ruyi#32年前 0 个赞

Rman Duplicate

$ rman auxiliary sys/oracle@oradg_36 target sys/oracle@oradg_35 nocatalog
RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
回复本帖 (需要登录)