本篇內(nèi)容介紹了“怎么將spfile從ASM里遷移到文件系統(tǒng)”的有關(guān)知識，在實際案例的操作過程中，不少人都會遇到這樣的困境，接下來就讓小編帶領(lǐng)大家學習一下如何處理這些情況吧！希望大家仔細閱讀，能夠?qū)W有所成！

站在用戶的角度思考問題，與客戶深入溝通，找到襄垣網(wǎng)站設計與襄垣網(wǎng)站推廣的解決方案，憑借多年的經(jīng)驗，讓設計與互聯(lián)網(wǎng)技術(shù)結(jié)合，創(chuàng)造個性化、用戶體驗好的作品，建站類型包括：做網(wǎng)站、成都做網(wǎng)站、企業(yè)官網(wǎng)、英文網(wǎng)站、手機端網(wǎng)站、網(wǎng)站推廣、域名注冊、雅安服務器托管、企業(yè)郵箱。業(yè)務覆蓋襄垣地區(qū)。

[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;                                  //查看當前參數(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             //進入系統(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                     //設置ASM實例環(huán)境變量
[oracle@node1 /]$ asmcmd
ASMCMD> cd data/oradb/parameterfile                          //進入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               //設置環(huán)境變量
[oracle@node1 ~]$ sqlplus / as sysdba                     //進入數(shù)據(jù)庫

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ù)庫
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

[oracle@node1 /]$ export ORACLE_SID=+ASM                        //設置ASM實例環(huán)境變量
[oracle@node1 /]$ asmcmd
ASMCMD> cd data/oradb/parameterfile                                     //進入?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ù)文件
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                                                           //開啟數(shù)據(jù)庫
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'

“怎么將spfile從ASM里遷移到文件系統(tǒng)”的內(nèi)容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識可以關(guān)注創(chuàng)新互聯(lián)-成都網(wǎng)站建設公司網(wǎng)站，小編將為大家輸出更多高質(zhì)量的實用文章！

文章名稱：怎么將spfile從ASM里遷移到文件系統(tǒng)-創(chuàng)新互聯(lián)
本文鏈接：http://weahome.cn/article/ghoij.html