10g 物理standby建立及常用命令备忘

**建立物理standby**

1)enable archive
2)orapwd
3)alter database force logging;
4)alter database add standby logfile group 4 '/oradata/dg01/s_redo/redo04.ora' size 5m;
5)配置init.ora
primary
db_unique_name=dg01
service_names=dg02
db_name=dg01
log_archive_dest_1='location='/oradata/arch valid_for=(all_logfiles,all_roles) db_unique_name=dg01'
log_archive_dest_state_1=enable
log_archive_dest_2='service=dg02 valid_for=(online_logfiles,primary) reopen=10 db_unique_name=dg02'
log_archive_dest_state_2=defer
fal_server=dg02
fal_client=dg01
standby_file_management=auto
6)alter database create standby controlfile as '/c.ctl';
7)冷拷贝
8)modify standby init
9)orapwd on standby
10)startup primary
11)startup mount; on standby
12)logswitch
13)select status,error from v$archive_dest;<