Home » RDBMS Server » Backup & Recovery » Unable to start database after point-in-time recovery
Unable to start database after point-in-time recovery [message #232558] Sat, 21 April 2007 03:38 Go to next message
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 ?
Re: Unable to start database after point-in-time recovery [message #232569 is a reply to message #232558] Sat, 21 April 2007 05:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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


Re: Unable to start database after point-in-time recovery [message #232602 is a reply to message #232558] Sun, 22 April 2007 00:26 Go to previous messageGo to next message
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 432 times)
Re: Unable to start database after point-in-time recovery [message #232603 is a reply to message #232602] Sun, 22 April 2007 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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

Re: Unable to start database after point-in-time recovery [message #232605 is a reply to message #232603] Sun, 22 April 2007 02:22 Go to previous messageGo to next message
aydenise
Messages: 6
Registered: April 2007
Location: HK
Junior Member
Thank you for your advice.

In other words, i cannot recover the database up to certain time.
Re: Unable to start database after point-in-time recovery [message #232606 is a reply to message #232605] Sun, 22 April 2007 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is more up to about a certain time. Smile

Regards
Michel
Re: Unable to start database after point-in-time recovery [message #232676 is a reply to message #232606] Sun, 22 April 2007 23:49 Go to previous message
kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Hi,

Do u have the physical file '/archive/gets/arch/1_78580.dbf'? Can u pls check that?
Previous Topic: how to backup
Next Topic: Need help
Goto Forum:
  


Current Time: Sat Dec 03 22:24:18 CST 2016

Total time taken to generate the page: 0.05275 seconds