Database Backup and Recovery (MOSC)

MOSC Banner

Recover Database

edited May 29, 2011 2:03AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
 To All,
 I'm trying to recreate our test database by using the database files from Prod Server.  I copy the files  & use a text copy of the control files to create the database.

The Problem is when i use command#1 it gives an error but when i use command#2 it works fine. I just know for my knowledge the reason of this.

Command#1:
 recover database using backup controlfile;

Error:-

ORA-00308: cannot open archive log 'name.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information:3


Command#2;

RECOVER DATABASE using backup controlfile until cancel;

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