DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008

    restore rman FULL backup without archivelogs.

    I have done a full RMAN backup plus archivelog using

    backup tag=MASTER_BACKUPSET_27NOV08 database spfile include current controlfile plus archivelog;

    now I want to keep it as a master copy forever using KEEP option.

    change backup tag 'MASTER_BACKUPSET_27NOV08' keep forever logs;

    however i am getting this.
    RMAN-03002: failure of KEEP command at 11/28/2008 11:21:30
    RMAN-06530: CHANGE ... KEEP not supported for backup set which contains archive logs

    If i am to do a full backup up again without the 'PLUS archivelog'
    backup tag=MASTER_BACKUPSET_27NOV08 database spfile include current controlfile

    Will I be able to restore and recover the database back to original some point in the future using the that backup without the archivelogs around that time?

    I guess what I am trying to ******** is whether a FULL ONLINE RMAN backup is a consistant backup or not and can be be used with archivelogs available.

    Thanks in advance for your help..

  2. #2
    Join Date
    Oct 2006
    The database back up can be in inconsistent mode when you take an ONLINE back up. So you will obviously need archivelogs since last backup to restore to that point in time. Without archivelogs, you will get restored only to that point when the backup was taken.


  3. #3
    Join Date
    Jan 2001

    Can you let me know what happens when you do
    Whats your Oracle version

    backup database tag=MASTER_BACKUPSET_27NOV08 
    plus archivelog tag=MASTER_BACKUPSET_27NOV08

    change backup tag MASTER_BACKUPSET_27NOV08  keep forever

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.