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 laterInformation 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:
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 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 |