发布时间 : 星期三 文章oracle主备库切换ora-01507更新完毕开始阅读955062ece009581b6bd9eb18
主备切换（SWITCHOVER) switchover:
主库切换为备库：
SQL> select database_role ,switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS
-------------------------------- ------------------------------------ PRIMARY SESSIONS ACTIVE
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDO WN;
数据库已更改。 SQL>
SQL> select database_role ,switchover_status from v$database; select database_role ,switchover_status from v$database * ERROR 位于第 1 行:
ORA-01507: 未安装数据库
SQL> startup mount;
ORA-01081: 无法启动已在运行的 ORACLE --- 请首先关闭 SQL> shutdown immediate; ORA-01507: 未安装数据库
ORACLE 例程已经关闭。 SQL> startup mount; ORACLE 例程已经启动。
Total System Global Area 143727516 bytes Fixed Size 453532 bytes Variable Size 109051904 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes ORA-01666: ???????????
SQL> select database_role ,switchover_status from v$database; select database_role ,switchover_status from v$database * ERROR 位于第 1 行:
ORA-01507: ??????
SQL> select status from v$instance;
STATUS
------------------------ STARTED
SQL> alter database mount standby database;
数据库已更改。
SQL> alter database recover managed standby database;
C:\\>set or
ORACLE_SID=auxdb2
C:\\>sqlplus \
SQL*Plus: Release 9.2.0.1.0 - Production on 星期日 5月 4 10:40:34 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
SQL> spool d:\\dg\\2.txt
SQL> select log_mode ,database_role,switchover_status,force_logging from v$data base;
LOG_MODE DATABASE_ROLE
------------------------ -------------------------------- SWITCHOVER_STATUS FORCE_ ------------------------------------ ------ ARCHIVELOG PHYSICAL STANDBY SESSIONS ACTIVE YES
SQL> select process,client_process,sequence#,status from v$managed_standby;
PROCESS CLIENT_PROCESS SEQUENCE# STATUS
-------------- ---------------- ---------- ------------------------ ARCH ARCH 0 CONNECTED ARCH ARCH 0 CONNECTED RFS N/A 0 RECEIVING MR(fg) N/A 45 WAIT_FOR_LOG
SQL> show parameter standby;
NAME TYPE
------------------------------------ ---------------------- VALUE
------------------------------
standby_archive_dest string D:\\oracle\\auxdb\\standbyArch
standby_file_management string auto
SQL> spool off;
备库切换为主库：
SQL> show parameter fal
NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ fal_client string tstdb fal_server string auxdb2
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS ------------------------------------ SESSIONS ACTIVE
SQL> select switchover_status,database_role from v$database;
SWITCHOVER_STATUS DATABASE_ROLE
------------------------------------ -------------------------------- SESSIONS ACTIVE PHYSICAL STANDBY
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
数据库已更改。
SQL> select status from v$instance;
STATUS ------------------------ STARTED
SQL> alter database open; alter database open *
ERROR 位于第 1 行: ORA-01507: ??????
SQL> startup mount;
ORA-01081: ????????? ORACLE --- ????? SQL> shutdown immediate; ORA-01507: ??????
ORACLE 例程已经关闭。 SQL> startup
ORACLE 例程已经启动。
Total System Global Area 143727516 bytes Fixed Size 453532 bytes Variable Size 109051904 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes 数据库装载完毕。 数据库已经打开。
SQL> select switchover_status,database_role from v$database;
SWITCHOVER_STATUS DATABASE_ROLE ------------------------------------ -------------------------------- SESSIONS ACTIVE PRIMARY