| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN Best Practices and Configuration Guide
This link may be useful:
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=131865.1&blackframe=0
Jared
Pat Howe <phowe_at_Illuminet.com>
Sent by: root_at_fatcity.com
01/22/02 08:10 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RMAN Best Practices and Configuration Guide
If anyone knows of an "RMAN Best Practices and/or Configuration" document
I
would be interested in seeing it.
I am about to set up RMAN within our division and would be interested to
know how others have configured RMAN at their shop.
I know from experience that after I have implemented something for the
first
time - I look back and think how I "should have" implemented it.
Thus I am trying to get some of this knowledge from those of you who have
already been down this road. You can only get so much from reading
manuals
- experience is the true teacher.
Here are some guidelines that I have gleaned from my research so far. Let me know what you think of them and add to them :
Always use a separate database for your RMAN catalog.
In the RMAN catalog have one schema owner per database that you are
backing
up. If you had two databases "PROD and DEV" then setup a RMAN-PROD and an
RMAN-DEV schema owner in the RMAN catalog to manage each database's
recovery
info. This will help you cleanup the RMAN catalog if you ever drop
database
DEV.
I am leaning toward implementing my backups using 'backup sets' - I can
not
see the advantage of 'image copies' if you are properly backing up the
RMAN
catalog (required for recovery).
If you plan on routing your backups directly to tape - Set up your scripts
and test your scripts by going to Disk first. ie; Don't bite off to much
at
a time.
I would be interested in seeing how others have configured their sites :
ie; Do you have a good TAG naming scheme ? ie; How frequently do you Resync the RMAN Catalog ? ie; Backup schedule : Level 0 on Sunday - Level 2 on Mon/Tue/Thur/Fri/Sat
Thanks in advance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pat Howe
INET: phowe_at_Illuminet.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Tue Jan 22 2002 - 13:24:43 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |