cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle restore not working

Former Member
0 Kudos

Hi Guys,

I am unable to restore a online consistent backup of Oracle.

The restore is happening fine.

But when I try to recover the database or take the database in open state, it gives an error that one data file needs more recovery.

How can a consistent backup need more recovery?

Thanks & Regards

Arko Provo Mukherjee

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Arko,

You have to recover it using the archive log generated at the time of backup.

Read this link

http://help.sap.com/saphelp_nw04s/helpdata/en/d7/839e9f72dd4049896dab7d153662c5/content.htm

Regards

Ashok

Edited by: Ashok Dalai on Sep 27, 2008 6:50 AM

lakshminarayanan_m
Contributor
0 Kudos

Hi,

Will u please provide the details aboutm the error

Thanks

MLN