No question at this time
DBA Top 10
1 M. Cadot 10900
2 B. Vroman 6700
3 A. Kavsek 5100
4 J. Schnackenberg 3200
5 P. Wisse 3100
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48581
Total active users1393
Act. users last 24h5
Act. users last hour0
Registered user hits last week165
Registered user hits last month388
Go up

A dataguard question
Next thread: Health Check script from Oracle : I got the solution for some errors and warnings
Prev thread: How do we know that an oracle component is in use ...

Message Score Author Date
Hi everyone, We are using dataguard on one o...... Joël Péran Feb 01, 2021, 11:15
Well ? No one has ever dealt with dataguard ? :) ...... Joël Péran Feb 25, 2021, 09:40

Follow up by mail Click here


Subject: A dataguard question
Author: Joël Péran, France
Date: Feb 01, 2021, 11:15, 28 days ago
Os info: Windows Server 2K16
Oracle info: Oracle 19.9
Message: Hi everyone,

We are using dataguard on one of our factories and I have migrated all the databases located on the test servers there. It is quite simple : stop the dataguard broker and the dataguard configuration, migrate the primary database in a classical way, restart the broker and the configuration and then the standby database got migrated via log shipping. Quite easy. But we don't have the license for active dataguard, so the standby must only be in mount mode and not opened. We used to use a hidden paramter (_query_on_physical = false) in order to prevent the database to open, and it worked ... but it is no more advised by the MOS support.
So easy question : in a windows environment, do you know some tricks (other than using a batch script) in order to start a database service and that the database is just mounted and not opened ? This will be used in case of server patching, when the server is restarted, databases are restarted as well but without the parameter, they are opened ...
I hope I was clear enough :)
Regards,
Joel
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: A dataguard question
Author: Joël Péran, France
Date: Feb 25, 2021, 09:40, 4 days ago
Message: Well ? No one has ever dealt with dataguard ? :)
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here