This content has been marked as final. Show 4 replies
i need to change db_unique_name of my physical standy database.
1) How do i change it, what is the procedure for that?DB_UNIQUE_NAME is Static parameter, Once you change in SPFILE. You have to bounce database.
2)with the change in db_unique_name, are datafiles, logfiles names are also changed? For example my curent datafile name is:No changes for the current files, Of course in future if you adding any datafiles the it will be created under New DB_UNIQUE_NAME, assuming you are using Oracle Managed Files.
If i change db_unique_name to EBSTST_SBY, does my datafile name also changes to
You can rename data files after performing image copy.
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.Do number of log switches, Once its completely synchronized then it sense that standby is functioning properly, Then take backup.