6          主备库切换

在主库执行：

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 1 GROUP 4 ('/data/oracle/oradata/hellodb/stdlog_5_1.log') SIZE 50M;

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 1 GROUP 5 ('/data/oracle/oradata/hellodb/stdlog_6_1.log') SIZE 50M;

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 1 GROUP 6('/data/oracle/oradata/hellodb/stdlog_7_1.log') SIZE 50M;

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 2 GROUP 7 ('/data/oracle/oradata/hellodb/stdlog_8_1.log') SIZE 50M;

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 2 GROUP 8 ('/data/oracle/oradata/hellodb/stdlog_9_1.log') SIZE 50M;

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 2 GROUP 9 ('/data/oracle/oradata/hellodb/stdlog_10_1.log') SIZE 50M;

02逻辑备库：

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 2 GROUP 8 ('/data/oracle/oradata/hellodb/stdlog_9_1.log') SIZE 50M;

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 2 GROUP 9 ('/data/oracle/oradata/hellodb/stdlog_10_1.log') SIZE 50M;

ALTER DATABASE ADD STANDBY  LOGFILE THREAD 2 GROUP 11 ('/data/oracle/oradata/hellodb/stdlog_11_1.log') SIZE 50M;

在主库执行：

SELECT SWITCHOVER_STATUS FROM V$DATABASE;

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY  WITH SESSION SHUTDOWN;

Shutdown immediate;

startup mount;

alter database recover managed standby database disconnect from session using current logfile;

在备库执行：

 SELECT SWITCHOVER_STATUS FROM V$DATABASE;

 ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

 alter database open;

 alter system switch logfile;

切换日志观察日志应用的情况

SQL> select * from (

  2  select  thread#,sequence# ,APPLIED, row_number() over(partition by thread# order by sequence# desc ) rn from v$archived_log

) where rn <=8;  3 

   THREAD#  SEQUENCE# APP         RN

---------- ---------- --- ----------

         1         35 YES          1

         1         34 YES          2

         1         33 YES          3

         1         32 YES          4

         1         32 NO           5

         1         32 NO           6

         1         31 YES          7

         1         31 NO           8

RFS LogMiner: Registered logfile [/data/oracle/oradata/hellodb/arch/1_35_737312896.dbf] to LogMiner session id [1]

在主库修改日志：

ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 10   SIZE 50M;

ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 11   SIZE 50M;

ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 12   SIZE 50M;

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 7   SIZE 50M;

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 8   SIZE 50M;

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 9   SIZE 50M;

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '+DATA/testrac/datafile/undotbs02.dbf' SIZE 200M autoextend on;

----增加或者调整tmpfile

alter database tempfile '+DATA/testrac/datafile/temp02.dbf' resize 20G;

or

alter database tempfile '+DATA/testrac/datafile/temp01.dbf' resize 2G;

SQL> select name from v$datafile;

NAME

+DATA/testrac/datafile/system.dbf

+DATA/testrac/datafile/undotbs01.dbf

+DATA/testrac/datafile/sysaux.dbf

+DATA/testrac/datafile/undotbs02.dbf

ALTER DATABASE ENABLE THREAD 2;

shutdown immediate

启用下面两个

*.cluster_database_instances=2

*.cluster_database=true

打开节点2：

scp inittestrac1.ora 192.168.1.22:/data/oracle/product/10.2/db1/dbs/inittestrac1.ora

scp orapwtestrac1 192.168.1.22:/data/oracle/product/10.2/db1/dbs/orapwtestrac2

类似修改

listener.ora

tnsnames.ora

startup