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

Thread: RMAN full backup or full with level 0 backup ..?

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    RMAN full backup or full with level 0 backup ..?

    What is the query to be used in SQL PLUS to find out in RMAN, whether the databases configured for full backup or full backup with level 0 backup.

  2. #2
    Join Date
    Jul 2006
    Posts
    195
    I think your a bit confused. You don't configure your database for backup
    you specify how you want to back up your database.

    The first chunk of code is an exmaple of doing a full backup via rman and
    the second example is doing an incremental backup with rman.

    You can read the RMAN documentation to see what the differences are
    and how to setup a catalog to register your backup's if thats what you
    want.

    Good luck

    rman < connect target sys/sys@GOLD_PRI
    connect catalog rman/rman@GOLD_CAT

    CROSSCHECK BACKUP DEVICE TYPE DISK;
    CROSSCHECK ARCHIVELOG ALL;
    RUN {
    SQL 'ALTER SYSTEM SWITCH LOGFILE';
    BACKUP INCREMENTAL LEVEL 0
    FILESPERSET 2 DATABASE
    INCLUDE CURRENT CONTROLFILE
    PLUS ARCHIVELOG DELETE INPUT;
    }
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT OBSOLETE;

    EOF


    rman < connect target sys/sys@GOLD_PRI
    connect catalog rman/rman@GOLD_CAT

    CROSSCHECK BACKUP DEVICE TYPE DISK;
    CROSSCHECK ARCHIVELOG ALL;
    RUN {
    SQL 'ALTER SYSTEM SWITCH LOGFILE';
    BACKUP INCREMENTAL LEVEL 1
    FILESPERSET 2 DATABASE
    INCLUDE CURRENT CONTROLFILE
    PLUS ARCHIVELOG DELETE INPUT;
    }
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT OBSOLETE;

    EOF

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