My Oracle Support Banner

ZDLRA|INDEX_BACKUP continuously with 'ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows' (Doc ID 2451402.1)

Last updated on NOVEMBER 03, 2019

Applies to:

Zero Data Loss Recovery Appliance Software - Version 12.1.0.1.0 to 12.1.1.1.8
Information in this document applies to any platform.

Symptoms

INDEX_BACKUP tasks are continuously failing with error : ORA-01422: exact fetch returns more than requested number of rows

261273555 5164 45231 22-02-2018 04:31:09
ORA-45168: unexpected scheduler exit while executing task ID 261272991 of type INDEX_BACKUP
ORA-19583: conversation terminated due to error
ORA-01422: exact fetch returns more than requested number of rows
ORA-45199: Error ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "RASYS.DBMS_RA_POOL", line 5125
ORA-06512: at line 1
encountered when executing begin dbms_ra_pool.begin_df(:vb_id, :ckpid, :db_id, :filno, :dfsize,:iscn, :dfscn, :dfstamp, :rstscn,
:rststamp, :df_key, :db_key, :dbinc_key, :unorderid, :first_blk, :last_blk); if :rstscn is null then select cmpvsn, reset_scn,
dbms_ra_misc.date2stamp(reset_time), create_scn, dbms_ra_misc.date2stamp(create_time) into :cmpvsn, :rstscn, :rststamp, :dfscn,
:dfstamp from vbdf v, dbinc i, df f where v.vb_key = :vb_id and v.df_key = :df_key and v.dbinc_key = i.dbinc_key and v.dbinc_key =
f.dbinc_key and v.df_key = f.df_key;else :cmpvsn := null; end if;begin select reset_scn, dbms_ra_misc.date2stamp(reset_time) into
:prstscn, :pstamp from dbinc where dbinc_key = (select parent_dbinc_key from dbinc where dbinc_key = :dbinc_key);exception when
no_data_found then :prstscn := 0; :pstamp := 0; end; end;.

 

 

Changes

On the protected database, there are datafiles which were plugged in in the past.

Verify by running the following query on protected database. A value of 1 indicates that the datafile was plugged in.

select file#,plugged_in from v$datafile;

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.