OraFAQ Forum: Backup & Recovery » Unable to start database after point-in-time recovery

Home » RDBMS Server » Backup & Recovery » Unable to start database after point-in-time recovery

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

Unable to start database after point-in-time recovery [message #232558]

Sat, 21 April 2007 03:38

aydenise
Messages: 6
Registered: April 2007
Location: HK

Junior Member

I restore the backup from hot backup and using the command below.

SQL> recover database until time '2007-04-06:01:00:00' using backup controlfile;

However, I failed to recover the database and open the database using the command below;

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u40/oradata/gets/system01.dbf'

Could anyone advice what I should do ?

Report message to a moderator

Re: Unable to start database after point-in-time recovery [message #232569 is a reply to message #232558]

Sat, 21 April 2007 05:51

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You already post this and I already post you:

recover more datafile 1

that is Oracle asked you for archived logs during the recovery, you have to provide them.

Regards
Michel

Report message to a moderator

Re: Unable to start database after point-in-time recovery [message #232602 is a reply to message #232558]

Sun, 22 April 2007 00:26

aydenise
Messages: 6
Registered: April 2007
Location: HK

Junior Member

The archive files have already restored but the recovery time restored for the backup is in hot backup mode. What should I do in order to recover database up to time that is in hot backup mode ?

The log is attached.

Attachment: recover.log
(Size: 8.12KB, Downloaded 1687 times)

Report message to a moderator

Re: Unable to start database after point-in-time recovery [message #232603 is a reply to message #232602]

Sun, 22 April 2007 01:02

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't understand your post and what you said about your hot backup.

In your log you have:

Quote:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u40/oradata/gets/system01.dbf'

which seems quite clear.
And actually this is was you got when you tried to open:

Quote:

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u40/oradata/gets/system01.dbf'

You can't stop at this time. You have to recover a little bit more. Try a "recover automatic ... until time" and let Oracle chooses what he wants.

Regards
Michel

Report message to a moderator