RMAN Table PITR Failing with ORA-03113 RMAN-05122 and ORA-07445: [kprbprs()] (Doc ID 2873093.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

 1. RMAN TABLE Recovery script,

run
{
set auxiliary instance parameter file to '/<location>/init_pitr.ora';
RECOVER TABLE <user_name>.EDGE_EDM_SUPPLEMENTAL_LOG OF PLUGGABLE DATABASE <> until time "to_date('04/29/2022 01:00:00','mm/dd/yyyy hh24:mi:ss')"
AUXILIARY DESTINATION '<destination location>'
datapump destination '/oracleexabkp/<>_AUXIL_EXP/'
dump file 'export_ldtable.dmp'
notableimport;
}

2. RMAN Table Recovery Failing with

Removing automatic instance
shutting down automatic instance
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/06/2022 06:47:40
RMAN-06136: Oracle error from auxiliary database: ORA-03114: not connected to ORACLE
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 05/06/2022 06:47:40
RMAN-11003: failure during parse/execution of SQL statement: alter pluggable database <> open
ORA - 03113: end-of-file on communication channel
Process ID: 32564
Session ID: 245 Serial number: 11564
RMAN-05122: there is insufficient disk space to perform this table recovery
RMAN-05122: there is insufficient disk space to perform this table recovery

3. AUX instance Alert log,

2022-05-06T06:38:56.469762-04:00
Undo initialization recovery: err:0 start: 2252788262 end: 2252788331 diff: 69 ms (0.1 seconds) <<< Error while creating UNDO
Undo initialization finished serial:0 start:2252788262 end:2252788332 diff:70 ms (0.1 seconds)
Dictionary check beginning
File #7 is offline, but is part of an online tablespace.
data file 7: '+DATAC1/<>/DATAFILE/users.1693.1022533259'
Dictionary check complete
Verifying minimum file header compatibility for tablespace encryption for pdb 1..
Verifying file header compatibility for tablespace encryption completed for pdb 1
Database Characterset is UTF8

.....................
<>(3):Opening pdb with Resource Manager plan: OSUSER_V_PLAN
<>(3):joxcsys_required_dirobj_exists: directory object exists with required path /u02/app/oracle/product/18.0.0.0/dbhome_3/javavm/admin/, pid 32564 cid 3
2022-05-06T06:40:58.418627-04:00
<>(3):Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x454E494CEE] [PC:0x3762D3E, kprbprs()+62] [flags: 0x0, count: 1]
Errors in file /u02/app/oracle/diag/rdbms/gbmg_pitr_<>_cpes/<>/trace/gBmg_ora_32564.trc (incident=3689) (PDBNAME=<>):
ORA-07445: exception encountered: core dump [kprbprs()+62] [SIGSEGV] [ADDR:0x454E494CEE] [PC:0x3762D3E] [Address not mapped to object] []
<>(3):Incident details in: /u02/app/oracle/diag/rdbms/gbmg_pitr_<>_cpes/<>/incident/incdir_3689/<>_ora_32564_i3689.trc
<>(3):Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2022-05-06T06:40:59.770835-04:00

__sighandler() call sslsshandler() 000000000 7FBB981DB4B0
7FBB981DB380 00000000C ?
7FBB981DA908 ? 000000083 ?
kprbprs()+62 signal __sighandler() 454E494C4E 000000000
7FFFB7515D90 000000465 ?
000000000 ? 000000002 ?
kpdbri_uts_create() call kprbprs() 454E494C4E ? 000000000 ?
+1108 7FFFB7515D90 ? 000000465 ?
000000000 ? 000000002 ?
kpdbrf_rsrc_replica call kpdbri_uts_create() 3533343320455A49 000000000 ?
te()+1073 7FFFB7515D90 ? 000000465 ?
000000000 ? 000000002 ?
kpdbaCreateLocalUnd call kpdbrf_rsrc_replica 000000003 000000000 00A9E4320
oTs()+520 te() 000000465 ? 000000000 ?
000000002 ?
kpdbaSwitchOpenClos call kpdbaCreateLocalUnd 000000003 ? 000000000 ?
e()+30660 oTs() 7FBB9CE9FBE8 000000000
000000000 ? 000000002 ?
kpdbSwitchRunAsSysC call kpdbaSwitchOpenClos 7FFFB7518510 7FFFB751C16C
bk()+25 e() 000000001 004000000 100000000
000000002 ?
rpiswu2()+583 call kpdbSwitchRunAsSysC 7FFFB75182F8 ? 7FFFB751C16C ?
bk() 000000001 ? 004000000 ?
100000000 ? 000000002 ?
kpdbSwitch()+3601 call rpiswu2() 7FFFB75182F8 ? 7FFFB751C16C ?
000000001 ? 004000000 ?
7FFFB75183F8 ? 000000002 ?
kpdbaOpenPdb()+204 call kpdbSwitch() 7FFFB75182F8 ? 7FFFB751C16C ?
000000001 ? 00A9B1670
7FFFB7518510 000000002 ?
kpdbaOpenClose()+50 call kpdbaOpenPdb() 000000003 2EF824E80 3CEBDDB88
32 000000001 004000000
7FFFB751C16C

Cause

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