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

Thread: Rman

  1. #1
    Join Date
    Jan 2005
    Posts
    221

    Rman

    Below is what I have set in RMAN:

    RMAN> configure retention policy to recovery window of 7 days;
    RMAN> configure default device type to disk;
    RMAN> configure controlfile autobackup on;
    RMAN> configure snapshot controlfile name to 'e:\blah\scontrolf';
    RMAN> configure channel device type disk format 'e:\blah\%d_DB_%u_%s_%p';


    and perform the backup

    RMAN> run {
    2> backup database plus archivelog;
    3> delete noprompt obsolete;
    4> }


    below is the output of the backup result:

    Starting backup at 24-AUG-05
    current log archived
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting archive log backupset
    channel ORA_DISK_1: specifying archive log(s) in backup set
    input archive log thread=1 sequence=121 recid=23 stamp=567162488
    channel ORA_DISK_1: starting piece 1 at 24-AUG-05
    channel ORA_DISK_1: finished piece 1 at 24-AUG-05
    piece handle=d:\blah\RMANTEST_RMANTEST_10GSSDJP_32_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
    Finished backup at 24-AUG-05

    Starting Control File and SPFILE Autobackup at 24-AUG-05
    piece handle=C:\ORACLE\ORA920\DATABASE\C-3580521497-20050824-00 comment=NONE
    Finished Control File and SPFILE Autobackup at 24-AUG-05


    two questions:

    1. my archived logs is still on the server, I thought I tell RMAN to backup and delete them, what commmand can I use to delete archived after they are being backup.
    2. why control file and SPFILE go to the C drive, I thought I set it to e:\blah as well???

    thanks,

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    1) You need to add the DELETE [ALL] INPUT option to the backup command.

    2) Because controlfile "autobackup" does not specify any location.


    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jan 2005
    Posts
    221
    thanks,

    about the archived log:

    I thought I had

    RMAN> delete noprompt obsolete;


    and what is the differences between :

    RMAN> configure controlfile autobackup on;


    RMAN> configure snapshot controlfile name to 'e:\blah\scontrolf';

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    DELETE [ALL] INPUT is an option of the backup command and removes the archive logs which were backup.

    DELETE NOPROMPT OBSOLETE removes obsolete backupsets from the RMAN catalog.

    For controlfile you need to use: CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE ...option


    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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