Home » , , , » RMAN COLD BACKUP FOR RAC , HOW ?

RMAN COLD BACKUP FOR RAC , HOW ?

Written By Srikrishna Murthy Annam on Thursday, August 26, 2010 | 3:05 AM

What is meant by COLD BACKUP? Is it possible to take COLD BACKUP with RMAN?

In the normal backup and recovery terms , COLD BACKUP is the backup taken when the database is completely down. Then how do we connect to database with RMAN when the database is down?
The RMAN differentiates between "inconsistent" and "consistent" backups on the basis of whether the database is OPEN or not during the Backup. It will not use the terms "COLD BACKUP" and "HOT BACKUP".

For consistance RMAN RAC backup :


  1. Shutdown all the instances in a cluster

  2. connect to any one node and execute the following script

$rman target / nocatalog
RMAN>
run{
startup mount;
allocate channel backup_disk1 type disk format '+FRA';
backup full database;
shutdown immediate;
release channel backup_disk1;
}



Now we have the RMAN cold backup. Does it include online redo logs. How do we restore the RMAN backup taken earlier. Can we directly restore and open the database.

No.

RMAN will not backup online redologs. So when you restore the database from the backup taken above , you cant directly open the database as you dont have the online redologs. You have to open the database with reset logs.

This article is an example to backup RAC database with ASM. When the RAC with ASM Storage provides the high availability , why should we think of cold backup !!!!!!. This articles is only for concepts purpose and the real time RAC backups with RMAN  are completely different.

Hope it helps ....

--SRI
Share this article :

Related Articles By Category



+ comments + 6 comments

[...] RMAN cold backup for RAC, how ? [...]

swapna
May 11, 2011 at 6:56 AM

Keep up your good work Krishna..it's an amazing blog that you 've put up !

learnwithme11g
May 11, 2011 at 10:03 AM

Thanks Swapna. :-)

November 10, 2011 at 11:37 AM

(website flipping and domain flipping...

[...]RMAN COLD BACKUP FOR RAC , HOW ? « Oracle Database 11g Blog[...]...

henry jackson
March 17, 2012 at 12:07 PM

Excellent info but can I take this same rman backup restore it to the same hardware envirnoment on another server. I have been tasked to do this with rman and ASM.

learnwithme11g
March 17, 2012 at 2:25 PM

Hi Henry, The process is called RMAN duplication. Please follow my other article ...
http://learnwithme11g.wordpress.com/2011/07/04/rman-duplication-from-tape-backups/

Thanks
SRI

Post a Comment

Thank you for visiting our site and leaving your valuable comment.

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger