前提：linux環境下已創建一個名為demo1的數據庫，並已處於運行；這個測試是在完全新建的數據中配置物理standby。

一、Standby主庫的配置

1、primary確認歸檔模式

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 1

Next log sequence to archive 3

Current log sequence 3

2、primary查看logging模式，如果為NO則將primary置於force logging模式

SQL> select force_logging from v$database;

FOR

---

NO

SQL> alter database force logging;

Database altered.

SQL> select force_logging from v$database;

FOR

---

YES

3、在primary中建立standby控制文件

SQL> alter database create standby controlfile as '/oracle/backup/standby.ctl';

Database altered.

查看當前歸檔地點

SQL> col dest_name for a25

SQL> col destination for a25

SQL> select dest_id,dest_name,status,destination from v$archive_dest;

DEST_ID DEST_NAME STATUS DESTINATION

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

1 LOG_ARCHIVE_DEST_1 INACTIVE

2 LOG_ARCHIVE_DEST_2 INACTIVE

3 LOG_ARCHIVE_DEST_3 INACTIVE

4 LOG_ARCHIVE_DEST_4 INACTIVE

5 LOG_ARCHIVE_DEST_5 INACTIVE

6 LOG_ARCHIVE_DEST_6 INACTIVE

7 LOG_ARCHIVE_DEST_7 INACTIVE

8 LOG_ARCHIVE_DEST_8 INACTIVE

9 LOG_ARCHIVE_DEST_9 INACTIVE

10 LOG_ARCHIVE_DEST_10 VALID USE_DB_RECOVERY_FILE_DEST

10 rows selected.

4、修改pfile參數文件

demo1.__db_cache_size=180355072

demo1.__java_pool_size=4194304

demo1.__large_pool_size=4194304

demo1.__shared_pool_size=92274688

demo1.__streams_pool_size=0

*.audit_file_dest='/oracle/admin/demo1/adump'

*.background_dump_dest='/oracle/admin/demo1/bdump'

*.compatible='10.2.0.3.0'

*.control_files='/oracle/oradata/demo1/control01.ctl','/oracle/oradata/demo1/control02.ctl','/oracle/oradata/demo1/control03.ctl'

*.core_dump_dest='/oracle/admin/demo1/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_recovery_file_dest='/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=demo1XDB)'

*.job_queue_processes=10

*.nls_language='SIMPLIFIED CHINESE'

*.nls_territory='CHINA'

*.open_cursors=300

*.pga_aggregate_target=94371840

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=285212672

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/oracle/admin/demo1/udump'

###################################################################

# Parameter for primary database #

###################################################################

*.DB_NAME='demo1'

*.DB_UNIQUE_NAME=demo1

*.LOG_ARCHIVE_FORMAT=log_%t_%s_%r.arc

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(demo1,demo2)'

*.LOG_ARCHIVE_DEST_1='LOCATION=/oracle/oradata/demo1 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=demo1'

*.LOG_ARCHIVE_DEST_2='SERVICE=demo2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=demo2'

*.LOG_ARCHIVE_DEST_STATE_1=ENABLE

*.LOG_ARCHIVE_DEST_STATE_2=ENABLE

*.REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

###################################################################

# Parameters which using for switch over from Primary to Standby. #

###################################################################

*.FAL_SERVER=demo2

*.FAL_CLIENT=demo1

*.DB_FILE_NAME_CONVERT='/oracle/oradata/demo2','/oracle/oradata/demo1'

*.LOG_FILE_NAME_CONVERT='/oracle/oradata/demo2','/oracle/oradata/demo1'

*.STANDBY_FILE_MANAGEMENT=AUTO

*.STANDBY_ARCHIVE_DEST='/oracle/oradata/demo1/standby_arch'

5、從pfile創建primary的spfile

SQL> create spfile from pfile='$ORACLE_HOME/dbs/pfiledemo1.ora';

File created.

6、配置監聽listener.ora

# listener.ora Network Configuration File: /oracle/product/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

