OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN Cold Backup ( SUN OS 10.2.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN Cold Backup [message #506179]

Fri, 06 May 2011 18:42

hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI

Member

Hello Folks

I need to restore an RMAN Cold Backup of a Database B which is say 3 months old ,Tag-aa12345

into a Database B.

Both A and B are on the same server.

So i need to restore the RMAN Cold Backup of A under Tag aa12345 into Database B..

How can i do it?

Brief steps pls.

MM

Report message to a moderator

Re: RMAN Cold Backup [message #506210 is a reply to message #506179]

Sat, 07 May 2011 01:27

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You do not restore INTO a database, you restore a database.
That is (simplifying) nothing of the database exists before you restored.

Explain your requirements.

Regards
Michel

Report message to a moderator

Re: RMAN Cold Backup [message #506224 is a reply to message #506210]

Sat, 07 May 2011 02:40

hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI

Member

Thanks Micheal.

My Requirement.

Say Database A-I Take a RMAN Cold Backup Today.The TAG Name is TAG28125

Now i want to use the same Cold Backup after 6 days and refresh another database B.

A has Datafiles mount points like /u01/oradata/A
B has datafile mount points like /u01/oradata/B

A and B are in the same Server.

Another way of putting it..

"Use the Cold BACKUP of database A taken 6 days backs and refresh Database B running in the same server and mount points like above"

Report message to a moderator

Re: RMAN Cold Backup [message #506230 is a reply to message #506224]

Sat, 07 May 2011 03:01

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Now i want to use the same Cold Backup after 6 days and refresh another database B.

You can't.
You can use this backup to create a new database.

Backup and Recovery Advanced User's Guide
Chapter 7 Advanced RMAN Recovery Techniques
Section Restore and Recovery of the Database on a New Host

It is the same thing on the same server, you just have to care that your instance name is B and not A.

Regards
Michel

Report message to a moderator

Re: RMAN Cold Backup [message #506284 is a reply to message #506230]

Sat, 07 May 2011 19:28

hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI

Member

Hello Micheal

I still could not follow you?I am reading the link you said..

Do u mean to say I cannot use the Cold Backup of A and refresh B on the same machine

Thank

Report message to a moderator

Re: RMAN Cold Backup [message #506287 is a reply to message #506284]

Sat, 07 May 2011 20:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Michel is asleep & won't be back online for at least 2 - 3 more hours.

>Do u mean to say I cannot use the Cold Backup of A and refresh B on the same machine
depends on what you have & what you desire.
If you restore when ORACLE_SID=B, you will eliminate & lose what ever was contained in database B prior to doing the restore.

Report message to a moderator

Re: RMAN Cold Backup [message #506309 is a reply to message #506284]

Sun, 08 May 2011 01:17

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Do u mean to say I cannot use the Cold Backup of A and refresh B on the same machine

You cannot "refresh" in the meaning insert data into an existent database.
You can "refresh" in the meaning replace the database by a new one from the backup.
Cold or hot is irrelevant to the question.

Regards
Michel

Report message to a moderator

Previous Topic:	Label does not indicate name of previous volume
Next Topic:	NID- utility giving ora-01103 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 10:56:43 CDT 2024