Database Administration (MOSC)

MOSC Banner

After standby controlfile has lost, how do I know how to rename these ASM files

Hi


Oracle 19c RAC with standby present.


Let's say, I have a situation where standby database controlfile will become corrupted/lost etc.

According to this Doc ID 459411.1, I should create standby controlfile from primary, by running:

SQL> alter database create standby controlfile as '<File-Specification>';


Then move this file to standby server, copy this to ASM file structure.

Then by starting standby database in mount state, I get these errors in alert log for all the files:

WARNING: The converted filename '+DATA/aet_stdby/datafile/system.6596.1004049307'

     is an ASM fully qualified filename.

     Changing the filename to '+DATA/MUST_RENAME_THIS_DATAFILE_1.4294967295.4294967295'.

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