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

140次閱讀

共計 3924 個字符，預計需要花費 10 分鐘才能閱讀完成。

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

[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

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