Oracle Standby - UNNAMED Datafile

Olá, nesse artigo apresento os passos necessários para corrigir o problema de UNNAMED datafile no standby.

Causa

Parâmetro standby_file_management definido como MANUAL ao invés de AUTO e um novo datafile foi adicionado a uma tablespace existente ou devido a criação de uma nova tablespace (No primary database).

Abaixo o output do alert.log do banco com a mensagem referente ao erro de UNNAMED:

 
2024-03-12T11:05:30.035448+01:00
Recovery of Online Redo Log: Thread 1 Group 7 Seq 1215825 Reading mem 0
  Mem# 0: /oralog/DBAHERO/standby_redo07.log
2024-03-12T11:05:31.639977+01:00
ARC2 (PID:4840): Archived Log entry 33170 added for T-1.S-1215824 ID 0xffffffffa96ab200 LAD:1
2024-03-12T11:08:10.086155+01:00
(3):File #88 added to control file as 'UNNAMED00088' because
(3):the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
(3):The file should be manually created to continue.
PR00 (PID:5059): MRP0: Background Media Recovery terminated with error 1274
2024-03-12T11:08:10.134353+01:00
Errors in file /oracle/app/oracle/diag/rdbms/DBAHERO/DBAHERO/trace/DBAHERO_pr00_5059.trc:
ORA-01274: cannot add data file that was originally created as '/oradata/DBAHERO/DBAHERO/DBAHERO_DATA_01.dbf'
PR00 (PID:5059): Managed Standby Recovery not using Real Time Apply
2024-03-12T11:08:16.565202+01:00
Recovery interrupted!
Recovery stopped due to failure in applying recovery marker (opcode 17.30).
Datafiles are recovered to a consistent state at change 296568678262 but controlfile could be ahead of datafiles.
stopping change tracking
2024-03-12T11:08:16.959802+01:00
Errors in file /oracle/app/oracle/diag/rdbms/DBAHERO/DBAHERO/trace/DBAHERO_pr00_5059.trc:
ORA-01274: cannot add data file that was originally created as '/oradata/DBAHERO/DBAHERO/DBAHERO_DATA_01.dbf'
2024-03-12T11:08:16.961021+01:00
Background Media Recovery process shutdown (DBAHERO)

Segue abaixo os passos para correção:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

ALTER DATABASE CREATE DATAFILE '/oracle/app/oracle/ORA19c/dbs/UNNAMED00088' AS '/oradata/DBAHERO/DBAHERO/DBAHERO_DATA_01.dbf';

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

- Até a próxima.

Oracle Standby - UNNAMED Datafile

— Autor: Leonardo Lopes 12/03/2024 10H:56