Error on standby due to lack of space datafile has been created logically on standby with "UNNAMED",but physically file has not created:
---------------------------------------------------------------------------------------------------------------------
Errors in file /oracle/base/diag/rdbms/owsh120a/OWSH120A1/trace/OWSH120A1_pr00_29534.trc:
ORA-01111: name for data file 50 is unknown - rename to correct file
ORA-01110: data file 50: '/oracle/product/11204/db_8/dbs/UNNAMED00050'
STANDBY:
==========
SQL> select FILE#,NAME from v$datafile where FILE#=50;
FILE# NAME
---------- ------------------------------------------------------------
50 /oracle/product/11204/db_8/dbs/UNNAMED00050
SQL> show parameter standby_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string ?/dbs/arch
standby_file_management string AUTO
SQL> alter system set standby_file_management=manual;
System altered.
SQL> alter database create datafile '/oracle/product/11204/db_8/dbs/UNNAMED00050' as '/oracle/archivpool/OWSH120A_datafile/OWSH120A_gsms_central_dmnspc09.dbf';
Database altered.
SQL> alter system set standby_file_management=auto;
System altered.
SQL> select FILE#,NAME from v$datafile where FILE#=50;
FILE#
----------
NAME
--------------------------------------------------------------------------------
50 /oracle/archivpool/OWSH120A_datafile/OWSH120A_gsms_central_dmnspc09.dbf
=> Then start MRP process and check DG sync issue:
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#,BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
RFS IDLE 0 0 0 0
MRP0 APPLYING_LOG 1 120985 345 1048576
6 rows selected.
Standby archive seq:
Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
1 120984 120984 0
2 111745 111745 0
=> Then resize the datafile on primary to fit datafile in oradata.And then rename the datafile to orginal location in standby:
1.Cancel the mrp before rename:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
2.convert standby file management to Manual:
SQL> alter system set standby_file_management=manual;
System altered.
3.Move datafile to orginal location from archivepool:
orcldb@ah4hi044:~> mv /oracle/archivpool/OWSH120A_datafile/OWSH120A_gsms_central_dmnspc09.dbf /oracle/OWSH120A/oradata01/OWSH120A_gsms_central_dmnspc09.dbf
orcldb@ah4hi044:~> ll /oracle/OWSH120A/oradata01/OWSH120A_gsms_central_dmnspc09.dbf
-rw-r----- 1 orcldb oinstall 3221258240 Jul 20 03:41 /oracle/OWSH120A/oradata01/OWSH120A_gsms_central_dmnspc09.dbf
4.Then rename the datafile in standby database :
SQL> alter database rename file '/oracle/archivpool/OWSH120A_datafile/OWSH120A_gsms_central_dmnspc09.dbf' to '/oracle/OWSH120A/oradata01/OWSH120A_gsms_central_dmnspc09.dbf';
Database altered.
SQL> alter system set standby_file_management=auto;
System altered.
SQL> select FILE#,NAME from v$datafile where FILE#=50;
FILE# NAME
---------- ---------------------------------------------------------------------
50 /oracle/OWSH120A/oradata01/OWSH120A_gsms_central_dmnspc09.dbf