Create Logical Standby For Oracle 10G

一、create physical standby

1.Enable force logging on Primary

SQL>alter database force logging;
SQL> select FORCE_LOGGING from v$database;

FOR
---
YES

2.Enable archivelog

SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database archivelog;
SQL>archive log list;[@more@]

3.Check redo log status on primary
SQL> select GROUP# ,STATUS ,TYPE ,MEMBER from v$logfile;

4.Create Standby Redo Log
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 '/ora101/oradata/STCSMES/redostb01.log' size 300m;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 '/ora101/oradata/STCSMES/redostb02.log' size 300m;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 '/ora101/oradata/STCSMES/redostb03.log' size 300m;

5.Modify pfile on primary

*.db_unique_name='STCSMES'
*.control_files='/ora101/oradata/STCSMES/control01.ctl','/ora101/oradata/STCSMES/control02.ctl','/ora101/oradata/STCSMES/control03.c
tl'
*.log_archive_config='DG_CONFIG=(STCSMES,FAB1STB)'
*.log_archive_dest_1='LOCATION=/ora101/archive/STCSMES/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STCSMES'
*.log_archive_dest_2='SERVICE=FAB1STB ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FAB1STB'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.remote_login_passwordfile='EXCLUSIVE'
*.log_archive_format='%t_%s_%r.arc'
*.fal_client='STCSMES'
*.fal_server='FAB1STB'
*.standby_file_management='AUTO'
---
*._allow_level_without_connect_by=TRUE
*._shared_pool_reserved_pct=10
*.audit_file_dest='/ora101/admin/STCSMES/adump'
*.background_dump_dest='/ora101/admin/STCSMES/bdump'
*.compatible='10.2.0.4.0'
*.control_files='/ora101/oradata/STCSMES/control01.ctl','/ora101/oradata/STCSMES/control02.ctl','/ora101/oradata/STCSMES/control03.c
tl'
*.core_dump_dest='/ora101/admin/STCSMES/cdump'
*.db_block_size=8192
*.db_cache_size=3221225472
*.db_domain=''
*.db_file_multiblock_read_count=32
*.DB_FILE_NAME_CONVERT='/ora101/oradata/STCSMES/','/ora104/oradata/FAB1STB/'
*.db_name='STCSMES'
*.db_recovery_file_dest='/ora101/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='STCSMES'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=STCSMESXDB)'
*.fal_client='STCSMES'
*.fal_server='FAB1STB'
*.global_names=FALSE
*.java_pool_size=100M
*.job_queue_processes=20
*.large_pool_size=100M
*.log_archive_config='DG_CONFIG=(STCSMES,FAB1STB)'
*.log_archive_dest_1='LOCATION=/ora101/archive/STCSMES/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STCSMES'
*.log_archive_dest_2='SERVICE=FAB1STB ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FAB1STB'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_file_name_convert='/ora101/oradata/STCSMES/',' /ora104/oradata/FAB1STB/','/ora101/archive/STCSMES/','/ora104/archive/FAB1STB/'
,'/ora101/archive/STCSMESL/','/ora104/archive/FAB1STBL/'
*.open_cursors=3000
*.pga_aggregate_target=1073741824
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.service_names='STCSMES'
*.session_cached_cursors=400
*.sessions=3305
*.sga_target=0
*.shared_pool_reserved_size=419430400
*.shared_pool_size=4096M
*.standby_archive_dest='?/dbs/arch'
*.standby_file_management='AUTO'
*.star_transformation_enabled='TRUE'
*.streams_pool_size=100M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/ora101/admin/STCSMES/udump'

6.create spfile from pfile;
SQL> create spfile from pfile;

7.create password file
On Primary :
orapwd file='$ORACLE_HOME/dbs/orapwSTCSMES' password=oracle entries=10;
On Standby :
orapwd file='$ORACLE_HOME/dbs/orapwFAB1STB' password=oracle entries=10;

