Oracle-L: RE: How to automate RMAN- scripts?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Sun, 27 Apr 2003 13:56:36 -0800
Message-ID: <F001.0058A58F.20030427135636@fatcity.com>

Sami

I didn't find RMAN scripts particularly useful. I wound up just using some conventional Unix scripts executed by cron.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Saturday, April 26, 2003 5:32 AM
To: Multiple recipients of list ORACLE-L

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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 Sun Apr 27 2003 - 16:56:36 CDT