OraFAQ Forum: Backup & Recovery » Rman backup valid or not

Home » RDBMS Server » Backup & Recovery » Rman backup valid or not (Oracle RDBMS Version 9.2.0.6.0., O/S - SunOS 5.9)

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

Rman backup valid or not [message #314386]

Wed, 16 April 2008 09:23

praveenkumar25
Messages: 8
Registered: March 2008
Location: DELHI

Junior Member

Hi,
In our organisation, Backups are taken through Rman on tapes. I've 2 questions

1. I need to check whether backups are valid or not, how can I check.

2. Is it possible to restore the backup to different database with same structure and perform recovery?

Thank you,

Report message to a moderator

Re: Rman backup valid or not [message #314388 is a reply to message #314386]

Wed, 16 April 2008 09:35

ebrian
Messages: 2794
Registered: April 2006

Senior Member

The best way to test the validity of your backups is to restore to another node (Restore and Recovery of the Database on a New Host).

Report message to a moderator

Re: Rman backup valid or not [message #314457 is a reply to message #314386]

Wed, 16 April 2008 15:19

debrucer
Messages: 7
Registered: March 2008
Location: san diego california

Junior Member

The first response is a very valid one; but, doesn't address your second question. If you are using 10g R2 you can do what you are requesting - it's called transportable tablespaces from RMAN. Obviously, you do not restore the entire backup to another instances, just user tablespaces.

Report message to a moderator

Re: Rman backup valid or not [message #314487 is a reply to message #314386]

Wed, 16 April 2008 21:42

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

1)Restore .. Validate
2)Possible.

Report message to a moderator

Re: Rman backup valid or not [message #314566 is a reply to message #314487]

Thu, 17 April 2008 03:14

praveenkumar25
Messages: 8
Registered: March 2008
Location: DELHI

Junior Member

thanks for reply.

Report message to a moderator

Re: Rman backup valid or not [message #314647 is a reply to message #314386]

Thu, 17 April 2008 06:14

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

hi
The main purpose of RMAN validation is to check for corrupt blocks and missing files. You can also use RMAN to determine whether backups can be restored.

RMAN> VALIDATE DATABASE;

RMAN> VALIDATE BACKUPSET 22;
......

check this link

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmvalid.htm

Gopu

Report message to a moderator

Previous Topic:	data not acess
Next Topic:	recovery scenario

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 06:00:58 CST 2024