DEMO1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.134.140.193)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = demo1)

)

DEMO2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.134.140.194)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = demo2)

)

測試監聽

SQL> !

[oracle@dg01 ~]$ tnsping demo1

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 25-SEP-2009 16:15:54

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.134.140.193)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = demo1)))

OK (10 msec)

[oracle@dg01 backup]$ tnsping demo2

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 25-SEP-2009 16:15:58

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.134.140.194)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = demo2)))

TNS-12541: TNS:no listener

二、Standby備庫的配置

1、建立密碼文件，與primary數據庫sys密碼一致

[oracle@dg02 ~]$ orapwd file=$ORACLE_HOME/dbs/orapwdemo2 password=123456 entries=30

2、創建OMF目錄

[oracle@dg02 ~]$mkdir $ORACLE_BASE/product

[oracle@dg02 ~]$mkdir $ORACLE_BASE/product/10.2.0

[oracle@dg02 ~]$mkdir $ORACLE_BASE/product/10.2.0d/db_1

[oracle@dg02 ~]$mkdir $ORACLE_BASE/admin

[oracle@dg02 ~]$mkdir $ORACLE_BASE/admin/demo2

[oracle@dg02 ~]$mkdir $ORACLE_BASE/admin/demo2/adump

[oracle@dg02 ~]$mkdir $ORACLE_BASE/admin/demo2/bdump

[oracle@dg02 ~]$mkdir $ORACLE_BASE/admin/demo2/cdump

[oracle@dg02 ~]$mkdir $ORACLE_BASE/admin/demo2/dpdump

[oracle@dg02 ~]$mkdir $ORACLE_BASE/admin/demo2/pfile

[oracle@dg02 ~]$mkdir $ORACLE_BASE/admin/demo2/udump

[oracle@dg02 ~]$mkdir $ORACLE_BASE/flash_recovery_area

[oracle@dg02 ~]$mkdir $ORACLE_BASE/oradata

[oracle@dg02 ~]$mkdir $ORACLE_BASE/oradata/demo2

3、复制数据文件到standby库对应的目录（datafile,log,controlfiles）

4、修改standby參數據文件

demo1.__db_cache_size=180355072

demo1.__java_pool_size=4194304

demo1.__large_pool_size=4194304

demo1.__shared_pool_size=92274688

demo1.__streams_pool_size=0

*.audit_file_dest='/oracle/admin/demo2/adump'

*.background_dump_dest='/oracle/admin/demo2/bdump'

*.compatible='10.2.0.3.0'

*.control_files='/oracle/oradata/demo2/control01.ctl','/oracle/oradata/demo2/control02.ctl','/oracle/oradata/demo2/control03.ctl'

*.core_dump_dest='/oracle/admin/demo2/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_recovery_file_dest='/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=demo1XDB)'

*.job_queue_processes=10

*.nls_language='SIMPLIFIED CHINESE'

*.nls_territory='CHINA'

*.open_cursors=300

*.pga_aggregate_target=94371840

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=285212672

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/oracle/admin/demo2/udump'

###################################################################

# Parameter for primary database #

###################################################################

*.DB_NAME='demo1'

*.DB_UNIQUE_NAME=demo2

*.LOG_ARCHIVE_FORMAT=log_%t_%s_%r.arc

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(demo1,demo2)'

*.LOG_ARCHIVE_DEST_1='LOCATION=/oracle/oradata/demo2 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=demo2'

*.LOG_ARCHIVE_DEST_2='SERVICE=demo1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=demo1'

*.LOG_ARCHIVE_DEST_STATE_1=ENABLE

*.LOG_ARCHIVE_DEST_STATE_2=ENABLE

*.REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

###################################################################

# Parameters which using for switch over from Primary to Standby. #

###################################################################

*.FAL_SERVER=demo1

*.FAL_CLIENT=demo2

*.DB_FILE_NAME_CONVERT='/oracle/oradata/demo1','/oracle/oradata/demo2'

*.LOG_FILE_NAME_CONVERT='/oracle/oradata/demo1','/oracle/oradata/demo2'

