Home » RDBMS Server » Backup & Recovery » Rman backup valid or not (Oracle RDBMS Version 9.2.0.6.0., O/S - SunOS 5.9)
Rman backup valid or not [message #314386] Wed, 16 April 2008 09:23 Go to next message
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,
Re: Rman backup valid or not [message #314388 is a reply to message #314386] Wed, 16 April 2008 09:35 Go to previous messageGo to next message
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).

Re: Rman backup valid or not [message #314457 is a reply to message #314386] Wed, 16 April 2008 15:19 Go to previous messageGo to next message
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.
Re: Rman backup valid or not [message #314487 is a reply to message #314386] Wed, 16 April 2008 21:42 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

1)Restore .. Validate
2)Possible.
Re: Rman backup valid or not [message #314566 is a reply to message #314487] Thu, 17 April 2008 03:14 Go to previous messageGo to next message
praveenkumar25
Messages: 8
Registered: March 2008
Location: DELHI
Junior Member
thanks for reply.
Re: Rman backup valid or not [message #314647 is a reply to message #314386] Thu, 17 April 2008 06:14 Go to previous message
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
Previous Topic: data not acess
Next Topic: recovery scenario
Goto Forum:
  


Current Time: Thu Dec 08 14:02:13 CST 2016

Total time taken to generate the page: 0.08340 seconds