8.Create Standby Controlfile on Primary

SQL>shutdown immedaite;
SQL>startup mount;
SQL>alter database create standby controlfile as '/ora101/oradata/STCSMES/stbcontrol01.ctl';
SQL>alter database open;
然後將該 controlfile 複製到 standby server 的對應位置

9.Setting tns (Primary)

STCSMES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.65)(PORT = 1521))
)
(CONNECT_DATA =
(SID = STCSMES)
)
)
FAB1STB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.200)(PORT = 1521))
)
(CONNECT_DATA =
(SID = FAB1STB)
)
)

################################
Setting Logical Standby
################################

10.create directory on Standby

mkdir -p


11.透過FTP把在主庫建立的密碼檔案、standby controlfile、datafile or backup file copy到備庫主機上。


12.Modify pfile on Standby

*.db_unique_name='FAB1STB'
*.control_files='/ora104/oradata/FAB1STB/stbcontrol01.ctl'
*.log_archive_dest_1='LOCATION=/ora104/archive/FAB1STB VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=FAB1STB'
*.log_archive_dest_2='SERVICE=STCSMES ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STCSMES'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.standby_archive_dest='/ora104/archive/FAB1STBL/'
*.remote_login_passwordfile='EXCLUSIVE'
*.fal_client='FAB1STB'
*.fal_server='STCSMES'
*.undo_management='AUTO'
*.db_file_name_convert='/ora101/oradata/STCSMES/','/ora104/oradata/FAB1STB/'
*.log_file_name_convert='/ora101/oradata/STCSMES/','/ora104/oradata/FAB1STB/','/ora101/archive/STCSMES/','/ora104/archive/FAB1STB/','/ora101/archive/STCSMESL/','/ora104/archive/

FAB1STBL/'

DB_FILE_NAME_CONVERT ---- 當 primary 和 standby 的資料檔案路徑不一致時使用
LOG_FILE_NAME_CONVERT ---- 當 primary 和 standby 的資料檔案路徑不一致時使用
LOCK_NAME_SPACE ---- 當主資料庫和備用資料在同一臺機上時設為備用資料庫的 SID
具體引數的說明請參考 oracle 線上文件
----

FAB1STB.__shared_pool_size=1577058304
*._shared_pool_reserved_pct=10
*.audit_file_dest='/ora104/admin/FAB1STB/adump'
*.background_dump_dest='/ora104/admin/FAB1STB/bdump'
*.compatible='10.2.0.4.0'
*.control_files='/ora104/oradata/FAB1STB/stbcontrol01.ctl'
*.core_dump_dest='/ora104/admin/FAB1STB/cdump'
*.db_block_size=8192
*.db_cache_size=1500M
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_file_name_convert='/ora101/oradata/STCSMES/','/ora104/oradata/FAB1STB/'
*.db_name='STCSMES'
*.db_recovery_file_dest='/ora104/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='FAB1STB'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=FAB1STBXDB)'
*.event='1349 trace name context forever, level 1048576'
*.fal_client='FAB1STB'
*.fal_server='STCSMES'
*.global_names=FALSE
*.java_pool_size=100M
*.job_queue_processes=20
*.large_pool_size=100M
*.log_archive_config='DG_CONFIG=(STCSMES,FAB1STB)'
*.log_archive_dest_1='LOCATION=/ora104/archive/FAB1STB VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=FAB1STB'
*.log_archive_dest_2='SERVICE=STCSMES ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STCSMES'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_file_name_convert='/ora101/oradata/STCSMES/','/ora104/oradata/FAB1STB/','/ora101/archive/STCSMES/','/ora104/archive/FAB1STB/',
'/ora101/archive/STCSMESL/','/ora104/archive/FAB1STBL/'
*.open_cursors=3000
*.pga_aggregate_target=700M
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.service_names='FAB1STB'
*.session_cached_cursors=400
*.sessions=3305
*.sga_max_size=2800M
*.sga_target=0
*.shared_pool_reserved_size=300M
*.shared_pool_size=3000000000
*.standby_archive_dest='/ora104/archive/FAB1STBL/'
*.standby_file_management='AUTO'
*.star_transformation_enabled='TRUE'
*.streams_pool_size=100M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/ora104/admin/FAB1STB/udump'



