|
Home > Archive > Oracle Server > May 2005 > How to make Standby DB to be consistent with Primary db again?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to make Standby DB to be consistent with Primary db again?
|
|
| yoke wang 2005-05-25, 3:23 am |
| Hi,
Platform:Linux AS3,Oracle9i(9204),S
tandby Arch Mode.
The Standby DB was not consistent with Primary. And some of the
necessary archivelogs are missing on Primary db.
How to make Standby DB to be consistent with Primary one again in
this case?
The Primary DB must be online any way.
I have thought of rebuilding the standby db from scratch(using
rman),but it will take long time.
Any suggestions will be very appreciated.
wy.
| |
| Sybrand Bakker 2005-05-25, 3:23 am |
| On 24 May 2005 21:10:50 -0700, cnwy@263.net (yoke wang) wrote:
>Hi,
> Platform:Linux AS3,Oracle9i(9204),S
tandby Arch Mode.
> The Standby DB was not consistent with Primary. And some of the
>necessary archivelogs are missing on Primary db.
> How to make Standby DB to be consistent with Primary one again in
>this case?
> The Primary DB must be online any way.
> I have thought of rebuilding the standby db from scratch(using
>rman),but it will take long time.
>
> Any suggestions will be very appreciated.
>
>
>wy.
As you are missing archivelogs on the primary, rebuilding using rman
or any other hot backup mechanism is the only option you have.
--
Sybrand Bakker, Senior Oracle DBA
| |
| yoke wang 2005-05-26, 3:23 am |
| > As you are missing archivelogs on the primary, rebuilding using rman
> or any other hot backup mechanism is the only option you have.
You mean I can do hot backup for each tablespace and copy the datafile to standby?
Alter tablespace xxx begin backup;
cp xx.dbf to standby
Alter tablespace xxx end backup;
Is that all I must do?
wy.
| |
| Sybrand Bakker 2005-05-26, 3:23 am |
| On 25 May 2005 19:55:12 -0700, cnwy@263.net (yoke wang) wrote:
> You mean I can do hot backup for each tablespace and copy the datafile to standby?
> Alter tablespace xxx begin backup;
> cp xx.dbf to standby
> Alter tablespace xxx end backup;
> Is that all I must do?
>
>wy.
No.
You'll need to make a hot backup of your complete primary database,
and create a *new* standby database from that hot backup!
--
Sybrand Bakker, Senior Oracle DBA
| |
|
|
|
|
|