Restore and recover of a datafile to another database
Hi,
The database version is 9i and using rman.
I need to restore and recover datafile 6 from database A to database B.
Hence, I restore the backup set of the controlfiles, system file, undo, temp files and datafile 6 from database A to B in the following actions:
First, at database B, I offline all the tablespaces except system file, undo, temp and datafile 6.
I startup no mount, then restore the controlfiles, mount the database.
After that I restore the system file, undo, temp and datafile 6. Then, I try to recover database using backup controlfile.
It gives me the error of
I need to restore and recover datafile 6 from database A to database B.
Hence, I restore the backup set of the controlfiles, system file, undo, temp files and datafile 6 from database A to B in the following actions:
First, at database B, I offline all the tablespaces except system file, undo, temp and datafile 6.
I startup no mount, then restore the controlfiles, mount the database.
After that I restore the system file, undo, temp and datafile 6. Then, I try to recover database using backup controlfile.
It gives me the error of
0