Erman Arslan's Oracle Forum - WARNING: The converted filename is an ASM fully qualified filename.

WARNING: The converted filename is an ASM fully qualified filename.

Posted by raiq1 on May 05, 2024; 9:22am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/WARNING-The-converted-filename-is-an-ASM-fully-qualified-filename-tp12462.html

Dear Erman sir,

We have need your support, We are resyncing our standby database from SCN based method , the reason behind the resync is archive files gap are huge so using SCN based method are easy to synchronized standby database.

All the production and standby database are in sync mode and there is no archive gap.

Today morning I have seen the standby alert log files are throwing the below messages.

2024-05-05T11:22:34.754547+03:00
*****************************************
WARNING: The converted filename '+DATA/prodcdb/tempfile/temp.897.1109638083'
is an ASM fully qualified filename.
Changing the filename to '+DATA/MUST_RENAME_THIS_TEMPFILE_1.4294967295.4294967295'.
Please rename it accordingly.
*****************************************
*****************************************
WARNING: The converted filename '+DATA/prodcdb/e3678777e9b64012e0530a6910ac751b/tempfile/temp.901.1109639 183'
is an ASM fully qualified filename.
Changing the filename to '+DATA/MUST_RENAME_THIS_TEMPFILE_2.4294967295.4294967295'.
Please rename it accordingly.
*****************************************
*****************************************
WARNING: The converted filename '+DATA/prodcdb/e36a7c4446b84d0be0530a6910ac23da/tempfile/temp2.313.110969 4783'
is an ASM fully qualified filename.
Changing the filename to '+DATA/MUST_RENAME_THIS_TEMPFILE_3.4294967295.4294967295'.
Please rename it accordingly.
*****************************************
*****************************************
WARNING: The converted filename '+DATA/prodcdb/e36a7c4446b84d0be0530a6910ac23da/tempfile/temp2.312.110969 4797'
is an ASM fully qualified filename.
Changing the filename to '+DATA/MUST_RENAME_THIS_TEMPFILE_4.4294967295.4294967295'.
Please rename it accordingly.

I have query v$tempfile in standby database. Total 12 tempfiles are having same name issues.

Need to fix it as per you recommendation.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
+DATA/MUST_RENAME_THIS_TEMPFILE_1.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_2.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_3.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_4.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_5.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_6.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_13.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_14.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_15.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_16.4294967295.4294967295
+DATA/MUST_RENAME_THIS_TEMPFILE_17.4294967295.4294967295

NAME
--------------------------------------------------------------------------------
+DATA/MUST_RENAME_THIS_TEMPFILE_18.4294967295.4294967295

12 rows selected.

Regards,
Raiq