RE: RMAN-06067: RECOVER DATABASE required with a backup or created control file
- From: Nisha Mohan <NishaMohan_A@xxxxxxxxxxx>
- To: Phillip Jones <phil@xxxxxxxxxx>
- Date: Wed, 22 Aug 2012 11:57:48 +0000
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@xxxxxxxxxx]
Sent: Wednesday, August 22, 2012 4:51 PM
To: Nisha Mohan
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx<mailto:NishaMohan_A@xxxxxxxxxxx>> 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***
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
