2. Is the listener working and up?
SELECT DEST_ID, STATUS, ERROR FROM V$ARCHIVE_DEST;
3. Is the FRA on the Standby full?
SQL> connect sys/<password>@standbytnsname as sysdba;
4. Is MRP up on Standby?
select * from v$flash_recovery_area_usage;
Finally please check both Primary and Standby alert logs and post all these results.
select process,status from v$managed_standby;
I don't see yours this is key. Please confirm.
SQL> select process,status from v$managed_standby; PROCESS STATUS --------- ------------ ARCH CLOSING ARCH CONNECTED ARCH CLOSING ARCH CLOSING ARCH CLOSING ARCH CLOSING ARCH CLOSING ARCH CLOSING MRP0 WAIT_FOR_LOG RFS IDLE RFS IDLE PROCESS STATUS --------- ------------ RFS IDLE RFS IDLE RFS IDLE RFS IDLE RFS IDLE RFS IDLE 17 rows selected.
Not worth a look
ALTER DATABASE REGISTER OR REPLACE LOGFILE '/u01/app/oracle/oradata/STANDBY/archive/PRIMARY_1_21_716110538.arc';
Media Recovery Log /u03/oradata/ccnbdr/archive/standbyccnbdr_1_585260.arcIt looks like you have cancelled the MRP on the standby database, opened the standby database in read only mode. I am completely unaware of the database version you are using as you have not mentioned it.
Thu Nov 15 08:41:43 2012
Media Recovery Waiting for thread 1 seq# 585261
Thu Nov 15 08:59:40 2012
alter database recover managed standby database cancel
Thu Nov 15 08:59:43 2012
MRP0: Background Media Recovery user canceled with status 16037
MRP0: Background Media Recovery process shutdown
Thu Nov 15 08:59:45 2012
Managed Standby Recovery Cancelled
Completed: alter database recover managed standby database ca
Thu Nov 15 08:59:46 2012
alter database open read only
select process,status,sequence# from v$managed_standby;