Differential backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Differential backup

  1. #1
    Join Date
    Sep 2008
    Posts
    18

    Differential backup

    hello all,

    I have created a script for taking a full backup together with archive logs using RMAN.
    Now I wish to take differential backup as well.
    How do I do that? Is there any command from RMAN to take differential backup such us
    RMAN> backup database with differential;

    thanks

  2. #2
    Join Date
    Sep 2008
    Posts
    18
    I have tried :
    RMAN> backup database with differential;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, backup, backupset, channel, controlfilecopy, current, database, datafile, datafilecopy, delete, diskratio, filesperset, format, force, include, keep, (, maxsetsize, noexclude, nokeep, not, parms, pool, plus, ;, skip, spfile, setsize, tablespace, tag"
    RMAN-01008: the bad identifier was: with
    RMAN-01007: at line 1 column 17 file: standard input

    WITH is not correct.

    Does anyone knows the syntax of this command?

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what the hell is differential?


    you do man an incremental backup?

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by Mimas
    Does anyone knows the syntax of this command?
    How about checking Oracle documentation?

    You can start here...

    http://download.oracle.com/docs/cd/B...7.htm#CHDECGDC
    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
    Sep 2008
    Posts
    18
    If I have the following:
    --Weekly full backup--
    backup incremental level 0 database plus archivelog delete all input;
    -- Daily backup --
    backup incremental level 1 database plus archvielog delete all input;

    By having the above backups all the archivelogs after the backup will be deleted.
    What about when I will need to do a restore, don't I need the archivelogs as well and how to do a restore is RMAN>restore database; is ok?

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    About archivelogs...
    Yes, you will need your archivelogs during a restore... that's why you are backing them up.

    About RMAN Restore syntax...
    Why don't you check Oracle documentation? http://www.acs.ilstu.edu/docs/Oracle...1.htm#RCMRF149
    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.

  7. #7
    Join Date
    Sep 2008
    Posts
    18
    so the "delete all input;" at the end why is used?
    does it take archive logs (to use them in case of restore/recover)?
    I am asking because after the backup commands and delete all input; at the end I do not see the archivelogs just the backup files but when I do not put this at the end the archives appears.

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by Mimas
    so the "delete all input;" at the end why is used?
    does it take archive logs (to use them in case of restore/recover)?
    I am asking because after the backup commands and delete all input; at the end I do not see the archivelogs just the backup files but when I do not put this at the end the archives appears.
    Please read the documentation; all of your questions are answered there.
    You shouldn't be asking RMAN or any other tool to do stuff for you if you do not understand how they work and what are you asking for.
    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.

  9. #9
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Mimas,

    Incremental backups are differential by default.

    Check this link.....

    http://download-uk.oracle.com/docs/c...92/bkup004.htm

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