STEPS TO RESTORE THE DB FROM BACKUP
====================================
1)Backups are located in /u01/tmp location
2)Start the db in nomount stage
startup nomount pfile='$ORACLE_HOME/dbs/initxyzdb.ora';
3) Restore the controlfile
4) rman> set dbid=123456;
5) rmna> restore controlfile from backup;
6) start the db in mount stage
7) catalog the files.
catalog start with '/u01/tmp';
8) restore th db
rman target / cmdfile= abc.rman log=/tmp/abc.log
run
{
set newname to data file 1 to '/u01/xyz_1.dbf';
set newname to data file 2 to '/u01/xyz_2.dbf';
--
--
restore database
switch datafile all;
}
9) Create the controlfile
10) Alter database open reset logs;
11) add the temp file
12)creat the spfile;
13)shutdown and start the db with spfile;
====================================
1)Backups are located in /u01/tmp location
2)Start the db in nomount stage
startup nomount pfile='$ORACLE_HOME/dbs/initxyzdb.ora';
3) Restore the controlfile
4) rman> set dbid=123456;
5) rmna> restore controlfile from backup;
6) start the db in mount stage
7) catalog the files.
catalog start with '/u01/tmp';
8) restore th db
rman target / cmdfile= abc.rman log=/tmp/abc.log
run
{
set newname to data file 1 to '/u01/xyz_1.dbf';
set newname to data file 2 to '/u01/xyz_2.dbf';
--
--
restore database
switch datafile all;
}
9) Create the controlfile
10) Alter database open reset logs;
11) add the temp file
12)creat the spfile;
13)shutdown and start the db with spfile;
No comments