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

http://bbs.chinaunix.net/viewthread.php?tid=998901