RMAN-06067: RECOVER DATABASE required with a backup or created control file

From: Nisha Mohan <NishaMohan_A_at_infosys.com>
Date: Wed, 22 Aug 2012 11:14:16 +0000
Message-ID: <D2EF2C83C5C50B4CB202F0619D5287480183E6_at_BLRKECMBX11.ad.infosys.com>

Hi,
Oracle version :10.2.04
I recovered control files .
RMAN> restore controlfile to '/oracle/ora10gr4/dbs/nis.ctl';

Starting restore at 21-AUG-12
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: restoring control file output filename=/oracle/ora10gr4/dbs/nis.ctl channel ORA_DISK_1: reading from backup piece /data_idx1/ORAMIG/OMIGTEST/cfc-260103938-20120821-03 channel ORA_DISK_1: restored backup piece 1 piece handle=/data_idx1/ORAMIG/OMIGTEST/cfc-260103938-20120821-03 tag=TAG20120821T152259 channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 Finished restore at 21-AUG-12

after this i got the below error when i tried to open DB. SQL> alter database open resetlogs;
alter database open resetlogs
*

ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1:
'/data_idx1/ORAMIG/OMIGTEST/DATA_FILES/system_1_OMIGTEST.dbf'

So i tried the following.
RMAN> restore datafile '/data_idx1/ORAMIG/OMIGTEST/DATA_FILES/system_1_OMIGTEST.dbf';

Starting restore at 21-AUG-12
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /data_idx1/ORAMIG/OMIGTEST/DATA_FILES/system_1_OMIGTEST.dbf channel ORA_DISK_1: reading from backup piece /data_idx1/ORAMIG/OMIGTEST29_1_791910787 channel ORA_DISK_1: restored backup piece 1 piece handle=/data_idx1/ORAMIG/OMIGTEST29_1_791910787 tag=TAG20120821T151306 channel ORA_DISK_1: restore complete, elapsed time: 00:00:15 Finished restore at 21-AUG-12

RMAN> recover datafile '/data_idx1/ORAMIG/OMIGTEST/DATA_FILES/system_1_OMIGTEST.dbf';

Starting recover at 21-AUG-12
using channel ORA_DISK_1

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

RMAN-03002: failure of recover command at 08/21/2012 16:21:45 RMAN-06067: RECOVER DATABASE required with a backup or created control file

Can anyone pls help me with this error?

Thanks and Regards,
Nisha Mohan.A

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
  ***INFOSYS******** End of Disclaimer ********INFOSYS***
  

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 22 2012 - 06:14:16 CDT