satyam_2007

 Profile Answers by satyam_2007 

• Dec 14th, 2009

 

Using RMAN Open the database in mount mode;

Rman> restore database Recovry not required, as we are restoring from cold backup. However we can run Rman> recover database Open database now.

satyam_2007

 Profile Answers by satyam_2007 

• Dec 14th, 2009

 

 database should be in MOUNT mode
rman> restore database
rman> recover database;

Navas2u

 Profile Answers by Navas2u 

• Jan 8th, 2011

 

We don't need to recover a database if it were a consistent backup (cold).

But You should make sure to shutdown the DB with options available other than
Abort.

Nishant Chawre

• May 5th, 2012

 

Start the database in MOUNT mode
RMAN>restore database;

then if the online redo logs are intact then
RMAN>recover database;

if the online redo logs are not intact/not available then
RMAN>recover database noredo;

Code
--if the online redo logs are intact then


RMAN>restore DATABASE;


RMAN>recover DATABASE;


 


 


 


--if the online redo logs are not intact or not available then


RMAN>restore DATABASE;


RMAN>recover DATABASE noredo;

pavan.barakam

 Profile Answers by pavan.barakam 

• Jun 28th, 2014

 

Copy paste the backed up DBF files in the locations specified in PFILE and open the DB in startup mode.

Ravindra Dorlikar

• Dec 12th, 2014

 

Copy all datafile from latest cold backup as per datafile location in curret control file and make sure all the archive log file are present as the same location mentioned in pfile from the date of cold backup. once make sure all the file are at placed and all archive log files are at placed.

Start the database in mount state.

Connect by RMAN as:

rman target / nocatalog

Make the recovery until time:

run{
allocate channel ch1 device type disk;
set until time "to_date(2012-07-24:22:00:00,YYYY-MM-DD:hh:mm:ss)";
recover database;
}