No question at this time
DBA Top 10
1 B. Vroman 15300
2 M. Cadot 12400
3 J. Schnackenberg 7400
4 T. Boles 6950
5 A. Kavsek 6900
6 M. Hidayathullah ... 3300
7 T. P 1300
8 G. Lambregts 1100
8 P. Wisse 1100
10 B. Derous 500
10 R. Wauben 500
10 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48245
Total active users1631
Act. users last 24h3
Act. users last hour0
Registered user hits last week190
Registered user hits last month742
Go up

Is there any way to check if a controlfile is a standby controlfile or current pre-startup?
Next thread: IMPDP excluding table
Prev thread: Single Instance Primary to 2 node RAC Standby

Message Score Author Date
Hi, Is there any way to check if a controlfile ...... BenBart BartBen May 23, 2018, 18:30

Follow up by mail Click here


Subject: Is there any way to check if a controlfile is a standby controlfile or current pre-startup?
Author: BenBart BartBen, Philippines
Date: May 23, 2018, 18:30, 88 days ago
Os info: Linux+Solaris
Oracle info: Oracle11
Message: Hi,

Is there any way to check if a controlfile is a standby controlfile or not pre-startup?

Reason I am asking is when starting a database, the startup defaults to Active DataGuard which requires a license. So we are hoping to include a pre-check of some sort to check whether a controlfile is a standby and then do startup mount instead if it is.

At the moment, the workaround is we do startup mount by default, query controlfile_type from v$database and then from there do alter database open or do nothing.

Anyone have a better idea :-)

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here