select inst_id,name from gv$controlfile; INST_ID NAME..."/>
您好,登錄后才能下訂單哦!
當前控制文件
SQL> select inst_id,name from gv$controlfile;
INST_ID NAME
---------- -------------------------------------------------------
2 +DG1/prodb/controlfile/current.276.998921677
1 +DG1/prodb/controlfile/current.276.998921677
備份參數(shù)文件
SQL> create pfile='/home/oracle/prodb.pfile' from spfile;
修改參數(shù)文件
SQL> alter system set control_files='+DG1/prodb/controlfile/current.276.998921677','+FRG' scope=spfile sid='*';
關閉數(shù)據(jù)庫
[oracle@prodb1 ~]$ srvctl stop database -d racdb -o immediate
檢查狀態(tài)
[oracle@prodb1 ~]$ srvctl status database -d prodb ;
恢復控制文件
[oracle@prodb1 ~]$ rman target /
RMAN> startup nomount;
RMAN> restore controlfile from '+DG1/prodb/controlfile/current.276.998921677';
Starting restore at 30-JAN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 instance=prodb1 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=+DG1/prodb/controlfile/current.276.998921677
output file name=+FRG/prodb/controlfile/current.334.998923047
RMAN> exit;
重啟數(shù)據(jù)庫
[oracle@prodb1 ~]$ srvctl stop database -d prodb -o immediate;
[oracle@prodb1 ~]$ srvctl start database -d prodb
驗證
SQL> select inst_id,name from gv$controlfile;
INST_ID NAME
---------- -------------------------------------------------------
2 +DG1/prodb/controlfile/current.276.998921677
2 +FRG/prodb/controlfile/current.334.998923047
1 +DG1/prodb/controlfile/current.276.998921677
1 +FRG/prodb/controlfile/current.334.998923047
SQL> show parameter controlfile
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DG1/prodb/controlfile/current
.276.998921677, +FRG/prodb/con
trolfile/current.334.998923047
control_management_pack_access string DIAGNOSTIC+TUNING
SQL>
免責聲明:本站發(fā)布的內容(圖片、視頻和文字)以原創(chuàng)、轉載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權內容。