Database Administration (MOSC)

MOSC Banner

How to convert unused physical standby to normal database?

edited Aug 27, 2015 10:52AM in Database Administration (MOSC) 3 commentsAnswered

We have two physical standby databases. One of them are shutdown for long time. I want to reopen it as a normal database because it has data already.

And I want to change the database name and db_id as well.

It looks like the nid (DBNEWID) does not work on standby database. I have to convert it normal database first.

I already remove this standby database from DGMGRL.

I already changed all parameters that relates to data guard on this database and restart mount.

startup mount

alter system reset log_archive_config scope=spfile;

alter system reset fal_server scope=spfile;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center