Re: Re:Setting the archive destination

Lisa,
The log_archive_dest parameter is not modifyable without bouncing the instance. You will lose your connection to rman when you do this. What about doing an archivelog backup and use the delete option. This will but the files in your backup destination and get them out of your archive log destination. We do an archive log backup with each full and incremental backup we do. Then we put the whole mess on tape. It is one more step to restore the archive logs when you do a restore/recovery but it sure helps because we never fill up our archivelog destination.

HTH,
Ruth
----- Original Message -----
From: <Lisa_Koivu_at_gelco.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 14, 2000 4:33 PM
Subject: Re:Setting the archive destination

> Will doing this possibly mess with a currently running RMAN job?
> This happens so frequently I could scream: My arc destination fills up
and I
> have to manually fiddle with the backups, and move files not included in
the
> current backup elsewhere until the current backup completes. Then I move
the
> arclogs back to the arc dest and start another backup. Would issuing this
> command at the command line confuse the currently running RMAN job?
>
> I'm dealing with this right now. Once I get out of this mess I will try
it out.
>
> Thanks in advance for any suggestions
> Lisa
>
>
>
>
>
> dgoulet_at_vicr.com on 06/14/2000 10:55:32 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Lisa Koivu/GELCO)
>
>
>
>
> alter system archivelog start to <wherever>
>
> ____________________Reply Separator____________________
> Author: Linda Hagedorn <Linda_at_pets.com>
> Date: 6/13/00 1:13 PM
>
> Hello,
>
> Is there a way to set the archive destination on a system which is
running,
> or will I have to change the config file and shutdown/startup the
database?
>
> Thanks, Linda
>
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.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
> also send the HELP command for other information (like subscribing).
> --
> Author:
> INET: dgoulet_at_vicr.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
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.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 Thu Jun 15 2000 - 07:21:37 CDT