*.STANDBY_FILE_MANAGEMENT=AUTO

*.STANDBY_ARCHIVE_DEST='/oracle/oradata/demo2/standby_arch'

5、用rman備份primary數據庫

[oracle@dg01 backup]$ rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Fri Sep 25 17:00:59 2009

connected to target database: DEMO1 (DBID=3701899587)

RMAN> Backup Database format '/oracle/backup/full_%d_%T_%s';

Starting backup at 25-SEP-09

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=142 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/oracle/oradata/demo1/system01.dbf

input datafile fno=00005 name=/oradata/demo1/myuser.dbf

input datafile fno=00003 name=/oracle/oradata/demo1/sysaux01.dbf

input datafile fno=00002 name=/oracle/oradata/demo1/undotbs01.dbf

channel ORA_DISK_1: starting piece 1 at 25-SEP-09

channel ORA_DISK_1: finished piece 1 at 25-SEP-09

piece handle=/oracle/backup/full_DEMO1_20090925_1 tag=TAG20090925T170205 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00004 name=/oracle/oradata/demo1/users01.dbf

channel ORA_DISK_1: starting piece 1 at 25-SEP-09

channel ORA_DISK_1: finished piece 1 at 25-SEP-09

piece handle=/oracle/backup/full_DEMO1_20090925_2 tag=TAG20090925T170205 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 25-SEP-09

channel ORA_DISK_1: finished piece 1 at 25-SEP-09

piece handle=/oracle/backup/full_DEMO1_20090925_3 tag=TAG20090925T170205 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backup at 25-SEP-09

6、復制備份文件及控制文件

oracle@dg01 backup]$ scp full* oracle@10.134.140.194:/oracle/backup

??oracle@10.134.140.194's password: ******

full_DEMO1_20090925_1 100% 525MB 14.2MB/s 00:37

full_DEMO1_20090925_2 100% 384KB 384.0KB/s 00:00

full_DEMO1_20090925_3 100% 6976KB 6.8MB/s 00:01

[oracle@dg01 backup]$ scp standby.ctl oracle@10.134.140.194:/oracle/backup

password: ******

standby.ctl 100% 6896KB 6.7MB/s 00:01

[oracle@dg02 backup]$ cp standby.ctl /oracle/oradata/demo2/control01.ctl

[oracle@dg02 backup]$ cp standby.ctl /oracle/oradata/demo2/control02.ctl

[oracle@dg02 backup]$ cp standby.ctl /oracle/oradata/demo2/control03.ctl

7、將standby啟動到mount

