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: AZCBS (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/azcbsdr/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/azcbs/datafile/system.256.901826931
+NEWDATA/azcbs/datafile/sysaux.257.901826931
+NEWDATA/azcbs/datafile/undotbs1.258.901826933
+NEWDATA/azcbs/datafile/users.259.901826933
+NEWDATA/azcbs/datafile/undotbs2.267.901827123
+NEWDATA/azcbs/datafile/data.274.901828377
+NEWDATA/azcbs/datafile/data.275.901828433
+NEWDATA/azcbs/datafile/data.276.901828485
+NEWDATA/azcbs/datafile/data.277.901828547
+NEWDATA/azcbs/datafile/data.278.901828605
+NEWDATA/azcbs/datafile/indx.279.901828707
NAME
--------------------------------------------------------------------------------
+NEWDATA/azcbs/datafile/indx.280.901828755
+NEWDATA/azcbs/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: AZCBS (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/AZCBSDR/DATAFILE/DATA.256.903008315
File Name: +data/AZCBSDR/DATAFILE/DATA.257.903008315
File Name: +data/AZCBSDR/DATAFILE/DATA.3554.903008317
File Name: +data/AZCBSDR/DATAFILE/DATA.2871.903008317
File Name: +data/AZCBSDR/DATAFILE/DATA.3751.903008327
File Name: +data/AZCBSDR/DATAFILE/INDX.2629.903008327
File Name: +data/AZCBSDR/DATAFILE/INDX.2630.903008327
File Name: +data/AZCBSDR/DATAFILE/SYSAUX.272.903008327
File Name: +data/AZCBSDR/DATAFILE/USERS.273.903008327
File Name: +data/AZCBSDR/DATAFILE/SYSTEM.274.903008331
File Name: +data/AZCBSDR/DATAFILE/DATA.275.903008333
File Name: +data/AZCBSDR/DATAFILE/UNDOTBS1.276.903008333
File Name: +data/AZCBSDR/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/AZCBSDR/DATAFILE/DATA.256.903008315
File Name: +data/AZCBSDR/DATAFILE/DATA.257.903008315
File Name: +data/AZCBSDR/DATAFILE/DATA.3554.903008317
File Name: +data/AZCBSDR/DATAFILE/DATA.2871.903008317
File Name: +data/AZCBSDR/DATAFILE/DATA.3751.903008327
File Name: +data/AZCBSDR/DATAFILE/INDX.2629.903008327
File Name: +data/AZCBSDR/DATAFILE/INDX.2630.903008327
File Name: +data/AZCBSDR/DATAFILE/SYSAUX.272.903008327
File Name: +data/AZCBSDR/DATAFILE/USERS.273.903008327
File Name: +data/AZCBSDR/DATAFILE/SYSTEM.274.903008331
File Name: +data/AZCBSDR/DATAFILE/DATA.275.903008333
File Name: +data/AZCBSDR/DATAFILE/UNDOTBS1.276.903008333
File Name: +data/AZCBSDR/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/azcbsdr/datafile/system.274.903008331"
datafile 2 switched to datafile copy "+DATA/azcbsdr/datafile/sysaux.272.903008327"
datafile 3 switched to datafile copy "+DATA/azcbsdr/datafile/undotbs1.276.903008333"
datafile 4 switched to datafile copy "+DATA/azcbsdr/datafile/users.273.903008327"
datafile 5 switched to datafile copy "+DATA/azcbsdr/datafile/undotbs2.277.903008333"
datafile 6 switched to datafile copy "+DATA/azcbsdr/datafile/data.2871.903008317"
datafile 7 switched to datafile copy "+DATA/azcbsdr/datafile/data.3554.903008317"
datafile 8 switched to datafile copy "+DATA/azcbsdr/datafile/data.256.903008315"
datafile 9 switched to datafile copy "+DATA/azcbsdr/datafile/data.3751.903008327"
datafile 10 switched to datafile copy "+DATA/azcbsdr/datafile/data.257.903008315"
datafile 11 switched to datafile copy "+DATA/azcbsdr/datafile/indx.2630.903008327"
datafile 12 switched to datafile copy "+DATA/azcbsdr/datafile/indx.2629.903008327"
datafile 13 switched to datafile copy "+DATA/azcbsdr/datafile/data.275.903008333"
RMAN> recover database;
Starting recover 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
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: +DATA/azcbsdr/datafile/system.274.903008331
destination for restore of datafile 00007: +DATA/azcbsdr/datafile/data.3554.903008317
destination for restore of datafile 00012: +DATA/azcbsdr/datafile/indx.2629.903008327
channel ORA_DISK_1: reading from backup piece /dataguard_backup/inc137qt5ni3_1_1.yed
channel ORA_DISK_2: starting incremental datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: +DATA/azcbsdr/datafile/sysaux.272.903008327
destination for restore of datafile 00004: +DATA/azcbsdr/datafile/users.273.903008327
destination for restore of datafile 00006: +DATA/azcbsdr/datafile/data.2871.903008317
channel ORA_DISK_2: reading from backup piece /dataguard_backup/inc139qt5ni3_1_1.yed
channel ORA_DISK_3: starting incremental datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: +DATA/azcbsdr/datafile/undotbs1.276.903008333
destination for restore of datafile 00005: +DATA/azcbsdr/datafile/undotbs2.277.903008333
destination for restore of datafile 00008: +DATA/azcbsdr/datafile/data.256.903008315
destination for restore of datafile 00009: +DATA/azcbsdr/datafile/data.3751.903008327
channel ORA_DISK_3: reading from backup piece /dataguard_backup/inc136qt5ni3_1_1.yed
channel ORA_DISK_4: starting incremental datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
destination for restore of datafile 00010: +DATA/azcbsdr/datafile/data.257.903008315
destination for restore of datafile 00011: +DATA/azcbsdr/datafile/indx.2630.903008327
destination for restore of datafile 00013: +DATA/azcbsdr/datafile/data.275.903008333
channel ORA_DISK_4: reading from backup piece /dataguard_backup/inc138qt5ni3_1_1.yed
channel ORA_DISK_1: piece handle=/dataguard_backup/inc137qt5ni3_1_1.yed tag=TAG20160205T123826
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
channel ORA_DISK_2: piece handle=/dataguard_backup/inc139qt5ni3_1_1.yed tag=TAG20160205T123826
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:55
channel ORA_DISK_4: piece handle=/dataguard_backup/inc138qt5ni3_1_1.yed tag=TAG20160205T123826
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:55
channel ORA_DISK_3: piece handle=/dataguard_backup/inc136qt5ni3_1_1.yed tag=TAG20160205T123826
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:01:45
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: