RE: RMAN backup issue

From: Rama Malladi <rmalladi_at_inteliant.com>
Date: Wed, 1 Nov 2000 11:27:38 -0800
Message-Id: <10667.120846@fatcity.com>

Tom,
FYI.. I am posting both the Full as well as Level0 backup scripts that we have ... Still I am not sure if Level0 is same as Full or are they different.. After having a long meeting we all decided that to be on the safe side, it is good to have both on day1. Since then we do only Level1,2 during the week and Level0 once a week.

FULL

{
sql 'alter system enable restricted session'; execute script alloc_disk;
execute script defin_maxcorrupt_for_system; backup full
skip offline
skip readonly
skip inaccessible
tag Back_Fulldb_hsys
filesperset 5
format '/backup/oracle/arbor-106/Fulldb_arborora_%t_%s_%p.bs'
(database);

execute script rel_disk;
sql 'alter system switch logfile';
execute script arch_log_current;
allocate channel c1 type disk;
backup current controlfile format
'/backup/oracle/arbor-106/Control_arborora_%t_%s_%p.bs'; release channel c1;
sql 'alter system disable restricted session'; execute script back_all_alog;
}

Level0

{
sql 'alter system enable restricted session'; execute script alloc_disk;
execute script defin_maxcorrupt_for_system; backup
incremental level 0
skip offline
skip readonly
skip inaccessible
tag Back_Hsys_Incremental_0
filesperset 5
format '/backup/oracle/arbor-106/Level0_arborora_%t_%s_%p.bs'
(database);

execute script rel_disk;
sql 'alter system switch logfile';
execute script arch_log_current;
allocate channel c1 type disk;
backup current controlfile format
'/backup/oracle/arbor-106/Control_arborora_%t_%s_%p.bs'; release channel c1;
sql 'alter system disable restricted session'; execute script back_all_alog;
}

Rama Malladi, Sr. Oracle DBA
Oracle Certified Professional (8 and 8i) Inteliant Corp., California
RMALLADI_at_inteliant.com

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of blair_at_pjm.com
Sent: Wednesday, November 01, 2000 8:11 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup issue

RDBMS: 8.0.5 We are using RMAN to backup a critical production 600G database. We have a successful level-0 backup and do level-1 backups 3 times a week. To the best of
my knowledge we have never done a "Full Backup". Looking at the OEM Help on topic "Backup" it looks like I don't need to do a full backup if I do level-0
incrementals - but it is not clearly stated that way. Am I correct? Can we forego Full Backups if we do Level-0 backups?

..tom

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

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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

Received on Wed Nov 01 2000 - 13:27:38 CST