Ashoke
If I understand you correctly, you are using RMAN to backup to disk,
rather than to a media manager. You are asking whether you can archive these
in RMAN, plus leave them on disk so they are readily available for recovery.
I have used this configuration, and I have found that RMAN leaves
the archive logs on disk after it has backed them up. Also, I believe but
have not tested this, that in case of a recovery, RMAN first looks to the
original unarchived disk location for the archive logs and if it can't find
them there, it will retrieve them from its backup location (disk file or
tape if you are using a media manager), and put them where they should be,
then continue the recovery.
After thinking about this, I decided that using RMAN to backup the
archive logs wasn't buying me anything. Just making my setup more
complicated. If I was backing up to a media manager, then having RMAN back
up the archive logs would be great because it would be moving them to tape.
As it is, RMAN isn't compressing them before moving them to disk. My regular
nightly tape backup will give me a safety copy on tape. If I feel I need a
disk copy, I will just compress the files to another location and end up
with something significantly smaller. If I have overlooked something in my
logic, please point that out to me because I am just beginning to learn RMAN
and am frequently interrupted by other DBA duties, so learning is going very
slowly.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, February 21, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
Greetings,
We are at Oracle 8.1.7 on Sun Solaris 7.
Can we backup all the archive logs at any point of time but not deleting all
these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1)
in the disk so that we don't need to restore the archive logs from rman
backup in case of some recovery up to point within last 2 days.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandal, Ashoke
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
