Database Backup and Recovery (MOSC)

MOSC Banner

Recovery doesn´t Work - Recover Datafile using backup controlfile?

edited Apr 15, 2010 5:03AM in Database Backup and Recovery (MOSC) 18 commentsAnswered
Hai,

 i try to recover a database.

After this command:

RECOVER DATABASE UNTIL TIME '2010-04-05:18:00:00' USING BACKUP CONTROLFILE;

the recovery success but i should do a recovery of a datafile.

And there´s the problem. i don´t know how.

if i try this command:

recover datafile 9;

i got the message to use backup controlfile.

and this command:

recover datafile 9 using backup controlfile;

told me, that using is a bad parameter for recover datafile.

does anybody have an idea, how i can fix it?

Or do you need more information to help me?

Thanks a lot!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center