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

Thread: RMAN Scripting question

  1. #1
    Join Date
    Jan 2006
    Posts
    9

    RMAN Scripting question

    I run hotbackup daily via RMAN/Data Protector on 9i and 10g environments. I want to ensure that the RMAN script is written optimally so that it backups PFILE/SPFILE and all the archive logs. I want backup all the archive logs in /arch via RMAN and keep 3 days of archive logs and not delete them but back it up. will the following command work?
    [/CODE:]
    run {
    allocate channel 'dev_0' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
    allocate channel 'dev_1' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
    allocate channel 'dev_2' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
    allocate channel 'dev_3' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
    allocate channel 'dev_4' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
    backup incremental level filesperset 1
    format 'RMAN_ARGPRD01_Online.dbf'
    database
    include current controlfile
    include spfile
    ;
    backup filesperset 1
    format 'RMAN_ARGPRD01_Online.dbf'

    archivelog all delete input from 'sysdate - 3'
    --backup archivelog delete input from 'sysdate - 3'

    or
    archive log all delete archivelog until time='sysdate-3';
    [code:]
    thanks

  2. #2
    Join Date
    Jul 2002
    Posts
    335
    why don't you test it?

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