ORA-01516: nonexistent log file, data file, or temporary file container in stand by Database:
=============================================================================================
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file “+ORA_DATA/MUST_RENAME_THIS_DATAFILE_76.4294967295.4294967295” in the current container
How to Fix the issue:
=====================
in standby server:
—————–
SQL>STARTUP NOMOUNT;
SQL>ALTER DATABASE MOUNT STANDBY DATABASE;
rman target /
run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
allocate channel c6 device type disk;
allocate channel c7 device type disk;
allocate channel c8 device type disk;
set newname for datafile 76 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.1628.1072720843’;
set newname for datafile 77 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.351.1077203993’;
set newname for datafile 78 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/mp_data1.350.1077501521’;
set newname for datafile 79 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/mp_data1.349.1077501525’;
set newname for datafile 80 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.348.1077501623’;
set newname for datafile 81 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.347.1077501627’;
set newname for datafile 82 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.346.1077537165’;
set newname for datafile 83 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.345.1077539971’;
set newname for datafile 84 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_index1.344.1077539987’;
set newname for datafile 85 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.343.1077551673’;
set newname for datafile 86 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_index1.342.1077568513’;
set newname for datafile 87 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.341.1077568571’;
set newname for datafile 88 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_data1.340.1077581871’;
set newname for datafile 89 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/mp_data1.339.1077599323’;
set newname for datafile 91 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/mp_data1.337.1077726573’;
set newname for datafile 92 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/mp_data1.336.1077726863’;
set newname for datafile 93 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/mp_data1.335.1077779387’;
set newname for datafile 94 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/mp_index1.334.1077779487’;
set newname for datafile 95 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_index1.333.1077792255’;
set newname for datafile 96 to ‘+ORA_DATA/STANDBY_SERVER01/DATAFILE/adata_index1.332.1078170569’;
restore database from service PRODSERVER01 using compressed backupset;
switch datafile all;
recover database from service PRODSERVER01 using compressed backupset;
}
