Home » RDBMS Server » Backup & Recovery » Unable to Recover database (Oracle 11g r2 )
Unable to Recover database [message #622396] Tue, 26 August 2014 02:14 Go to next message
RAJEMBAA7
Messages: 15
Registered: February 2014
Location: dubai
Junior Member
Hi,

When I try to recover rman backup in a new host I am getting the below error.

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: 'F:\APP\ADMINISTRATOR\ORADATA\RTEST\SYSTEM01.DBF'

I have taken the back using the below command
{
backup as compressed backupset database plus archivelog ;
backup current controlfile;
backup spfile;
}

I don't have the copy of archive logs .

Is it required to take the back up of archive logs and redo logs every time?
When we take the backup archive logs also will be backed up right?
How will I open the database with out this.

Kindly help

Thanks,
Rajesh.
Re: Unable to Recover database [message #622410 is a reply to message #622396] Tue, 26 August 2014 03:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is it required to take the back up of archive logs
Yes and you already did that.
>>and redo logs every time?
No. Never touch redologs.


You have not posted what you have done to do recovery.
Restore your control file.
Restore and recover your database to a particular point in time.


http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#BRADV908
Re: Unable to Recover database [message #622422 is a reply to message #622410] Tue, 26 August 2014 05:11 Go to previous messageGo to next message
RAJEMBAA7
Messages: 15
Registered: February 2014
Location: dubai
Junior Member
Hi,

Below are the steps I did

set oracle_home=D:\app\Administrator\product\11.2.0\dbhome_1
set oracle_sid=rtest
oradim -NEW -SID rtest -STARTMODE manual
rman target /
set DBID=474588511
STARTUP NOMOUNT
restore spfile from 'D:\BACKUP\C-474588511-20140813-00' ;
RESTORE CONTROLFILE FROM 'D:\BACKUP\C-1551984860-20140825-03' ;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;

Thanks,
Rajesh.
Re: Unable to Recover database [message #622425 is a reply to message #622422] Tue, 26 August 2014 05:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
YOu have to do a point in time recovery.
Re: Unable to Recover database [message #622445 is a reply to message #622425] Tue, 26 August 2014 08:38 Go to previous messageGo to next message
RAJEMBAA7
Messages: 15
Registered: February 2014
Location: dubai
Junior Member
Hi ,

I did that. Thank you very much for the help. I am just learning things

One more clarification

if we set

set until time "to_date('2014-08-26:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";

It will recover till this time right?

Which is right to give SCN or time?

Thanks,
Rajesh.
Re: Unable to Recover database [message #622447 is a reply to message #622445] Tue, 26 August 2014 08:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Yes
2/ If you know the SCN it is better to give the SCN but most of the time we only know the time from which Oracle computes an SCN.

Re: Unable to Recover database [message #622460 is a reply to message #622447] Tue, 26 August 2014 12:26 Go to previous message
tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV
Member
Here is a link to a good article for finding the "right" SCN to use for recovery.

http://goldparrot.wordpress.com/2011/05/16/how-to-find-exact-scn-number-for-oracle-restore/

Previous Topic: retention policy
Next Topic: archivelog deletetion
Goto Forum:
  


Current Time: Fri Mar 29 02:36:51 CDT 2024