Dataguard配置Step by Step[3]

 

[oracle@standby admin]$ tnsping standby

tns ping utility for linux: version 9.2.0.4.0 - production on 16-aug-2004 10:46:50

copyright (c) 1997 oracle corporation.  all rights reserved.

used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora


used tnsnames adapter to resolve the alias
attempting to contact (description = (address_list = (address = (protocol = tcp)(host = 172.16.33.46)(port = 1521))) 
(connect_data = (server = dedicated) (service_name = primary)))
ok (10 msec)
[oracle@standby admin]$ tnsping primary

tns ping utility for linux: version 9.2.0.4.0 - production on 16-aug-2004 10:46:55

copyright (c) 1997 oracle corporation.  all rights reserved.

used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora


used tnsnames adapter to resolve the alias
attempting to contact (description = (address_list = (address = (protocol = tcp)(host = 172.16.33.58)(port = 1521)))
 (connect_data = (server = dedicated) (service_name = primary)))
ok (0 msec)

[oracle@eygle admin]$ tnsping primary

tns ping utility for linux: version 9.2.0.4.0 - production on 16-aug-2004 10:10:01

copyright (c) 1997 oracle corporation.  all rights reserved.

used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora


used tnsnames adapter to resolve the alias
attempting to contact (description = (address_list = (address = (protocol = tcp)(host = 172.16.33.58)(port = 1521))) 
(connect_data = (server = dedicated) (service_name = primary)))
ok (50 msec)
[oracle@eygle admin]$ tnsping standby

tns ping utility for linux: version 9.2.0.4.0 - production on 16-aug-2004 10:10:06

copyright (c) 1997 oracle corporation.  all rights reserved.

used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora


used tnsnames adapter to resolve the alias
attempting to contact (description = (address_list = (address = (protocol = tcp)(host = 172.16.33.46)(port = 1521))) 
(connect_data = (server = dedicated) (service_name = primary)))
ok (10 msec)					

 

[oracle@eygle primary]$ hostname
eygle
[oracle@eygle primary]$ sqlplus "/ as sysdba"

sql*plus: release 9.2.0.4.0 - production on mon aug 16 11:09:40 2004

copyright (c) 1982, 2002, oracle corporation. all rights reserved.

connected to an idle instance.

sql> startup nomount;
oracle instance started.

total system global area 135337420 bytes
fixed size 452044 bytes
variable size 109051904 bytes
database buffers 25165824 bytes
redo buffers 667648 bytes
sql> alter database mount standby database;

database altered.

sql> alter database recover managed standby database disconnect from session;

database altered.

 

sql> alter system set log_archive_dest_2='service=standby mandatory reopen=60';

system altered.

sql> alter system switch logfile;

system altered.

sql> /

system altered.

sql>

在备用节点观察日志

[oracle@eygle bdump]$ tail -f alert_primary.log
mrp0: background managed standby recovery process started
starting datafile 1 recovery in thread 1 sequence 90
datafile 1: '/opt/oracle/oradata/primary/system01.dbf'
starting datafile 2 recovery in thread 1 sequence 90
datafile 2: '/opt/oracle/oradata/primary/undotbs01.dbf'
starting datafile 3 recovery in thread 1 sequence 90
datafile 3: '/opt/oracle/oradata/primary/users01.dbf'
media recovery waiting for thread 1 seq# 90
mon aug 16 11:10:50 2004
completed: alter database recover managed standby database di
mon aug 16 11:13:34 2004
media recovery log /opt/oracle/oradata/primary/stdarch/1_90.dbf
media recovery waiting for thread 1 seq# 91
media recovery log /opt/oracle/oradata/primary/stdarch/1_91.dbf
media recovery waiting for thread 1 seq# 92
mon aug 16 12:09:38 2004
media recovery log /opt/oracle/oradata/primary/stdarch/1_92.dbf