Errors while standby_file_management = manual in standby DB

When we forget to set auto file creation in the standby , by default the creation is manual “standby_file_management = manual”, so as consequence,

Note: In my case the standby is a RAC 2 nodes 19c (Patch 18).

Error:

PRCR-1079 : Failed to start resource ora.oranux.db
CRS-5017: The resource action "ora.oranux.db start" encountered the following error:
ORA-10458: standby database requires recovery
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01111: name for data file 8 is unknown - rename to correct file
ORA-01110: data file 8: '/u01/app/oracle/product/19c/dbhome_1/dbs/UNNAMED00008'
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/rac1/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.oranux.db' on 'rac1' failed
CRS-2632: There are no more servers to try to place resource 'ora.oranux.db' on that would satisfy its placement policy
CRS-5017: The resource action "ora.oranux.db start" encountered the following error:
ORA-10458: standby database requires recovery
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01111: name for data file 8 is unknown - rename to correct file
ORA-01110: data file 8: '/u01/app/oracle/product/19c/dbhome_1/dbs/UNNAMED00008'
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/rac2/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.oranux.db' on 'rac2' failed

Solution:

Step 1: Disable replication if not disactivated:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active

Step 2: Make sure the “standby_file_management = manual

SQL> alter system set standby_file_management = manual;

Step 3: Create the file

SQL> alter database create datafile '/u01/app/oracle/product/19c/dbhome_1/dbs/UNNAMED00008' as '+DATA' size 100M;

Step 4: Change standby file creation to auto

SQL> alter system set standby_file_management = auto;

Step 5: Enable replication:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT  NODELAY;

Enjoy!

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply