RE: rman/standby

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_at_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_at_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_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ravindra Basavaraja
  INET: ravindra_at_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_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).