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

From: Phillip Jones <phil_at_phillip.im>
Date: Wed, 22 Aug 2012 12:24:27 +0100
Message-ID: <CAOyzJuev5zO8XYg8fDaRmhL3_a0SdRxYchoec0cy-vOcm2gsoQ_at_mail.gmail.com>

Can you explain in detail what you're trying to do? Restore a database from scratch, restore just a lost controlfile, or recover from a specific data loss situation?
Cheers,

Phil

On Wed, Aug 22, 2012 at 12:14 PM, Nisha Mohan <NishaMohan_A_at_infosys.com>wrote:

> 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'
>
>
>

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

Received on Wed Aug 22 2012 - 06:24:27 CDT