Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change db_unique_name of standby

User447797-OCAug 31 2012 — edited Sep 2 2012

Oracle version : 11.2.0.2 RAC, Host os : RHEL 5.6

i need to change db_unique_name of my physical standy database.

1) How do i change it, what is the procedure for that?
2)with the change in db_unique_name, are datafiles, logfiles names are also changed? For example my curent datafile name is:
+data/EBSTST_STY/DATAFILE/USERS.382.789323897

If i change db_unique_name to EBSTST_SBY, does my datafile name also changes to
+data/EBSTST_SBY/DATAFILE/USERS.382.789323897

3) Do i need to perform ant fresn backup of my databse after changing db_unique_name of my physical standy database, if we are taking backups from standby instead of primary.

This post has been answered by CKPT on Sep 2 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2012

Added on Aug 31 2012

#data-guard, #performance-availability

4 comments

6,425 views