 The Best form to make Backup DATA GUARD [message #263348] |
Wed, 29 August 2007 15:31  |
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  |
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 |
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 |
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 ^^
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
