移動(dòng)控制文件
[oracle@wallet01?~]$?sqlplus?/?as?sysdba
SQL>?set?line?200
SQL>?col?name?for?a60
SQL>?select?status,name?from?v$controlfile;

STATUS??NAME
-------?------------------------------------------------------------
????????/u01/app/oracle/oradata/wallet/control01.ctl
????????/u01/app/oracle/fast_recovery_area/wallet/control02.ctl
??????????????????????
SQL>?alter?system?set?control_files=
'/u01/app/oracle/oradata/wallet/control01.ctl',
'/u02/app/oracle/oradata/wallet/control02.ctl'?scope=spfile;
System?altered.

SQL>?shutdown?immediate???
Database?closed.
Database?dismounted.
ORACLE?instance?shut?down.

[oracle@wallet01?~]$?cp?/u01/app/oracle/oradata/wallet/control01.ctl?/u02/app/oracle/oradata/wallet/control02.ctl

[oracle@wallet01?~]$?sqlplus?/?as?sysdba
SQL>?startup
ORACLE?instance?started.

Total?System?Global?Area?1068937216?bytes
Fixed?Size??????????????????2260088?bytes
Variable?Size?????????????335545224?bytes
Database?Buffers??????????725614592?bytes
Redo?Buffers????????????????5517312?bytes
Database?mounted.
Database?opened.

SQL>?set?line?200
SQL>?col?name?for?a60
SQL>?select?status,name?from?v$controlfile;

STATUS??NAME
-------?------------------------------------------------------------
????????/u01/app/oracle/oradata/wallet/control01.ctl
????????/u02/app/oracle/oradata/wallet/control02.ctl
??????????????????????
SQL>?host?rm?-rf?/u01/app/oracle/flash_recovery_area/wallet/control02.ctl

創(chuàng)新互聯(lián)是一家專注于網(wǎng)站設(shè)計(jì)、成都網(wǎng)站制作與策劃設(shè)計(jì),成都網(wǎng)站建設(shè)哪家好?創(chuàng)新互聯(lián)做網(wǎng)站,專注于網(wǎng)站建設(shè)十余年,網(wǎng)設(shè)計(jì)領(lǐng)域的專業(yè)建站公司;建站業(yè)務(wù)涵蓋:成都等地區(qū)。成都做網(wǎng)站價(jià)格咨詢:028-86922220

重建控制文件
SQL>?show?parameter?user_dump_dest
NAME?????????????????????????????????TYPE??????????????????????????????VALUE
------------------------------------?---------------------------------?------------------------------
user_dump_dest???????????????????????string????????????????????????????/u01/app/oracle/diag/rdbms/kin
???????????????????????????????????????????????????????????????????????g/wallet/trace
???????????????????????????????????????????????????????????????????????
SQL>?alter?session?set?tracefile_identifier='trace_control';
Session?altered.

SQL>?alter?database?backup?controlfile?to?trace;
Database?altered.

[oracle@wallet01?~]$?cd?/u01/app/oracle/diag/rdbms/wallet/wallet/trace

[oracle@wallet01?trace]$?more?wallet_ora_28356_trace_control.trc

SQL>?shutdown?immediate
Database?closed.
Database?dismounted.
ORACLE?instance?shut?down.

SQL>?host?rm?-rf?/u01/app/oracle/oradata/wallet/control01.ctl

SQL>?host?rm?-rf?/u02/app/oracle/oradata/wallet/control02.ctl

SQL>?startup?nomount
ORACLE?instance?started.

Total?System?Global?Area?1068937216?bytes
Fixed?Size??????????????????2260088?bytes
Variable?Size?????????????335545224?bytes
Database?Buffers??????????725614592?bytes
Redo?Buffers????????????????5517312?bytes

SQL>?CREATE?CONTROLFILE?REUSE?DATABASE?"WALLET"?NORESETLOGS??ARCHIVELOG
????MAXLOGFILES?16
????MAXLOGMEMBERS?3
????MAXDATAFILES?100
????MAXINSTANCES?8
????MAXLOGHISTORY?292
LOGFILE
??GROUP?1?(
????'/u01/app/oracle/oradata/wallet/redo01a.log',
????'/u02/app/oracle/oradata/wallet/redo01b.log'
??)?SIZE?50M?BLOCKSIZE?512,
??GROUP?2?(
????'/u01/app/oracle/oradata/wallet/redo02a.log',
????'/u02/app/oracle/oradata/wallet/redo02b.log'
??)?SIZE?50M?BLOCKSIZE?512,
??GROUP?3?(
????'/u01/app/oracle/oradata/wallet/redo03a.log',
????'/u02/app/oracle/oradata/wallet/redo03b.log'
??)?SIZE?50M?BLOCKSIZE?512
--?STANDBY?LOGFILE
DATAFILE
??'/u01/app/oracle/oradata/wallet/system01.dbf',
??'/u01/app/oracle/oradata/wallet/sysaux01.dbf',
??'/u01/app/oracle/oradata/wallet/undotbs01.dbf',
??'/u01/app/oracle/oradata/wallet/users01.dbf',
??'/u01/app/oracle/oradata/wallet/soe01.dbf',
??'/u01/app/oracle/oradata/wallet/soe02.dbf',
CHARACTER?SET?AL32UTF8;
Control?file?created.

SQL>?shutdown?abort????
ORACLE?instance?shut?down.

SQL>?startup
ORACLE?instance?started.

Total?System?Global?Area?1068937216?bytes
Fixed?Size??????????????????2260088?bytes
Variable?Size?????????????335545224?bytes
Database?Buffers??????????725614592?bytes
Redo?Buffers????????????????5517312?bytes
Database?mounted.
Database?opened.

文章標(biāo)題：【OracleDatabase】數(shù)據(jù)庫控制文件管理
瀏覽地址：http://chinadenli.net/article44/gohpee.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站設(shè)計(jì)公司、網(wǎng)站制作、響應(yīng)式網(wǎng)站、自適應(yīng)網(wǎng)站、網(wǎng)站導(dǎo)航、電子商務(wù)

廣告

聲明：本網(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)