OraFAQ Forum: Backup & Recovery » Unable to Recover database

Home » RDBMS Server » Backup & Recovery » Unable to Recover database (Oracle 11g r2 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to Recover database [message #622396]

Tue, 26 August 2014 02:14

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.

Report message to a moderator

Re: Unable to Recover database [message #622410 is a reply to message #622396]

Tue, 26 August 2014 03:54

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Unable to Recover database [message #622422 is a reply to message #622410]

Tue, 26 August 2014 05:11

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.

Report message to a moderator

Re: Unable to Recover database [message #622425 is a reply to message #622422]

Tue, 26 August 2014 05:16

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

YOu have to do a point in time recovery.

Report message to a moderator

Re: Unable to Recover database [message #622445 is a reply to message #622425]

Tue, 26 August 2014 08:38

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.

Report message to a moderator

Re: Unable to Recover database [message #622447 is a reply to message #622445]

Tue, 26 August 2014 08:55

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Unable to Recover database [message #622460 is a reply to message #622447]

Tue, 26 August 2014 12:26

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/

Report message to a moderator

Previous Topic:	retention policy
Next Topic:	archivelog deletetion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 21:25:14 CST 2025