RMAN-06094: datafile 1 must be restored


bash-3.2$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 5 12:41:27 2016

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

connected to target database: (not mounted)

RMAN> restore standby controlfile from '/dataguard_backup/stby.yed';

Starting restore at 05-FEB-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=962 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=+DATA/ANARDBdr/controlfile/current.1629.903007733

Finished restore at 05-FEB-16

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN> recover database ;

Starting recover at 05-FEB-16

Starting implicit crosscheck backup at 05-FEB-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=962 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=2 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=98 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=196 device type=DISK

Crosschecked 19 objects

Crosschecked 16 objects

Finished implicit crosscheck backup at 05-FEB-16

Starting implicit crosscheck copy at 05-FEB-16

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

Finished implicit crosscheck copy at 05-FEB-16

searching for all files in the recovery area

cataloging files...

no files cataloged

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 02/05/2016 12:42:16

RMAN-06094: datafile 1 must be restored

RMAN> CATALOG START WITH '/dataguard_backup/';

searching for all files that match the pattern /dataguard_backup/

List of Files Unknown to the Database

=====================================

File Name: /dataguard_backup/inc136qt5ni3_1_1.yed

File Name: /dataguard_backup/inc137qt5ni3_1_1.yed

File Name: /dataguard_backup/inc138qt5ni3_1_1.yed

File Name: /dataguard_backup/inc139qt5ni3_1_1.yed

File Name: /dataguard_backup/inc13aqt5nns_1_1.yed

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /dataguard_backup/inc136qt5ni3_1_1.yed

File Name: /dataguard_backup/inc137qt5ni3_1_1.yed

File Name: /dataguard_backup/inc138qt5ni3_1_1.yed

File Name: /dataguard_backup/inc139qt5ni3_1_1.yed

File Name: /dataguard_backup/inc13aqt5nns_1_1.yed

RMAN> recover database ;

Starting recover at 05-FEB-16

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 02/05/2016 12:42:53

RMAN-06094: datafile 1 must be restored

RMAN> ^D

Recovery Manager complete.

bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 5 12:43:07 2016

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, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

+NEWDATA/ANARDB/datafile/system.256.901826931

+NEWDATA/ANARDB/datafile/sysaux.257.901826931

+NEWDATA/ANARDB/datafile/undotbs1.258.901826933

+NEWDATA/ANARDB/datafile/users.259.901826933

+NEWDATA/ANARDB/datafile/undotbs2.267.901827123

+NEWDATA/ANARDB/datafile/data.274.901828377

+NEWDATA/ANARDB/datafile/data.275.901828433

+NEWDATA/ANARDB/datafile/data.276.901828485

+NEWDATA/ANARDB/datafile/data.277.901828547

+NEWDATA/ANARDB/datafile/data.278.901828605

+NEWDATA/ANARDB/datafile/indx.279.901828707

NAME

--------------------------------------------------------------------------------

+NEWDATA/ANARDB/datafile/indx.280.901828755

+NEWDATA/ANARDB/datafile/data.315.901944435

13 rows selected.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

bash-3.2$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 5 12:43:28 2016

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

connected to target database: ANARDB (DBID=4272911893, not open)

RMAN> CATALOG START WITH '+DATA';

using target database control file instead of recovery catalog

searching for all files that match the pattern +DATA

List of Files Unknown to the Database

=====================================

File Name: +data/ANARDBDR/DATAFILE/DATA.256.903008315

File Name: +data/ANARDBDR/DATAFILE/DATA.257.903008315

File Name: +data/ANARDBDR/DATAFILE/DATA.3554.903008317

File Name: +data/ANARDBDR/DATAFILE/DATA.2871.903008317

File Name: +data/ANARDBDR/DATAFILE/DATA.3751.903008327

File Name: +data/ANARDBDR/DATAFILE/INDX.2629.903008327

File Name: +data/ANARDBDR/DATAFILE/INDX.2630.903008327

File Name: +data/ANARDBDR/DATAFILE/SYSAUX.272.903008327

File Name: +data/ANARDBDR/DATAFILE/USERS.273.903008327

File Name: +data/ANARDBDR/DATAFILE/SYSTEM.274.903008331

File Name: +data/ANARDBDR/DATAFILE/DATA.275.903008333

File Name: +data/ANARDBDR/DATAFILE/UNDOTBS1.276.903008333

File Name: +data/ANARDBDR/DATAFILE/UNDOTBS2.277.903008333

File Name: +data/ASM/ASMPARAMETERFILE/REGISTRY.253.824766263

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: +data/ANARDBDR/DATAFILE/DATA.256.903008315

File Name: +data/ANARDBDR/DATAFILE/DATA.257.903008315

File Name: +data/ANARDBDR/DATAFILE/DATA.3554.903008317

File Name: +data/ANARDBDR/DATAFILE/DATA.2871.903008317

File Name: +data/ANARDBDR/DATAFILE/DATA.3751.903008327

File Name: +data/ANARDBDR/DATAFILE/INDX.2629.903008327

File Name: +data/ANARDBDR/DATAFILE/INDX.2630.903008327

File Name: +data/ANARDBDR/DATAFILE/SYSAUX.272.903008327

File Name: +data/ANARDBDR/DATAFILE/USERS.273.903008327

File Name: +data/ANARDBDR/DATAFILE/SYSTEM.274.903008331

File Name: +data/ANARDBDR/DATAFILE/DATA.275.903008333

File Name: +data/ANARDBDR/DATAFILE/UNDOTBS1.276.903008333

File Name: +data/ANARDBDR/DATAFILE/UNDOTBS2.277.903008333

List of Files Which Where Not Cataloged

=======================================

File Name: +data/ASM/ASMPARAMETERFILE/REGISTRY.253.824766263

 RMAN-07518: Reason: Foreign database file DBID: 0 Database Name:

RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA/ANARDBdr/datafile/system.274.903008331"

datafile 2 switched to datafile copy "+DATA/ANARDBdr/datafile/sysaux.272.903008327"

datafile 3 switched to datafile copy "+DATA/ANARDBdr/datafile/undotbs1.276.903008333"

datafile 4 switched to datafile copy "+DATA/ANARDBdr/datafile/users.273.903008327"

datafile 5 switched to datafile copy "+DATA/ANARDBdr/datafile/undotbs2.277.903008333"

datafile 6 switched to datafile copy "+DATA/ANARDBdr/datafile/data.2871.903008317"

datafile 7 switched to datafile copy "+DATA/ANARDBdr/datafile/data.3554.903008317"

datafile 8 switched to datafile copy "+DATA/ANARDBdr/datafile/data.256.903008315"

datafile 9 switched to datafile copy "+DATA/ANARDBdr/datafile/data.3751.903008327"

datafile 10 switched to datafile copy "+DATA/ANARDBdr/datafile/data.257.903008315"

datafile 11 switched to datafile copy "+DATA/ANARDBdr/datafile/indx.2630.903008327"

datafile 12 switched to datafile copy "+DATA/ANARDBdr/datafile/indx.2629.903008327"

datafile 13 switched to datafile copy "+DATA/ANARDBdr/datafile/data.275.903008333"

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: