本篇內(nèi)容介紹了“怎么將spfile從ASM里遷移到文件系統(tǒng)”的有關(guān)知識(shí),在實(shí)際案例的操作過程中,不少人都會(huì)遇到這樣的困境,接下來就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧!希望大家仔細(xì)閱讀,能夠?qū)W有所成!
站在用戶的角度思考問題,與客戶深入溝通,找到景谷網(wǎng)站設(shè)計(jì)與景谷網(wǎng)站推廣的解決方案,憑借多年的經(jīng)驗(yàn),讓設(shè)計(jì)與互聯(lián)網(wǎng)技術(shù)結(jié)合,創(chuàng)造個(gè)性化、用戶體驗(yàn)好的作品,建站類型包括:成都網(wǎng)站設(shè)計(jì)、網(wǎng)站制作、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣、域名與空間、虛擬空間、企業(yè)郵箱。業(yè)務(wù)覆蓋景谷地區(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; //查看當(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ù)庫
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 //設(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 //開啟數(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)的知識(shí)可以關(guān)注創(chuàng)新互聯(lián)網(wǎng)站,小編將為大家輸出更多高質(zhì)量的實(shí)用文章!
當(dāng)前標(biāo)題:怎么將spfile從ASM里遷移到文件系統(tǒng)
網(wǎng)頁路徑:http://www.muchs.cn/article6/ipphog.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供建站公司、軟件開發(fā)、企業(yè)建站、網(wǎng)站收錄、網(wǎng)站維護(hù)、虛擬主機(jī)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)