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

Thread: restore rman FULL backup without archivelogs.

  1. #1
    Join Date
    Nov 2008
    Posts
    3

    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
    Posts
    175
    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.

    Thanks
    gtcol

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

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

    Code:
    backup database tag=MASTER_BACKUPSET_27NOV08 
    plus archivelog tag=MASTER_BACKUPSET_27NOV08

    Code:
    change backup tag MASTER_BACKUPSET_27NOV08  keep forever
    regards
    Hrishy

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