From jbdonga@ucdavis.edu Fri, 06 Jul 2001 11:13:28 -0700 From: Janardhana Babu Date: Fri, 06 Jul 2001 11:13:28 -0700 Subject: RE: Standby Database & Replication Message-ID: MIME-Version: 1.0 Content-Type: text/plain   I  need to implement the standby database for the Txn. Proc. Prod. system. I have a few doubts. If the failure/disaster happens to prod DB, and can't open the DB, then How to transfer the contents of online logs to standby database? My logs would switch once every hour, and so, I would lose atleast one hour worth of data if I need to activate the standby database.  Is there any solution for this?   My second question would be: Temporary network failures are quite common here. We use Veritas Netbackup to backup using RMAN. Archived logs would be deleted after the backup as the archived logs quickly fill up the diskspace. How to keep atleast one copy of the archived logs on a seperate bigger disk permanently, atleast one week without being deleted by RMAN backup script.  I tried defining LOG_ARCHIVE_DEST_3 as optional location in init.ora. But these files are also being deleted by RMAN backup script along with Mandatory archived logs. We would like RMAN backup script to delete the Archived logs from Mandatory location after the backups are done, but at the same time retain the Optional location archived logs. Is there any way to do this? Restoring from tape would be time consuming and so looking for a solution to retain one copy of the Archived logs on disk.    My third question would be: Is anyone using Veritas Volume Replicator or similar product to recover the DB until the last transaction without production DB downtime, in case of disaster? Iam thinking of this product, but not sure this would solve the disaster Recovery problem until last transaction with no prod. down time.   Any help would be appreciated.   Thanks, -- Janardhana Babu   -----Original Message-----From: JOE TESTA [mailto:JTESTA@longaberger.com]Sent: Friday, July 06, 2001 9:46 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Standby Database Rich, no problems other than, the "performance" issue, if they are hitting it hard and oracle lags in trying to post the logs to the standby database.   other than that it should be fine.   Joe   >>> rhuntley@mindleaders.com 07/06/01 11:27AM >>>Just wondering if anyone sees any problems with creating a second instanceand DB on a standby database server that would be used for reportingquerying against a small dataset???  Running the standby DB in read onlymode is not an option since I'm applying archived logs every 10 minutes.  Ifanyone knows of any issues with doing this, could you please let me know.TIA,Richard Huntley-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard Huntley  INET: rhuntley@mindleaders.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).