-
Lost control files of Target Database
Hi, I lost my control files of target database. How to recover the database from RMAN backup. I take full database backup using RMAN weekly.
thanks,
-
using the restore command, which part of the docs did you get stuck on
-
Hi
I hope you do backup the controlfiles right ?
regards
Hrishy
-
Hi
use the command
RMAN>restore controlfile;
The rman backup keep the snapshot of the spfile.
gopu
-
Lost control files of Target Database
Hi, I cannot mount the database. Both the target database and catalog database are on same machine. The Restore database command does'nt work, RMAN displays error: Database not mounted.
Iam logging to RMAN by giving
$ rman target system/devrman;
-
Hi
First u want to restore the spile.
RMAN>restore spfile;
then u restore the controlfie.
RMAN>restore controlfile;
then mount the database;
RMAN>startup mount;
then the database will be in the mount stage,then you can restore the database using the command restore dataabase;
gopu
-
$ rman target system/devrman;
You should connect as sys with sysdba
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|