Hi Ravindra,
I guess you can set "log_archive_dest_n" parameter dynamically by using "alter system" ,at least in 8.1.6.
Also, you need to add it also in the init.ora not to loose the parameter value in case of a restart.
HTH,
Jyoti
>From: "Ravindra Basavaraja"
>Reply-To: ORACLE-L@fatcity.com
>To: Multiple recipients of list ORACLE-L
>Subject: RE: rman/standby
>Date: Wed, 15 Aug 2001 14:43:53 -0800
>
>Larry,
>
>The parameter that you have mentioned should be added in the initialization
>file of
>the primary database and I need to restart the database for the new
>parameter to
>take affect.But I cannot do that as this is a production database and hence
>I had to
>configure the standby database in manual mode..
>
>thanks
>ravindra
>
>-----Original Message-----
>Sent: Wednesday, August 15, 2001 4:36 AM
>To: ravindra@sentica.com
>
>
>Assuming your standby database exists and is on-line (i.e. mounted but not
>open), you should be able to set up
>archive_log_dest2="service=your_SID_for_standby mandatory reopen=60" in the
>param file and Oracle will automatically copy the archive logs to the
>archive directory of the standby database.
>
>You can apply them later by putting the standby database into manual or
>automatic standby recovery mode.
>
>Then you can let RMAN delete them as usual (but you have to find some way
>to delete the archive logs where the standby is after you apply them).
>
>If your standby cannot be active, then you'll have to do some trickier work.
>
>larry
>
>At 05:41 PM 8/14/2001 -0800, you wrote:
> >I have configured a standby database operating in "manual mode" for our
> >production database.
> >I will have to apply the archive logs manually for the standby database.
> >
> >The Archive logs that are genarated on the production server is backed up
>by
> >RMAN/netbackup and deleted after the backup.I have the stopped the deletion
> >of archive files from the RMAN script.
> >
> >I want to find the best way of getting both RMAN/netbackup to happen and
> >also delete
> >the archive logs.But before they are deleted they need to be copied to a
> >seperate
> >directory so that I can apply those backed up files to the standby
> >database.I want to
> >make sure that I don't loose any of the archive files that the standby
> >database needs
> >to be in sync with the production database inclucing the current archive
> >logs that
> >may be backed up on the production database.
> >
> >The rman script is like this
> >run {
> >allocate channel t1 type 'SBT_TAPE';
> >backup
> > incremental level 1
> > tag Dialy_Incremental_Backup_Level1
> > filesperset 5
> > format 'Data_%d_%s_%p_%t'
> > (database);
> > sql 'alter system archive log current';
> >backup
> > filesperset 20
> > format 'Arch_%d_%s_%p_%t'
> ># (archivelog all delete input);
> > (archivelog all);
> >}
> >
> >How do I do it.?
> >
> >Thanks
> >Ravindra
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Ravindra Basavaraja
> > INET: ravindra@sentica.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).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ravindra Basavaraja
> INET: ravindra@sentica.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).
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jyoti N
INET: jnair75@hotmail.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).
Received on Thu Aug 16 2001 - 10:52:08 CDT
