My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2019

Applies to:

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

Symptoms

There are a lot of tasks with state "ORDERING_WAIT" .

 

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

 

In order to analyze the backups taken for the protected database, you can get the following information via RMAN connected to the Protected Database and the Recovery Catalog   :

 

$ 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".

 

Changes

 none

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.