怎么將spfile從ASM里遷移到文件系統

本篇內容介紹了“怎么將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'

“怎么將spfile從ASM里遷移到文件系統”的內容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業相關的知識可以關注億速云網站，小編將為大家輸出更多高質量的實用文章！