Dataguard配置Step by Step[4]

 

[oracle@standby oracle]$ ls
admin  dictionary.ora  initprimary.ora  jre  oradata  oradata.tar  orainventory  oui  product  soft  stdcotrl.ctl
[oracle@standby oracle]$ cd oradata
[oracle@standby oradata]$ ls
primary
[oracle@standby oradata]$ cd primary/
[oracle@standby primary]$ ls
archive        control02.ctl  redo01.log  redo03.log    temp01.dbf     users01.dbf
control01.ctl  control03.ctl  redo02.log  system01.dbf  undotbs01.dbf
[oracle@standby primary]$ mkdir stdarch
[oracle@standby primary]$ exit
exit

sql> alter system set standby_archive_dest='/opt/oracle/oradata/primary/stdarch';

system altered.

 

sql> alter database commit to switchover to physical standby;

database altered.

sql> shutdown immediate
ora-01507: database not mounted


oracle instance shut down.

在备用模式启用主数据

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> select name,open_mode,protection_mode,database_role from v$database;

name      open_mode  protection_mode      database_role
--------- ---------- -------------------- ----------------
primary   mounted    maximum performance  physical standby


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

database altered.


打开备用数据库
[oracle@eygle oracle]$ sqlplus "/ as sysdba"

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

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


connected to:
oracle9i enterprise edition release 9.2.0.4.0 - production
with the partitioning, real application clusters, olap and oracle data mining options
jserver release 9.2.0.4.0 - production

sql> alter database commit to switchover to primary;

database altered.

sql> shutdown immediate;
ora-01507: database not mounted


oracle instance shut down.
sql> startup
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
database mounted.
database opened.
sql> alter system switch logfile;

system altered.

在主库上观察日志应用情况

[oracle@standby bdump]$ tail -f alert_primary.log 
starting datafile 2 recovery in thread 1 sequence 93
datafile 2: '/opt/oracle/oradata/primary/undotbs01.dbf'
starting datafile 3 recovery in thread 1 sequence 93
datafile 3: '/opt/oracle/oradata/primary/users01.dbf'
media recovery log /opt/oracle/product/9.2.0/dbs/arch1_93.dbf
mon aug 16 15:08:43 2004
media recovery log /opt/oracle/oradata/primary/stdarch/1_94.dbf
media recovery waiting for thread 1 seq# 95
media recovery log /opt/oracle/oradata/primary/stdarch/1_95.dbf
media recovery waiting for thread 1 seq# 96					
					

 

sql> create table t as select * from dba_users;

table created.

sql> alter system switch logfile;

system altered.

在从库上以read only打开数据库，执行查询
sql> select username from t;
select username from t
                     *
error at line 1:
ora-01219: database not open: queries allowed on fixed tables/views only


sql> alter database recover managed standby database cancel;

database altered.

sql> alter database open read only;

database altered.

sql> select username from t;

username
------------------------------
sys
system
dbsnmp
outln
wmsys

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


database altered.

sql> 					
					

 

在主节点
sql> alter database commit to switchover to physical standby;

database altered.

sql> shutdown immediate
ora-01507: database not mounted


statoracle instance shut down.
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 database commit to switchover to primary;

database altered.

sql> shutdown immediate;
ora-01507: database not mounted


oracle instance shut down.
sql> startup
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
database mounted.
database opened.