My Oracle Support Banner

Standby Database Report ORA-00059: maximum number of DB_FILES During Recovery (Doc ID 2653327.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

 

1. This is a dataguard environment. The database is a mutitenant database. It's designed to hold a great deal of pdbs. And drop/add pdbs is very frequent.

You can find many such informaiton in alert log like:

2019-11-19T02:29:36.735960+00:00
ALTER PLUGGABLE DATABASE <pdb name> CLOSE IMMEDIATE
2019-11-19T02:29:36.784171+00:00
<pdb name>(139):JIT: pid 36712 requesting stop
2019-11-19T02:29:52.998977+00:00
<pdb name>(139):detach called for domid 139 (domuid: 0x15bf922e, options: 0x0, pid: 36712)
<pdb name>(139):queued detach broadcast request 0x4477472b0
2019-11-19T02:29:55.192890+00:00
freeing rdom 139
2019-11-19T02:29:55.510807+00:00
Pluggable database <pdb name> closed
Completed: ALTER PLUGGABLE DATABASE <pdb name> CLOSE IMMEDIATE
DROP PLUGGABLE DATABASE <pdb name> INCLUDING DATAFILES
Deleted file /data/oradata/<pdb name>/DRIVE_VEHICLES.dbf
Deleted file /data/oradata/<pdb name>/DRIVE_STOCK.dbf
Deleted file /data/oradata/<pdb name>/DRIVE_MISC.dbf
Deleted file /data/oradata/<pdb name>/DRIVE_ACCOUNTS.dbf
Deleted file /data/oradata/<pdb name>/DRIVE_GLOBAL.dbf
Deleted file /data/oradata/<pdb name>/temp.tmp
Deleted file /data/oradata/<pdb name>/undotbs1.dbf
Deleted file /data/oradata/<pdb name>/sysaux.dbf
2019-11-19T02:29:56.513560+00:00
Deleted file /data/oradata/<pdb name>/system.dbf
Completed: DROP PLUGGABLE DATABASE <pdb name> INCLUDING DATAFILES
CREATE PLUGGABLE DATABASE <pdb name> FROM <old pdb name> FILE_NAME_CONVERT = ('<old pdb name>', '<pdb name>') STANDBYS=NONE
......
......

2. The DB_FILES is set to 5000 at standby and the total number of datafiles is no more than 2000, but the standby database report ORA-00059: maximum number of DB_FILES.

select count(*) from v$datafile;

COUNT(*)
----------
1530

Standby alert log:

Warning: Datafile 4997 (/data/oradata/<pdb name>/DRIVE_ACCOUNTS.dbf) is offline during full database recovery and will not be recovered
Warning: Datafile 4998 (/data/oradata/<pdb name>/DRIVE_MISC.dbf) is offline during full database recovery and will not be recovered
Warning: Datafile 4999 (/data/oradata/<pdb name>/DRIVE_STOCK.dbf) is offline during full database recovery and will not be recovered <<< file# 4999
2019-11-19T06:02:43.103969+00:00
Completed: alter database recover managed standby database using current logfile disconnect from session
2019-11-19T06:02:43.157776+00:00
Media Recovery Log +FRA/<CDB name>/ARCHIVELOG/2019_11_19/thread_1_seq_5773.2384.1024715735
DB027881(192):File copy for ts-SYSTEM skipped since source is in r/w mode
MRP0: Background Media Recovery terminated with error 59<<<<<< MRP failed.
2019-11-19T06:02:43.320499+00:00
Errors in file <trace file directory>/<instance name>_pr00_77255.trc:
ORA-00059: maximum number of DB_FILES exceeded <<<<<< ORA-00059 reported.

 

Changes

 The primary database DB_FILES has been changed to 6000 recently:

Starting ORACLE instance (normal) (OS id: 119317)
.....
db_files = 6000
......

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.