最近2018中文字幕在日韩欧美国产成人片_国产日韩精品一区二区在线_在线观看成年美女黄网色视频_国产精品一区三区五区_国产精彩刺激乱对白_看黄色黄大色黄片免费_人人超碰自拍cao_国产高清av在线_亚洲精品电影av_日韩美女尤物视频网站

移動控制文件
[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

為長葛等地區(qū)用戶提供了全套網(wǎng)頁設(shè)計(jì)制作服務(wù)，及長葛網(wǎng)站建設(shè)行業(yè)解決方案。主營業(yè)務(wù)為成都做網(wǎng)站、成都網(wǎng)站建設(shè)、長葛網(wǎng)站設(shè)計(jì)，以傳統(tǒng)方式定制建設(shè)網(wǎng)站，并提供域名空間備案等一條龍服務(wù)，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠的服務(wù)。我們深信只要達(dá)到每一位用戶的要求，就會得到認(rèn)可，從而選擇與我們長期合作。這樣，我們也可以走得更遠(yuǎn)！

重建控制文件
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.

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)scvps.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

本文標(biāo)題：【OracleDatabase】數(shù)據(jù)庫控制文件管理-創(chuàng)新互聯(lián)
當(dāng)前URL：http://fisionsoft.com.cn/article/pgjci.html