RMAN Restore of Hot Backup

[rcurva]

Hi Guys,

I am a bit new to RMAN but I need to restore a database on a new server with the current rman hot backup like below;

run {
ALLOCATE CHANNEL c1 TYPE DISK;

BACKUP DATABASE
TAG = 'DATABASE_DAILY'
SETSIZE = 2097152
FORMAT '/u06/LNFTKPRD_RMAN_DISK_BACKUP/LNFTKPRD_database_%u_%s_%p.bkp';

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP ARCHIVELOG ALL
SETSIZE = 2097152
FORMAT '/u08/LNFTKPRD_RMAN_DISK_BACKUP/LNFTKPRD_archivelog_%u_%s_%p.bkp'
DELETE INPUT;

BACKUP CURRENT CONTROLFILE
TAG = 'LNFTKPRD_CONTROL_FILE'
FORMAT '/u08/LNFTKPRD_RMAN_DISK_BACKUP/LNFTKPRD_controlfile_%u_%s_%p.bkp';
}

The database is in archivelog mode. Can I just copy the init.ora and control file then do a restore database without copying the datafiles? What is the rman command to restore this database?

Thanks for any help.


Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided&quot" -- Art of War

 

[dbtoo2001]

http://forums.oracle.com/forums/thread.jspa?messageID=2262928&#2262928