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,
Printable View
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
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
You should connect as sys with sysdbaQuote:
$ rman target system/devrman;