將spfile從ASM里遷移到文件系統(tǒng)
[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;????????????????????????????????? //查看當(dāng)前參數(shù)文件存放路徑

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???????????? //進(jìn)入系統(tǒng)參數(shù)文件存放路徑
[oracle@node1 /]$ cat initoradb.ora????????????????????????? //查看參數(shù)文件內(nèi)容
spfile=+DATA/oradb/parameterfile/spfile.268.762004477
[oracle@node1 /]$ rm -rf initoradb.ora?????????????????????? //將參數(shù)文件刪除

[oracle@node1 /]$ export ORACLE_SID=+ASM???????????????????? //設(shè)置ASM實(shí)例環(huán)境變量
[oracle@node1 /]$ asmcmd
ASMCMD> cd data/oradb/parameterfile????????????????????????? //進(jìn)入ASM 參數(shù)文件存放路徑
ASMCMD> ls -lt?????????????????????????????????????????????? //查看參數(shù)文件名
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?????????????? //設(shè)置環(huán)境變量
[oracle@node1 ~]$ sqlplus / as sysdba???????????????????? //進(jìn)入數(shù)據(jù)庫(kù)

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;??? //創(chuàng)建pfile參數(shù)文件，并指定參數(shù)文件路徑與文件名

File created.

SQL> !ls -lrt /u01/oracle/product/10g/dbs/initoradb.ora??????????????????//查看創(chuàng)建結(jié)果
-rw-r--r-- 1 oracle oinstall 989 Sep 16 14:34 /u01/oracle/product/10g/dbs/initoradb.ora
SQL> shutdown immediate?????????????????????????????????????????//關(guān)閉數(shù)據(jù)庫(kù)
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

[oracle@node1 /]$ export ORACLE_SID=+ASM??????????????????????? //設(shè)置ASM實(shí)例環(huán)境變量
[oracle@node1 /]$ asmcmd
ASMCMD> cd data/oradb/parameterfile???????????????????????????????????? //進(jìn)入?yún)?shù)文件
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實(shí)例上的參數(shù)文件
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';? //創(chuàng)建SPFILE參數(shù)文件
File created.
SQL> startup?????????????????????????????????????????????????????????? //開(kāi)啟數(shù)據(jù)庫(kù)
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;???????????????????????????????????????????//查看遷移后的參數(shù)文件

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???????????????????????????//查看遷移后參數(shù)文件內(nèi)容
?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'

轉(zhuǎn)載于:https://blog.51cto.com/mrxiong/693566

總結(jié)

以上是生活随笔為你收集整理的将spfile从ASM里迁移到文件系统的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。