DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Restauration RMAN après des sauvegardes différentilles et cumulati

  1. #1
    Join Date
    Jan 2009
    Posts
    4

    Restauration RMAN après des sauvegardes différentilles et cumulati

    Procédure de restauration après une sauvegarde incrémentale niveau 0 (full) + une suvegarde cumulative (niveau 1)

    Est-ce que cette procédure est correcte pour restaurer une sauvegarde incrémentale de niveau 0 plus une sauvegarde cumulative


    RMAN> alter database mount ;
    RMAN> restore database tag='sauvegarde_incrémentale niveau 0';
    RMAN> restore database tag='sauvegarde_incrémentale cumulative niveau 1';
    RMAN> recover database
    RMAN> alter database open resetlogs ;

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    im guessing as you wrote in french - but you dont restore a level 0 then a level 1 - you set the time you want to restore to using set until an then just issue a restore and the recover

  3. #3
    Join Date
    Jan 2009
    Posts
    4
    OK thank you for your answer, but I tried this already but this brings me back to the status of the base that does not include my backup cumulatively.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    That's pretty interesting, it looks like your level=1 is not merged with your level=0.

    I have two follow up questions.

    1- What's your Oracle version? is it Ora10g?
    2- Could you please show us the command you used to take incremental level=1 backup?

    In regards to question #2 - if you are running on Ora10g it should look something like:

    RMAN> backup incremental level_1 for recover of copy with tag level_0 database;
    Last edited by PAVB; 01-03-2009 at 10:09 AM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Jan 2009
    Posts
    4
    I have two follow up questions.

    1- What's your Oracle version? is it Ora10g?
    Yes It's Oracle 10G
    2- Could you please show us the command you used to take incremental level=1 backup?
    BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE with TAG .....;
    3.
    RMAN> backup incremental level_1 for recover of copy with tag level_0 database

    After this command, is it necessary to restore ?

  6. #6
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    RMAN> backup incremental level_1 for recover of copy with tag level_0 database; is this command mandatory for 10G?
    Cant we use
    RMAN>backup incremental level 1 database with tag='level_0'; ?

  7. #7
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Mohit -

    If you use that command your level 1 backup is just tagged as level_0 (tag='level_0'). If you want to recover your base level 0 backup every time with level 1 you have to use

    RMAN> backup incremental level_1 for recover of copy with tag level_0 database;

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  8. #8
    Join Date
    Jan 2009
    Posts
    4
    Ok, after this command is it necessary
    to realise this step
    RMAN> recover database
    RMAN> alter database open resetlogs
    Thanks

  9. #9
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Davis -

    That command is to recover your base backup. If you want to recover your database from the backup then you need to follow the regular restore / recover process.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  10. #10
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    sorry for syntactical error in the previous post...what i meant was
    MAN> backup incremental level1 database tag='level1';

    Wont this command work?

    The command 'for recover of copy' is especially used fro incrementally updated backups where we continuously update the base backup(level 0) by applying the incremental backup...


    So i think the command which i mentioned should also work...

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