RE: Standby Database & Replication

From: Janardhana Babu <jbdonga_at_ucdavis.edu>
Date: Fri, 06 Jul 2001 11:13:28 -0700
Message-ID: <F001.00343513.20010706112054@fatcity.com>

 

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
 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: JOE TESTA   [mailto:JTESTA_at_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_at_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: <A
  href="http://www.orafaq.com">http://www.orafaq.com-- Author:   Richard Huntley  INET: rhuntley_at_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_at_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). Received on Fri Jul 06 2001 - 13:13:28 CDT