將spfile從ASM裡遷移到檔案系統
[oracle@node1 /]$ su - oracle
[oracle@node1 /]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 16 14:28:57 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> show parameter spfile; //檢視當前引數檔案存放路徑
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/oradb/parameterfile/spfi
le.268.762004477
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@node1 /]$ cd /u01/oracle/product/10g/dbs //進入系統引數檔案存放路徑
[oracle@node1 /]$ cat initoradb.ora //檢視引數檔案內容
spfile=+DATA/oradb/parameterfile/spfile.268.762004477
[oracle@node1 /]$ rm -rf initoradb.ora //將引數檔案刪除
[oracle@node1 /]$ export ORACLE_SID=+ASM //設定ASM例項環境變數
[oracle@node1 /]$ asmcmd
ASMCMD> cd data/oradb/parameterfile //進入ASM 引數檔案存放路徑
ASMCMD> ls -lt //檢視引數檔名
Type Redund Striped Time Sys Name
PARAMETERFILE MIRROR COARSE SEP 16 13:00:00 Y spfile.268.762004477
ASMCMD> exit
[oracle@node1 /]$ export ORACLE_SID=oradb //設定環境變數
[oracle@node1 ~]$ sqlplus / as sysdba //進入資料庫
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 16 14:34:00 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create pfile='/u01/oracle/product/10g/dbs/initoradb.ora' from spfile; //建立pfile引數檔案，並指定引數檔案路徑與檔名
File created.
SQL> !ls -lrt /u01/oracle/product/10g/dbs/initoradb.ora //檢視建立結果
-rw-r--r-- 1 oracle oinstall 989 Sep 16 14:34 /u01/oracle/product/10g/dbs/initoradb.ora
SQL> shutdown immediate //關閉資料庫
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[oracle@node1 /]$ export ORACLE_SID=+ASM //設定ASM例項環境變數
[oracle@node1 /]$ asmcmd
ASMCMD> cd data/oradb/parameterfile //進入引數檔案
ASMCMD> ls -lt
Type Redund Striped Time Sys Name
PARAMETERFILE MIRROR COARSE SEP 16 13:00:00 Y spfile.268.762004477
ASMCMD> rm spfile.268.762004477 //刪除ASM例項上的引數檔案
ASMCMD> exit
[oracle@node1 /]$ export ORACLE_SID=oradb
[oracle@node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 16 14:34:00 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>
SQL> create spfile='/u01/oracle/product/10g/dbs/spfileoradb.ora' from pfile='/u01/oracle/product/10g/dbs/initoradb.ora'; //建立SPFILE引數檔案
File created.
SQL> startup //開啟資料庫
ORACLE instance started.
Total System Global Area 230686720 bytes
Fixed Size 1218676 bytes
Variable Size 71305100 bytes
Database Buffers 155189248 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> show parameter spfile; //檢視遷移後的引數檔案
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/oracle/product/10g/dbs/sp
fileoradb.ora
SQL> exit
[oracle@node1 dbs]$ cd /u01/oracle/product/10g/dbs
[oracle@node1 dbs]$ cat spfileoradb.ora //檢視遷移後引數檔案內容
?2kk-oradb.__db_cache_size=155189248
oradb.__java_pool_size=4194304
oradb.__large_pool_size=4194304
oradb.__shared_pool_size=62914560
oradb.__streams_pool_size=0
*.audit_file_dest='/u01/oracle/product/admin/oradb/adump'
*.background_dump_dest='/u01/oracle/product/admin/oradb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='+DATA/oradb/controlfile/backup.259.762002877'#Restore Controlfile
*.core_dump_dest='/u01/oracle/product/admin/oradb/cdump'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='oradb'
*.db_recovery_file_dest_size=2147483648
*.db_recovery_file_dest='+DATA'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oradbXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=75497472
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=228589568
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/oracle/product/admin/oradb/udump'