一、描述
單實(shí)例ADG數(shù)據(jù)庫(kù)，備庫(kù)system01.dbf文件損壞，需要重新恢復(fù)數(shù)據(jù)文件，保證主庫(kù)庫(kù)數(shù)據(jù)一致。

創(chuàng)新互聯(lián)堅(jiān)持“要么做到，要么別承諾”的工作理念，服務(wù)領(lǐng)域包括：網(wǎng)站建設(shè)、網(wǎng)站制作、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣等服務(wù)，滿足客戶于互聯(lián)網(wǎng)時(shí)代的許昌網(wǎng)站設(shè)計(jì)、移動(dòng)媒體設(shè)計(jì)的需求，幫助企業(yè)找到有效的互聯(lián)網(wǎng)解決方案。努力成為您成熟可靠的網(wǎng)絡(luò)建設(shè)合作伙伴！

二、處理過(guò)程

1、數(shù)據(jù)庫(kù)啟動(dòng)到mount狀態(tài)
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 12 20:42:35 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database (not started)

RMAN> startup mount;

Oracle instance started
database mounted

Total System Global Area 3089920000 bytes

Fixed Size 2257232 bytes
Variable Size 654315184 bytes
Database Buffers 2415919104 bytes
Redo Buffers 17428480 bytes

2、使用RMAN恢復(fù)
$rman target sys/xxxx@devdb auxiliary sys/xxx@devdbdg

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 12 20:43:53 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: DEVDB (DBID=931475173)
connected to auxiliary database: DEVDB (DBID=931475173, not open)

RMAN> run {
allocate channel d1 type disk ;
allocate channel d2 type disk ;
backup as copy reuse
datafile 1 auxiliary format '/oradata/devdbdg/system01.dbf';
}2> 3> 4> 5> 6>

using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=1145 device type=DISK

allocated channel: d2
channel d2: SID=1715 device type=DISK

Starting backup at 12-DEC-2019 20:45:23
channel d1: starting datafile copy
input datafile file number=00001 name=/oradata/devdb/system01.dbf

output file name=/oradata/devdbdg/system01.dbf tag=TAG20191212T204523
channel d1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 12-DEC-2019 20:45:38
released channel: d1
released channel: d2

RMAN>
RMAN> exit

Recovery Manager complete.
$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 12 20:45:50 2019

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> *select from t;**

ID

 1
 2
 3
 4

SQL>
SQL> select process,status from v$managed_standby;

PROCESS STATUS

ARCH CONNECTED
ARCH CONNECTED
ARCH CLOSING
ARCH CONNECTED
RFS IDLE
RFS IDLE
RFS IDLE
MRP0 APPLYING_LOG