DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: rman incremental backup

  1. #1
    Join Date
    Dec 2002
    Posts
    89

    rman incremental backup

    If i take a backup on sunday of level0 and monday of level1 if i have to restore database on tues morning.and i issue command restore database ,recover database will it restore full or only have changes from level0.

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Re: rman incremental backup

    Hi,
    If your database crashes on Tuesday morning,RMAN will first apply the level 0 backup taken on sunday.Then it will apply the monday level 1 backup(level 1 backup will contain all the changes made between Tuesday and Monday) and then till the time of the database crash RMAN will apply all the archivelog files on the datafiles to bring it to the point of crash.

    Regards,
    ROhit Nirkhe,Oracle/Apps DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: Re: rman incremental backup

    Originally posted by rohitsn
    (level 1 backup will contain all the changes made between Tuesday and Monday)
    I believe you meant "changes between Sunday and Monday"

    Sanjay
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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