Dataguard实操steps
5墨值下载
www.eeqee.com
草根交流，1 月 1 次，面对面
Oracle 之 RAC GG DG 技术 QQ 交流群：40137883
说明：该文档为 向上 IT 技术交流群 吴海存在 13 年 3 月 24 日主讲的 dataguard 交流活动实
操整理而成的代码笔录，交流讲义请单独下载，谢谢大家对向上群技术交流活动的支持！
吴海存（Oracle OCM）
===================================for 10g:
---------------------------------手工方式------------------------------------------
shutdown immediate;
startup mount;
alter database force logging;
alter database add standby logfile group 5
('/u01/app/oracle/oradata/PROD/sredo05a.log','/u01/app/oracle/oradata/PROD/sredo05b.log')
size 10m;
alter database add standby logfile group 6
('/u01/app/oracle/oradata/PROD/sredo06a.log','/u01/app/oracle/oradata/PROD/sredo06b.log')
size 10m;
alter database add standby logfile group 7
('/u01/app/oracle/oradata/PROD/sredo07a.log','/u01/app/oracle/oradata/PROD/sredo07b.log')
size 10m;
cd /u01/app/oracle/oradata/PROD
cp -r * ../std
alter database create standby controlfile as '/u01/app/oracle/oradata/std/scontrol01.ctl';
mkdir -p /u01/app/oracle/oradata/admin/std/{a,b,c,u}dump
cd $ORACLE_HOME/dbs
vi initPROD.ora
db_unique_name=PROD
log_archive_config='dg_config=(PROD,std)'
log_archive_dest_1='location=/u01/app/oracle/oradata/PROD/arch
valid_for=(all_logfiles,all_roles)'
log_archive_dest_2='service=std lgwr sync affirm valid_for=(online_logfiles,primary_role)
db_unique_name=std'
fal_server=std
fal_client=PROD
db_file_name_convert='/u01/app/oracle/oradata/std','/u01/app/oracle/oradata/PROD'
log_file_name_convert='/u01/app/oracle/oradata/std','/u01/app/oracle/oradata/PROD'
standby_filename_management=auto
www.eeqee.com
草根交流，1 月 1 次，面对面
Oracle 之 RAC GG DG 技术 QQ 交流群：40137883
cp initPROD.ora initstd.ora
cp orapwPROD orapwstd
vi initstd.ora
:%s#admin/PROD#admin/std#g
control_files='/u01/app/oracle/oradata/std/scontrol01.ctl'
db_unique_name=std
log_archive_config='dg_config=(PROD,std)'
log_archive_dest_1='location=/u01/app/oracle/oradata/std/arch valid_for=(all_logfiles,all_roles)'
log_archive_dest_2='service=PROD lgwr sync affirm valid_for=(online_logfiles,primary_role)
db_unique_name=PROD'
fal_server=PROD
fal_client=std
db_file_name_convert='/u01/app/oracle/oradata/PROD','/u01/app/oracle/oradata/std'
log_file_name_convert='/u01/app/oracle/oradata/PROD','/u01/app/oracle/oradata/std'
standby_file_management=auto
tail -f /u01/app/oracle/oradata/admin/std/bdump/alert*
tail -f /oracle/product/admin/PROD/bdump/alert*
listener.ora tnsnames.ora
std:
startup mount
alter database recover managed standby database disconnect from session;
PROD:
alter database open;
alter system switch log;
switchover
prod:
alter database commit to switchover to standby with session shutdown;
shutdown immediate;
startup mount;
alter database recover managed standby database disconnect from session;
std:
alter database commit to switchover to primary;
shutdown immediate;
startup;
open readonly
alter database recover managed standby database cancel;
of 9
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论