Tags

, , , ,



root@primary:/>ps -ef |grep pmon
user 372972 1 0 May 20 – 3:01 ora_pmon_sid
root@primary:/>su – user
user@primary:/swift/user>sqlplus / as sysdba
SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS


ARCH CLOSING 1 4519 1 1704
ARCH CLOSING 1 4520 90112 1363
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 4521 8192 782
LNS WRITING 1 4522 745 2
SQL> select NAME from v$tempfile ;

NAME

/oracle/oradata/user/temp01.dbf
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

TO STANDBY
SQL> select max(sequence#) from v$log_history;

MAX(SEQUENCE#)

      4563

SQL> startup abort;
SQL> exit
user@primary:/swift/user>sqlplus / as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Database mounted.
SQL> alter system set job_queue_processes=0 scope=memory;
alter system set aq_tm_processes=0 scope=memory;
alter system set “_system_trig_enabled”=false scope=memory;
System altered.
SQL>
System altered.
SQL>
System altered.
SQL> alter database commit to switchover to physical standby with session shutdown;
Database altered.
SQL> shutdown immediate;
ORA-01092: ORACLE instance terminated. Disconnection forced
user@primary:/swift/user>sqlplus / as sysdba
Connected to an idle instance.
SQL> startup mount;
alter system set service_names=” scope=memory;
ORACLE instance started.
Database mounted.
SQL> System altered.
SQL> shutdown abort;
startup mount;
ORACLE instance shut down.
ORACLE instance started.
Database mounted.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS


ARCH CLOSING 1 4574 1 11
ARCH CLOSING 1 4575 1 4
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 4573 1 46
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 1 4576 12 1
MRP0 WAIT_FOR_LOG 1 4576 0 0



root@standby:/>ps -ef |grep pmon
user 1429524 1 0 Apr 25 – 9:22 ora_pmon_sid
root@standby:/>su – user
user@standby:/swift/user>sqlplus / as sysdba
SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS


ARCH CLOSING 1 4520 90112 1363
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 4521 8192 782
ARCH CLOSING 1 4519 1 1704
RFS IDLE 0 0 0 0
RFS RECEIVING 0 0 0 0
RFS RECEIVING 0 0 0 0
RFS IDLE 1 4522 751 1
MRP0 WAIT_FOR_LOG 1 4522 0 0

SQL> select name from v$tempfile ;

NAME

/oracle/oradata/user/temp01.dbf
SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS


ARCH CLOSING 1 4559 6144 519
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 4557 6144 5
ARCH CLOSING 1 4558 2048 1171
RFS IDLE 0 0 0 0
RFS RECEIVING 0 0 0 0
RFS RECEIVING 0 0 0 0
RFS IDLE 1 4560 4719 5
MRP0 WAIT_FOR_LOG 1 4560 0 0

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

TO PRIMARY
SQL> alter database commit to switchover to primary;
Database altered.
SQL> alter database open;
Database altered.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Database opened.

SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS


ARCH CLOSING 1 4575 1 4
ARCH CLOSING 1 4573 1 46
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 4574 1 11
LNS WRITING 1 4576 5 1



Advertisements