13.standby database 的 tnsnames.ora

FAB1STCSMES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.65)(PORT = 1521))
)
(CONNECT_DATA =
(SID = STCSMES)
)
)
FAB1STB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.200)(PORT = 1521))
)
(CONNECT_DATA =
(SID = FAB1STB)
)
)

14.啟動 standby database
SQL>create spfile from pfile;
SQL> startup nomount;
SQL>alter database mount standby database;

15.啟動 standby database 到 recover manage 模式
SQL>alter database recover managed standby database disconnect from session;

如果主庫從不過來歸檔，可以透過在主庫側手工修改引數如下：
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=MEMORY;
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY;

16.測試
透過在主庫執行alter system switch logfile;切換日誌可以觀察到備庫會自動應用透過主庫傳過來的日誌。

17.切換測試

17.1 在主庫端
select switchover_status from v$database;
如果是to standby 表可以正常切換.
直接執行 ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
否則執行: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

shutdown immediate;
startup nomount;
alter database mount standby database;

17.2 在備庫

在備庫
SELECT SWITCHOVER_STATUS FROM V$DATABASE;
如果是to_primary 表可以正常切換.
執行:ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
否則執行: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

shutdown immediate;
startup;

二、create logical standby

1.檢視哪些table不被支援的
SQL> SELECT OWNER, TABLE_NAME FROM DBA_LOGSTDBY_NOT_UNIQUE WHERE (OWNER,
2 TABLE_NAME) NOT IN (SELECT DISTINCT OWNER, TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED) AND BAD_COLUMN = 'Y'
3 ;

OWNER TABLE_NAME
------------------------------ ------------------------------
TSMSYS SRS$
SPOTLIGHT QUEST_SOO_PLAN_TABLE
SMPERP PLAN_TABLE
SMP_EMS PLAN_TABLE
SMP TMP_CELL_DATE_CODE
SMP PLAN_TABLE
SMP EXPDP_WIP_RUNCARD

2.檢視最後產生的archivelog

SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received",
2 APPL.SEQUENCE# "Last Sequence Applied" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V

$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY

THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;

Thread Last Sequence Received Last Sequence Applied
---------- ---------------------- ---------------------
1 6474 6474

3.Modify database initial parameter on primary

SQL>alter system set LOG_ARCHIVE_DEST_1='LOCATION=/ora101/archive/STCSMES/ VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STCSMES';
SQL>alter system set log_archive_dest_2='SERVICE=FAB1STB LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FAB1STB';
SQL>alter system set LOG_ARCHIVE_DEST_3= 'LOCATION=/ora101/archive/STCSMESL/ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=STCSMES';

4.Stop Redo Apply on the Physical Standby Database

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

5.Build a Dictionary in the Redo Data on Primary Database

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
SQL> select supplemental_log_data_pk,supplemental_log_data_ui from v$database;
SQL> alter system archive log current;

6.Convert to a Logical Standby Database

SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY FAB1STB;
SQL> shutdown immediate
SQL> startup mount
#Check database role
SQL> select name, db_unique_name, database_role from v$database;

NAME DB_UNIQUE_NAME DATABASE_ROLE
--------- ------------------------------ ----------------
FAB1STB FAB1STB LOGICAL STANDBY

7.Re-Create a New Password File for Logical Standby Database

>rm /ora104/10.2/dbs/orapwFAB1STB
>orapwd file='$ORACLE_HOME/dbs/orapwFAB1STB' password=oracle entries=10;


