From japplewhite@inetprofit.com Wed, 21 Mar 2001 08:24:55 -0800
From: "Jack C. Applewhite" <japplewhite@inetprofit.com>
Date: Wed, 21 Mar 2001 08:24:55 -0800
Subject: RE: RMAN Backup and Recovery
Message-ID: <F001.002D3238.20010321072201@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain


Don,

You don't state whether or not you're getting the archived
redo logs at each Level 0 and 1 backup as well as the 3
archive-logs-only backups.  If not, you probably should.
Also, if recovery speed will be important, those incremental
backups should be cumulative, not differential.  However,
cumulative takes more storage than differential - always the
tradeoffs!

Jack

--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite@inetprofit.com


-----Original Message-----
Donald
Bricker
Sent: Tuesday, March 20, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L


We are in the midst of starting to use RMAN for our Backup
and Recovery. The backups I have put into place are Once a
week a Level 0 full backup, three times a week Level 1
incremental and three times archive logs only.
Can anyone suggest some different recovery scenarios to
test? Or if I missed any backups.

Thanks

Don Bricker
Information Systems Analyst
Illinois Environmental Protection Agency
1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
Donald.Bricker@epa.state.il.us
(217) 558-2290

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: japplewhite@inetprofit.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@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).


