-
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
Last edited by hrishy; 09-03-2007 at 02:36 AM.
-
RMAN Configuration for 2 nodes RAC Database
Hi,
hrishy I typed the command wrongly as
RMAN>crosscheck backup completed between 'sysdate' and 'sysdate-30';
It should be
RMAN>crosscheck backup completed between 'sysdate-30' and 'sysdate';
as we are searching result from the previous 30 days to till date.
So this is returning me correct output which shows backup files as expired.
Sorry for inconvenience, hrishy I think you are very near to clear my problem as you have understood everything clearly from OS to database. Please help me.
Regards,
-
Hi
Well now if you have restored the backupsets exactly at the same path from where you had deleted it then the crosscheck backup command should now find that the backupsets are available and should mark them as available
What else do you need ?
regards
Hrishy
-
RMAN Configuration for 2 nodes RAC Database
Hi,
hrishy sorry to say that again we went back to initial stage. As I said initially that the latest backup sets/files are physically present on disk, I have not deleted them. Than why to restore them?
Regards,
-
Hi
If the backupsets are present on the disk in the same place as rman expects them to be then you dont need to anything ?
Whats your question now ?
regards
Hrishy
-
RMAN Configuration for 2 nodes RAC Database
Hi,
Hrishy. Why RMAN showing these backup files as Expired when crosschecked?
Regards,
-
Hi
RMAN expects them to find at the same place where it previously backed them up.Now not finding it at the same place rman thinks that the backup has expired.
Are these files at the same place where it was backed up
regards
Hrishy
-
RMAN Configuration for 2 nodes RAC Database
Yes Hrishy, they are at the same place.
-
Hi
Post the full output of the command
RMAN>crosscheck backup of database completed between 'sysdate-14' and 'sysdate'
regards
Hrishy
-
RMAN Configuration for 2 nodes RAC Database
Hrishy, this is the output
RMAN> crosscheck backup of database
2> completed between 'sysdate-14' and 'sysdate';
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4fiq9uj1_1_1 recid=3144 stamp=631568993
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4giq9uko_1_1 recid=3145 stamp=631569048
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4hiq9unn_1_1 recid=3146 stamp=631569144
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4iiq9us9_1_1 recid=3147 stamp=631569289
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4jiq9uuu_1_1 recid=3148 stamp=631569374
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4kiq9v0v_1_1 recid=3149 stamp=631569440
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4liq9v2n_1_1 recid=3150 stamp=631569495
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4miq9v4e_1_1 recid=3151 stamp=631569550
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4niq9v65_1_1 recid=3152 stamp=631569606
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4oiq9v7t_1_1 recid=3153 stamp=631569661
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/4piq9v9u_1_1 recid=3154 stamp=631569727
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5aiqjugs_1_1 recid=3171 stamp=631896604
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5biqjuij_1_1 recid=3172 stamp=631896660
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5ciqjuli_1_1 recid=3173 stamp=631896755
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5diqjuq4_1_1 recid=3174 stamp=631896900
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5eiqjusp_1_1 recid=3175 stamp=631896985
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5fiqjuuq_1_1 recid=3176 stamp=631897051
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5giqjv0i_1_1 recid=3177 stamp=631897106
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5hiqjv29_1_1 recid=3178 stamp=631897161
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5iiqjv40_1_1 recid=3179 stamp=631897217
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5jiqjv5o_1_1 recid=3180 stamp=631897272
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/makkdb1-bk/rman/5kiqjv7p_1_1 recid=3181 stamp=631897340
Crosschecked 22 objects
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|