RMAN Configuration for 2 nodes RAC Database

[hrishy]

Hi

Well i am confused.

In one of the above post you mention the rman command
crosscheck backup completed before sysdate

shows the backup as expired But now you are saying the command does not return anything.

This clearly means there is more than what meets the eyes.

You ran some other commands in between like a rman delete command that deleted the backups from the rman catalog database.

I am not sure what you did but if you need help like this remotely you need to be precise and post the entire sequence of commands you executed for us to help.

You need to also consider buying disk space so you can store enough backups or start looking at a very good tape library that can manage your backups in accordance with your retention policy

IMHO you need practice rman backups on a single instance database first in a test environment till you grasp the nuances of rman

The crosscheck command should have worked for you

Look here in the documentation

http://download-uk.oracle.com/docs/c...yn21.htm#80887


You can perform a small test your self to reproduce what you did liek this

1)Backup database plus archivelog
2)Make a copy of the backupset
3)Delete the backupset using os commands
4)run rman crosscheck command it should report the backup pieces as expired since they are no longer accessible from the place where rman thinks they should be
5)move the backupsets to the smae place as before
6)run rman crosscheck command rman should recognize the backup pieces and mark them available


regards
Hrishy