|
dump_dest = "D:\TRANS\UDUMP"
core_dump_dest = "D:\TRANS\CDUMP"
db_name = "WATSON"
# Please review the values of the following parameters:
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
__db_cache_size = 591396864
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
# The values of the following parameters are from source database:
sessions = 49
sga_target = 805306368
compatible = "10.2.0.1.0"
undo_management = "AUTO"
undo_tablespace = "UNDO"
shared_servers = 4
job_queue_processes = 4
open_cursors = 300
os_authent_prefix = ""
pga_aggregate_target = 268435456
6, Edit the init parameter file to meet the new system’s requirements.
Create a flash back recovery directory FRA located on “/u01/app/oracle/oradata/FRA”
[oracle@even oradata]$ mkdir -p FRA
[oracle@even oradata]$ ll
total 12
drwxr-xr-x 2 oracle oinstall 4096 Sep 4 12:27 FRA
drwxr-x--- 2 oracle oinstall 4096 Sep 4 08:23 OMR
drwxr-xr-x 2 oracle oinstall 4096 Sep 4 12:19 Watson
[oracle@even oradata]$ pwd
/u01/app/oracle/oradata
[oracle@even oradata]$
[oracle@even trans]$ export ORACLE_SID=Watson
根据具体的需要修改上面的初始化参数，并利用这个初始化参数启动数据库，修改后的初始化参数如下：
[oracle@even trans]$ vi INIT_00OJ5L2R_1_0.ORA
# Please change the values of the following parameters:
control_files = "/u01/app/oracle/oradata/Watson/control01.dbf"
db_recovery_file_dest = "/u01/app/oracle/oradata/FRA"
db_recovery_file_dest_size= 10737418240
audit_file_dest = "/u01/app/oracle/admin/Watson/adump"
background_dump_dest = "/u01/app/oracle/admin/Watson/bdump"
user_dump_dest = "/u01/app/oracle/admin/Watson/udump"
core_dump_dest = "/u01/app/oracle/admin/Watson/cdump"
db_name = "WATSON"
# Please review the values of the following parameters:
__shared_pool_size = 201326592
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
__db_cache_size = 591396864
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=Watson)"
# The values of the following parameters are from source database:
sessions = 49
sga_target = 805306368
compatible = "10.2.0.1.0"
undo_management = "AUTO"
undo_tablespace = "UNDO"
shared_servers = 4
job_queue_processes = 4
open_cursors = 300
os_authent_prefix = ""
pga_aggregate_target = 268435456
7,create the init parameter initWatson.ora to $ORACLE_HOME/dbs
[oracle@even trans]$ cp INIT_00OJ5L2R_1_0.ORA $ORACLE_HOME/dbs
[oracle@even trans]$ cd $ORACLE_HOME/dbs
[oracle@even dbs]$ ll
total 48
-rw-rw---- 1 oracle oinstall 1544 Sep 3 04:23 hc_OMR.dat
-rw-r--r-- 1 oracle oinstall 1331 Sep 4 12:36 INIT_00OJ5L2R_1_0.ORA
-rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora
-rw-rw---- 1 oracle oinstall 24 Sep 3 04:23 lkOMR
-rw-r----- 1 oracle oinstall 1536 Sep 3 05:32 orapwOMR
-rw-r----- 1 oracle oinstall 2560 Sep 4 12:00 spfileOMR.ora
[oracle@even dbs]$ cp INIT_00OJ5L2R_1_0.ORA initWatson.ora
[oracle@even dbs]$ ll
total 52
-rw-rw---- 1 oracle oinstall 1544 Sep 3 04:23 hc_OMR.dat
-rw-r--r-- 1 oracle oinstall 1331 Sep 4 12:36 INIT_00OJ5L2R_1_0.ORA
-rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 in |