Home » Server Options » Data Guard » The Best form to make Backup DATA GUARD
icon5.gif  The Best form to make Backup DATA GUARD [message #263348] Wed, 29 August 2007 15:31 Go to next message
tony_pe
Messages: 17
Registered: August 2007
Junior Member
Hi,
It wanted to know, as it is the form to work the RMAN or import/export in data guard?

In where backup is take (in physical standby database or primary database or both)?.

It is necessary create catalog in RMAN?

As serious the recovery procedure (for example to recover tablespace)?

Regards.
Re: The Best form to make Backup DATA GUARD [message #263352 is a reply to message #263348] Wed, 29 August 2007 16:04 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
It wanted to know, as it is the form to work the RMAN or import/export in data guard?


Rman (HOT/COLD)

Quote:
In where backup is take (in physical standby database or primary database or both)?.



Where your backup is secure PRIMARY.

Quote:
It is necessary create catalog in RMAN?


No

Quote:

As serious the recovery procedure (for example to recover tablespace)?

Restore tablespace;
recover tablespace;
Re: The Best form to make Backup DATA GUARD [message #263353 is a reply to message #263352] Wed, 29 August 2007 16:38 Go to previous messageGo to next message
tony_pe
Messages: 17
Registered: August 2007
Junior Member
Hi, The documentation for oracle say:

Backing up standby files is often better than backing up the production files, for the
following reasons:
n Because the standby database is not the production database, a standby backup
does not interfere with transactions or batch jobs in the production database.
Hence, you can use the standby database as a backup host without interfering
with the production system.
n If the standby and primary databases are on separate hosts, then standby
backup operations do not consume CPU cycles, allocate memory, or consume
other resources on the production host.


Oracle9i - Recovery Manager User's Guide Release 2 (9.2)

Backup Physical Standby Database And you say primary, Why????
Re: The Best form to make Backup DATA GUARD [message #264725 is a reply to message #263348] Tue, 04 September 2007 06:16 Go to previous message
the_who
Messages: 5
Registered: December 2006
Location: Bandung
Junior Member
the reason that give the documentation is very good.
but that have procs and cons..
-procs:primary db recource not interfe with backup system running
-cons:you must always monitoring tranportable archivelog from primary to standby because if not your backup is just wasting time...and some change in primary db can't update standby..hmm.like creating datafile..(am i right?)

so i think DreamzZ answer is very good to apply for decreasing blunder in database

sory if my analysis wrong
i'm beginner with this ^^
Previous Topic: Getting error ORA-12154: TNS:could not resolve the connect identifier specified
Next Topic: Recover Database failure
Goto Forum:
  


Current Time: Thu Mar 28 11:46:14 CDT 2024