All,

I have configured 2 test servers to act as primary and secondary databases in a Data Guard environment.

Everything seemed to work fine till I issued :
ALTER DATABASE RECOVER managed standby database;
on the standby database. It takes a very long time to execute...

I have attached part of my alert log for u to assess
Here it is:
Thu Mar 18 17:22:42 2004
ALTER DATABASE RECOVER managed standby database
Media Recovery Start: Managed Standby Recovery
Starting datafile 1 recovery in thread 1 sequence 2
Datafile 1: '/oradata1/stby/prod/system/system01.dbf'
Starting datafile 2 recovery in thread 1 sequence 2
Datafile 2: '/oradata2/stby/prod/sfw_undo/sfw_undo_01.dbf'
Starting datafile 3 recovery in thread 1 sequence 2
Datafile 3: '/oradata1/stby/prod/sfw_data/assoc_data_01.dbf'
Starting datafile 4 recovery in thread 1 sequence 2
Datafile 4: '/oradata2/stby/prod/sfw_index/assoc_index_01.dbf'
Starting datafile 5 recovery in thread 1 sequence 2
Datafile 5: '/oradata1/stby/prod/sfw_data/attend_data_01.dbf'
Starting datafile 6 recovery in thread 1 sequence 2
Datafile 6: '/oradata2/stby/prod/sfw_index/attend_index_01.dbf'
Starting datafile 7 recovery in thread 1 sequence 2
Datafile 7: '/oradata1/stby/prod/sfw_data/hr_evnt_docs_data_01.dbf'
Starting datafile 8 recovery in thread 1 sequence 2
Datafile 8: '/oradata2/stby/prod/sfw_index/hr_evnt_docs_index_01.dbf'
Starting datafile 9 recovery in thread 1 sequence 2
Datafile 9: '/oradata2/stby/prod/sfw_index/indx01.dbf'
Starting datafile 10 recovery in thread 1 sequence 2
Datafile 10: '/oradata1/stby/prod/sfw_data/lt_tables_data_01.dbf'
Starting datafile 11 recovery in thread 1 sequence 2
Datafile 11: '/oradata2/stby/prod/sfw_index/lt_tables_index_01.dbf'
Starting datafile 12 recovery in thread 1 sequence 2
Datafile 12: '/oradata1/stby/prod/sfw_data/office_config_data_01.dbf'
Starting datafile 13 recovery in thread 1 sequence 2
Datafile 13: '/oradata2/stby/prod/sfw_index/office_config_index_01.dbf'
Starting datafile 14 recovery in thread 1 sequence 2
Datafile 14: '/oradata1/stby/prod/sfw_data/sched_config_data_01.dbf'
Starting datafile 15 recovery in thread 1 sequence 2
Datafile 15: '/oradata2/stby/prod/sfw_index/sched_config_index_01.dbf'
Starting datafile 16 recovery in thread 1 sequence 2
Datafile 16: '/oradata1/stby/prod/sfw_data/tools01.dbf'
Starting datafile 17 recovery in thread 1 sequence 2
Datafile 17: '/oradata1/stby/prod/sfw_data/users01.dbf'
Media Recovery Log
Media Recovery Waiting for thread 1 seq# 2

All datafiles have been recovered (17 in all). But the command has not been completed on the sql prompt. When I query the session, I see that it's ACTIVE.
Any suggestions, ideas, solutions.....???

Thanks in advance...
Regards,
Suhas