
1 SQL>showparameterspfile
2 NAMETYPEVALUE
3 ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
4 spfilestring+NEW_DATA/racdb/spfileracdb.ora
1 ‐‐查看參數(shù)文件
2 catinitracdb2.ora
3 SPFILE='+NEW_DATA/racdb/spfileracdb.ora'#lineaddedbyAgent
1 SQL>colNAMEfora50
2 SQL>selectstatus,namefromv$controlfile;
3 STATUSNAME
4 ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
5 +DATA/racdb/control01.ctl
6 +DATA/racdb/control02.ctl
7 或
8 SQL>showparametercontrol_files;
9 NAMETYPEVALUE
10 ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
‐‐
11 control_filesstring+DATA/racdb/control01.ctl,
12 +DATA/racdb/control02.ctl
2、關(guān)閉數(shù)據(jù)庫(kù)所有實(shí)例,啟動(dòng)一個(gè)實(shí)例到nomount,用rman備份控制文件
1 SQL>startupnomount;‐‐=>啟庫(kù)為nomount
2 RMAN>restorecontrolfileto'+NEW_DATA/racdb/control01.ctl'from'+DATA/
racdb/control01.ctl';
3 Startingrestoreat15‐OCT‐21
4 usingtargetdatabasecontrolfileinsteadofrecoverycatalog
5 allocatedchannel:ORA_DISK_1
6 channelORA_DISK_1:SID=667instance=racdb3devicetype=DISK
7
8 channelORA_DISK_1:copiedcontrolfilecopy
9 Finishedrestoreat15‐OCT‐21
10 RMAN>restorecontrolfileto'+NEW_DATA/racdb/control02.ctl'from'+DAT
A/racdb/control02.ctl';
11 Startingrestoreat15‐OCT‐21
12 usingchannelORA_DISK_1
13
文檔被以下合輯收錄
評(píng)論