How to automate RMAN- scripts?

From: <Saminathan_Seerangan_at_i2.com>
Date: Sat, 26 Apr 2003 02:31:38 -0800
Message-ID: <F001.0058A1E8.20030426023138@fatcity.com>

Dear ALL,

I would like to know how to automate by RMAN back scripts. If DBMS_JOB is the only way then, could someone please provide me one example? I want to run my o817ut01_level0 script on every sunday and rest of the days i want to run o817ut01_level1.

create script o817ut01_level0{

        ALLOCATE CHANNEL disk1  TYPE DISK;
        ALLOCATE CHANNEL disk2  TYPE DISK;
        ALLOCATE CHANNEL disk3  TYPE DISK;
        ALLOCATE CHANNEL disk4  TYPE DISK;
        backup incremental level 0 format 

'$ORACLE_HOME/backup/o817ut01_backup%s_%p' (database include current controlfile);

        sql 'ALTER SYSTEM ARCHIVE LOG ALL';
        backup archivelog all;

}

create script o817ut01_level1{

        ALLOCATE CHANNEL disk1  TYPE DISK;
        ALLOCATE CHANNEL disk2  TYPE DISK;
        ALLOCATE CHANNEL disk3  TYPE DISK;
        ALLOCATE CHANNEL disk4  TYPE DISK;
        backup incremental level 1 format 

'$ORACLE_HOME/backup/o817ut01_backup%s_%p' (database include current controlfile);

        sql 'ALTER SYSTEM ARCHIVE LOG ALL';
        backup archivelog all;

}

Any help would be really appreciated.
Thanks
Sami

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Saminathan_Seerangan_at_i2.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Apr 26 2003 - 05:31:38 CDT