RE: 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:57:48 +0000
Message-ID: <D2EF2C83C5C50B4CB202F0619D52874801843D_at_BLRKECMBX11.ad.infosys.com>



I am new to RMAN and learning it.
What I have done is as follows .(pls be patient as it is little lengthy) .

SQL> startup mount;
SQL> alter database archivelog;

RMAN> connect target
RMAN> CONNECT CATALOG rman/rman
RMAN> CREATE CATALOG TABLESPACE 'CATALOG';
RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog full resync complete

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------
1       223     OMIGTEST 260103938        PARENT  1          16-AUG-12
1       2       OMIGTEST 260103938        CURRENT 324561     20-AUG-12


RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data_idx1/ORAMIG/cf%F'; RMAN> RUN

      {
        ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '/data_idx1/ORAMIG/OMIGTEST/%U';
        BACKUP DATABASE PLUS ARCHIVELOG;
      }

After the above procedures I deleted few records from a table as follows.

select count(*) from MAST;

  COUNT(*)


      7373

SQL> select tablespace_name from user_tables where table_name='MAST';

TABLESPACE_NAME



MAST_1 SQL> select file_name from dba_data_files where TABLESPACE_NAME=MAST_1';

FILE_NAME



/data_idx1/ORAMIG/OMIGTEST/DATA_FILES/MAST_1_WAS1025.dbf SQL> delete from MAST where rownum<100;

99 rows deleted.

SQL> commit;

Commit complete.

SQL> shutdown immediate
SQL> startup mount
RMAN> restore tablespace MAST_1;
RMAN> restore controlfile to '/oracle/ora10gr4/dbs/nis.ctl';

SQL> alter database 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

Please let me know if I am wrong or not. I want to recover the data I deleted from that table.

Thanks and Regards,
Nisha Mohan.A

From: Phillip Jones [mailto:phil_at_phillip.im] Sent: Wednesday, August 22, 2012 4:51 PM To: Nisha Mohan
Cc: oracle-l_at_freelists.org
Subject: Re: RMAN-06067: RECOVER DATABASE required with a backup or created control file

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

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



--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 22 2012 - 06:57:48 CDT

Original text of this message