SQL> alter system set log_archive_dest_1='LOCATION=/ora104/archive/FAB1STB VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=FAB1STB';

SQL> alter system set log_archive_dest_2='SERVICE=STCSMES LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STCSMES';

SQL> alter system set log_archive_dest_3='LOCATION=/ora104/archive/FAB1STBL VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=FAB1STB';

8.Shutdown and Startup Logical Standby Database to Mount

SQL> SHUTDOWN immediate;
SQL> create spfile from pfile='/ora104/10.2/dbs/initFAB2STB.ora';
SQL> STARTUP MOUNT;

9.Open the Logical Standby Database

SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> shutdown immediate
SQL> startup


10.Identify the archived redo log that contains the log miner dictionary on primary

SQL> SELECT NAME FROM V$ARCHIVED_LOG WHERE (SEQUENCE#=(SELECT MAX(SEQUENCE#)
2 FROM V$ARCHIVED_LOG WHERE DICTIONARY_BEGIN = 'YES' AND STANDBY_DEST= 'NO'));

NAME
--------------------------------------------------------------------------------
/ora101/archive/STCSMES/1_6476_713463167.arc
FAB1STB

11.register the most recently archived redo log and begin applying data from the archive log on standby

SQL> ALTER DATABASE REGISTER LOGFILE '/ora104/archive/FAB1STB/1_6476_713463167.arc';
SQL> ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;

12.Test logical standby function on primary

SQL>SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SQL>ALTER SYSTEM SWITCH LOGFILE;
SQL>SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

13.Check LOGSTDBY_EVENTS and LOGSTDBY_LOG information on standby

SQL> SELECT EVENT_TIME, STATUS, EVENT FROM DBA_LOGSTDBY_EVENTS ORDER BY
EVENT_TIMESTAMP, COMMIT_SCN;

SQL> SELECT FILE_NAME, SEQUENCE# AS SEQ#, FIRST_CHANGE# AS FCHANGE#,
NEXT_CHANGE# AS NCHANGE#, TIMESTAMP, DICT_BEGIN AS BEG, DICT_END AS END,
THREAD# AS THR# ,APPLIED FROM DBA_LOGSTDBY_LOG ORDER BY SEQUENCE#;

14. Create Test Data on Primary

Create test user and insert data
CREATE USER "AGO" PROFILE "DEFAULT" IDENTIFIED BY "oracle" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
GRANT CREATE TABLE TO "AGO";
GRANT CREATE SESSION TO "AGO";
GRANT "CONNECT" TO "AGO";
GRANT "RESOURCE" TO "AGO";
ALTER USER "AGO" DEFAULT ROLE ALL
CREATE TABLE "AGO"."DEPT"("DEPTNO" NUMBER(4) NOT NULL, "DEPTNAME" VARCHAR2(10 byte));
insert into AGO.DEPT values('0001','MIS');
insert into AGO.DEPT values('0002','SALES');
insert into AGO.DEPT values('0006','ken');
commit;

15.Check data on logical standby

Select * from AGO.DEPT;

Remark:

primary&standby pfile

