There are Tasks with State ' "ORDERING_WAIT" in the Recovery Appliance (Doc ID 2096221.1)

The following queries can be executed in the recovery catalog appliance to analyze the issue :

SQL> connect rasys/<password>

 

1. Identify what protected databases has tasks with the same state ("ORDERING_WAIT" ):

SQL> select task_id, ospid, task_type, state,creation_time, completion_time, db_unique_name
from ra_task
ra_task where state= ORDERING_WAIT'order by creation_time;

2. Identify the db_key of protected database :

SQL> select db_key, db_unique_name
from ra_database
where db_unique_name='protected_db_name_in_uppercase';

Note: Replace "protected_db_name_in_uppercase" for the name of the protected database reporting the error.

3. Verify what errors are being reported by the protected database :

SQL> select task_id, status, inst_id, error_text, error_num
from error_log
where db_key=<db_key_protected_db>;

Note: Replace "db_key_protected_db" for the value getting in Step 2.

If the following error is reported, then, this means that no level 0 backup has been taken for the protected database to the Recovery Appliance (RA) :

     "ORA-64737: unable to copy a full backup for database <db_unique_name> because of missing data files "

4. To get  the output of the script provided  in 2095949.1

$ export NLS_DATE_FORMAT='dd-mon-yyyy hh24:mi:ss'


$ rman target sys/password@net_service_target  catalog rasys_user/password@<ALIAS>

RMAN> list backup summary;
RMAN> list backup;


Note: You should see level 0 backup taken to "SBT_TAPE".