Dataguard实操steps - 墨天轮文档

Dataguard实操steps

真一

501

9页

2次

2020-03-01

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墨值下载

oracle 官方文档安装部署

关注

评论