------
primary
---------
*._allow_level_without_connect_by=TRUE
*._shared_pool_reserved_pct=10
*.audit_file_dest='/ora101/admin/STCSMES/adump'
*.background_dump_dest='/ora101/admin/STCSMES/bdump'
*.compatible='10.2.0.4.0'
*.control_files='/ora101/oradata/STCSMES/control01.ctl','/ora101/oradata/STCSMES/control02.ctl','/ora101/oradata/STCSMES/control03.c
tl'
*.core_dump_dest='/ora101/admin/STCSMES/cdump'
*.db_block_size=8192
*.db_cache_size=3221225472
*.db_domain=''
*.db_file_multiblock_read_count=32
*.DB_FILE_NAME_CONVERT='/ora101/oradata/STCSMES/','/ora104/oradata/FAB1STB/'
*.db_name='STCSMES'
*.db_recovery_file_dest='/ora101/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='STCSMES'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=STCSMESXDB)'
*.fal_client='STCSMES'
*.fal_server='FAB1STB'
*.global_names=FALSE
*.java_pool_size=100M
*.job_queue_processes=20
*.large_pool_size=100M
*.log_archive_config='DG_CONFIG=(STCSMES,FAB1STB)'
*.log_archive_dest_1='LOCATION=/ora101/archive/STCSMES/ VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STCSMES'
*.log_archive_dest_2='SERVICE=FAB1STB LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FAB1STB'
*.log_archive_dest_3='LOCATION=/ora101/archive/STCSMESL/ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=STCSMES'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_file_name_convert='/ora101/oradata/STCSMES/',' /ora104/oradata/FAB1STB/','/ora101/archive/STCSMES/','/ora104/archive/FAB1STB/'
,'/ora101/archive/STCSMESL/','/ora104/archive/FAB1STBL/'
*.open_cursors=3000
*.pga_aggregate_target=1073741824
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.service_names='STCSMES'
*.session_cached_cursors=400
*.sessions=3305
*.sga_target=0
*.shared_pool_reserved_size=419430400
*.shared_pool_size=4096M
*.standby_archive_dest='?/dbs/arch'
*.standby_file_management='AUTO'
*.star_transformation_enabled='TRUE'
*.streams_pool_size=100M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/ora101/admin/STCSMES/udump'

------------------
logical standby
----------------

FAB1STB.__shared_pool_size=1577058304
*._shared_pool_reserved_pct=10
*.audit_file_dest='/ora104/admin/FAB1STB/adump'
*.background_dump_dest='/ora104/admin/FAB1STB/bdump'
*.compatible='10.2.0.4.0'
*.control_files='/ora104/oradata/FAB1STB/stbcontrol01.ctl'
*.core_dump_dest='/ora104/admin/FAB1STB/cdump'
*.db_block_size=8192
*.db_cache_size=1500M
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_file_name_convert='/ora101/oradata/STCSMES/','/ora104/oradata/FAB1STB/'
*.db_name='FAB1STB'
*.db_recovery_file_dest='/ora104/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='FAB1STB'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=FAB1STBXDB)'
*.event='1349 trace name context forever, level 1048576'
*.fal_client='FAB1STB'
*.fal_server='FAB1STCSMES'
*.global_names=FALSE
*.java_pool_size=100M
*.job_queue_processes=20
*.large_pool_size=100M
*.log_archive_config='DG_CONFIG=(STCSMES,FAB1STB)'
*.log_archive_dest_1='LOCATION=/ora104/archive/FAB1STB VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=FAB1STB'
*.log_archive_dest_2='SERVICE=STCSMES LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STCSMES'
*.log_archive_dest_3='LOCATION=/ora104/archive/FAB1STBL VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=FAB1STB'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.db_file_name_convert='/ora101/oradata/STCSMES/','/ora104/oradata/FAB1STB/'
*.log_file_name_convert='/ora101/archive/STCSMES/','/ora104/archive/FAB1STB/','/ora101/archive/STCSMESL/','/ora104/archive/FAB1STBL/'
*.open_cursors=3000
*.pga_aggregate_target=700M
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.service_names='FAB1STB'
*.session_cached_cursors=400
*.sessions=3305
*.sga_max_size=2800M
*.sga_target=0
*.shared_pool_reserved_size=300M
*.shared_pool_size=3000000000
*.standby_archive_dest='/ora104/archive/FAB1STBL/'
*.standby_file_management='AUTO'
*.star_transformation_enabled='TRUE'
*.streams_pool_size=100M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/ora104/admin/FAB1STB/udump'
參考：

http://www.blogjava.net/wxqxs/archive/2009/02/24/260736.html

http://space.itpub.net/7607759/viewspace-661552

http://space.itpub.net/7607759/viewspace-661552