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.1Information in this document applies to any platform.
Symptoms
There are a lot of tasks with state "ORDERING_WAIT" .
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 :
$ 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 |