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,
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,
RMAN Configuration for 2 nodes RAC Database
Hi,
Hrishy. Why RMAN showing these backup files as Expired when crosschecked?
Regards,
RMAN Configuration for 2 nodes RAC Database
Yes Hrishy, they are at the same place.
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