[oracle@dg02 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Sep 25 17:10:03 2009

SQL> conn / as sysdba

Connected to an idle instance.

SQL> create spfile from pfile='$ORACLE_HOME/dbs/pfiledemo2.ora';

File created.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1261372 bytes

Variable Size 96469188 bytes

Database Buffers 184549376 bytes

Redo Buffers 2932736 bytes

SQL> alter database mount standby database;

Database altered.

8、用rman恢復備庫

[oracle@dg02 ~]$ rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Fri Sep 25 17:23:25 2009

connected to target database: DEMO1 (DBID=3701899587, not open)

RMAN> run

2> {

3> set newname for datafile 00001 to '/oracle/oradata/demo2/system01.dbf';

4> set newname for datafile 00002 to '/oracle/oradata/demo2/undotbs01.dbf';

5> set newname for datafile 00003 to '/oracle/oradata/demo2/sysaux01.dbf';

6> set newname for datafile 00004 to '/oracle/oradata/demo2/users01.dbf';

7> set newname for datafile 00005 to '/oradata/demo2/myuser.dbf';

8> restore database;

9> restore database;（不用加）

10> }

executing command: SET NEWNAME

Starting restore at 25-SEP-09

using channel ORA_DISK_1

skipping datafile 4; already restored to file /oracle/oradata/demo2/users01.dbf

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /oracle/oradata/demo2/system01.dbf

restoring datafile 00002 to /oracle/oradata/demo2/undotbs01.dbf

restoring datafile 00003 to /oracle/oradata/demo2/sysaux01.dbf

restoring datafile 00005 to /oradata/demo2/myuser.dbf

channel ORA_DISK_1: reading from backup piece /oracle/backup/full_DEMO1_20090925_1

channel ORA_DISK_1: restored backup piece 1

piece handle=/oracle/backup/full_DEMO1_20090925_1 tag=TAG20090925T170205

channel ORA_DISK_1: restore complete, elapsed time: 00:00:26

Finished restore at 25-SEP-09

Starting restore at 25-SEP-09

using channel ORA_DISK_1

skipping datafile 1; already restored to file /oracle/oradata/demo2/system01.dbf

skipping datafile 2; already restored to file /oracle/oradata/demo2/undotbs01.dbf

skipping datafile 3; already restored to file /oracle/oradata/demo2/sysaux01.dbf

skipping datafile 4; already restored to file /oracle/oradata/demo2/users01.dbf

datafile 5 is already restored to file /oradata/demo2/myuser.dbf

restore not done; all files readonly, offline, or already restored

Finished restore at 25-SEP-09

9、將備庫置於自動恢復狀態

SQL> select status from v$instance;

STATUS

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

MOUNTED

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

Database altered.

10、primary執行查詢

SQL> select dest_name,status,error,destination from v$archive_dest;

DEST_NAME STATUS ERROR DESTINATION

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

LOG_ARCHIVE_DEST_1 VALID /oracle/oradata/demo1

LOG_ARCHIVE_DEST_2 VALID demo2

LOG_ARCHIVE_DEST_3 INACTIVE

LOG_ARCHIVE_DEST_4 INACTIVE

LOG_ARCHIVE_DEST_5 INACTIVE

LOG_ARCHIVE_DEST_6 INACTIVE

LOG_ARCHIVE_DEST_7 INACTIVE

LOG_ARCHIVE_DEST_8 INACTIVE

LOG_ARCHIVE_DEST_9 INACTIVE

LOG_ARCHIVE_DEST_10 INACTIVE

10 rows selected.

SQL> select * from v$archive_gap;

no rows selected

SQL> select sequence# from v$log_history;

SEQUENCE#

----------

1

2

3

4

在standby上執行檢查

建立standby redo log

SQL> alter database add standby logfile group 4

2 ('/oracle/oradata/demo2/standby01.log') size 50M;

Database altered.

SQL> alter database add standby logfile group 5

2 ('/oracle/oradata/demo2/standby02.log') size 50M;

Database altered.

SQL> alter database add standby logfile group 6

2 ('/oracle/oradata/demo2/standby03.log') size 50M;

Database altered.

SQL> alter database add standby logfile group 7

2 ('/oracle/oradata/demo2/standby04.log') size 50M;

Database altered.

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_

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

3 ONLINE /oracle/oradata/demo2/redo03.log NO

2 ONLINE /oracle/oradata/demo2/redo02.log NO

1 ONLINE /oracle/oradata/demo2/redo01.log NO

4 STANDBY /oracle/oradata/demo2/standby01.log NO

5 STANDBY /oracle/oradata/demo2/standby02.log NO

6 STANDBY /oracle/oradata/demo2/standby03.log NO

7 STANDBY /oracle/oradata/demo2/standby04.log NO

7 rows selected.

三、switchover切換

1、检查环境：

确认主库和从库间网络连接通畅；

确认没有活动的会话连接在数据库中；

PRIMARY数据库处于打开的状态，STANDBY数据库处于MOUNT状态；

确保STANDBY数据库处于ARCHIVELOG模式；

如果设置了REDO应用的延迟，那么将这个设置去掉；

确保配置了主库和从库的初始化参数，使得切换完成后，DATA GUARD机制可以顺利的运行。

如果是最大保护模式，先变成最大性能模式：

2、切換順序：1、先將主庫切換到備庫；2、再將備庫切換為主庫。

3、主庫操作：

SQL> select DATABASE_ROLE from v$database;

DATABASE_ROLE

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

PRIMARY

SQL> select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,SWITCHOVER_STATUS from v$database;

OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS

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

READ WRITE MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE SESSIONS ACTIVE

SQL> alter database commit to switchover to physical standby with session shutdown;

Database altered.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1261372 bytes

Variable Size 113246404 bytes

Database Buffers 167772160 bytes

Redo Buffers 2932736 bytes

SQL> alter database mount standby database;

Database altered.

SQL> select DATABASE_ROLE from v$database;

DATABASE_ROLE

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

PHYSICAL STANDBY

SQL> select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,SWITCHOVER_STATUS from v$database;

OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS

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

MOUNTED MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE TO PRIMARY

4、備庫操作

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

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

SESSIONS ACTIVE

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database commit to switchover to primary with session shutdown;

Database altered.

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1261372 bytes

Variable Size 100663492 bytes

Database Buffers 180355072 bytes

Redo Buffers 2932736 bytes

Database mounted.

Database opened.

SQL> select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,SWITCHOVER_STATUS from v$database;

OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS

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

READ WRITE MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE SESSIONS ACTIVE

SQL> select DATABASE_ROLE from v$database;

DATABASE_ROLE

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

PRIMARY

2.failover:
已经代表主库不可用，先不管主库
备库运行一下代码：
A. 查看是否有日志GAP
Select thread#,sequence#,high_sequence# from v$archive_gap;
B．如果有，则拷贝过来并且注册
Alter database register physical logfile ‘路径’;
C.重复A直到没有日志GAP
D.alter database recover managed standby database finish force;
E.alter database commit switchover to primary.
F.alter database open/shutdown immediate+startup
G.备份先主库
H.善后工作。。。。。。

與物理standby有關的視圖

V$ARCHIVE_DEST

V$ARCHIVE_DEST_STATUS

V$ARCHIVE_GAP

V$ARCHIVED_LOG

V$DATABASE

V$DATABASE_INCARNATION

V$DATAFILE

V$DATAGUARD_CONFIG

V$DATAGUARD_STATS

V$DATAGUARD_STATUS

V$LOG

V$LOGFILE

V$LOG_HISTORY

V$STANDBY_LOG

V$MANAGED_STANDBY(physical only)

SQL> select sid,process,program from v$session where type='USER'

2 and sid<>(select distinct sid from v$mystat);

SID PROCESS PROGRAM

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

150 6287 oracle@dg02 (TNS V1-V3)

143 5629 oracle@dg01 (P001)

144 5627 oracle@dg01 (P000)

附B：此過程中部份錯誤

SQL> col destination for a25

SQL> SELECT DEST_ID, STATUS, DESTINATION FROM V$ARCHIVE_DEST;

DEST_ID STATUS DESTINATION

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

1 VALID /oracle/oradata/demo2

2 ERROR demo1

3 INACTIVE

4 INACTIVE

5 INACTIVE

6 INACTIVE

7 INACTIVE

8 INACTIVE

9 INACTIVE

10 INACTIVE

10 rows selected.

SQL> col destination for a25

SQL> SELECT DEST_ID, STATUS, DESTINATION FROM V$ARCHIVE_DEST;

DEST_ID STATUS DESTINATION

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

1 VALID /oracle/oradata/demo1

2 VALID demo2

3 INACTIVE

4 INACTIVE

5 INACTIVE

6 INACTIVE

7 INACTIVE

8 INACTIVE

9 INACTIVE

10 INACTIVE

11 VALID /oracle/oradata/demo1

11 rows selected.

SQL> select dest_name,status,error,destination from v$archive_dest;

DEST_NAME STATUS ERROR DESTINATION

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

LOG_ARCHIVE_DEST_1 VALID /oracle/oradata/demo2

LOG_ARCHIVE_DEST_2 ERROR ORA-12528: TNS:listener: all demo1

appropriate instances are blocking

new connections

ITPub博客

測試配置物理standby(2009)

最新文章