DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 29

Thread: RMAN Configuration for 2 nodes RAC Database

  1. #11
    Join Date
    Jan 2001
    Posts
    2,828
    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.

  2. #12
    Join Date
    Aug 2007
    Posts
    54

    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,

  3. #13
    Join Date
    Jan 2001
    Posts
    2,828
    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

  4. #14
    Join Date
    Aug 2007
    Posts
    54

    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,

  5. #15
    Join Date
    Jan 2001
    Posts
    2,828
    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

  6. #16
    Join Date
    Aug 2007
    Posts
    54

    RMAN Configuration for 2 nodes RAC Database

    Hi,

    Hrishy. Why RMAN showing these backup files as Expired when crosschecked?

    Regards,

  7. #17
    Join Date
    Jan 2001
    Posts
    2,828
    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

  8. #18
    Join Date
    Aug 2007
    Posts
    54

    RMAN Configuration for 2 nodes RAC Database

    Yes Hrishy, they are at the same place.

  9. #19
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Post the full output of the command

    RMAN>crosscheck backup of database completed between 'sysdate-14' and 'sysdate'

    regards
    Hrishy

  10. #20
    Join Date
    Aug 2007
    Posts
    54

    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
  •  


Click Here to Expand Forum to Full Width