Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using a STANDBY database to perform backups using exp

Re: Using a STANDBY database to perform backups using exp

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 01 Jul 2005 21:18:13 +0800
Message-ID: <42C54295.62C2@yahoo.com>


steven_nospam_at_yahoo.ca wrote:
>
> Background:
> ===========
> We have an Oracle 8i site that has a replicated (standby) database
> using the RECOVER MANAGED STANDBY DATABASE command.
>
> We need to make a backup copy of the database into a different
> environment each month, and we do this by putting the primary database
> in READ-ONLY mode, then use the export with TRANSPORT_TABLESPACE=Y so
> we can copy the data from the production environment to the monthly
> reporting environment.
>
> Someone suggested to us that we should look into breaking replication
> and doing the export from the standby database instead of from the
> primary. That way the production database can continue to operate while
> the standby database gets backed up. once done, we would simply have to
> apply the archive logs using RECOVER STANDBY DATABASE AUTOMATIC and
> then restart the RECOVER MANAGED...
>
> My Question:
> ============
> Is this concept possible? I was under the impression that once you make
> the standby database into a primary, any changes would make the two
> copies incompatible. You would then have to restore the standby
> database from a fresh copy of the primary, applying any missing logs.
>
> If anyone has experience doing something similar in either the Ora8i or
> Ora9i product, would appreciate your insights on this. I'm more
> familiar with the Informix setup, which seems to offer more
> versatility.
>
> TIA
>
> Steve

A standby can be opened in read-only mode and thus not break its relationship with its primary

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
Received on Fri Jul 01 2005 - 08:18:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US