Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I followed the steps in oracle documentation on creation of a physical standby database.

The link to the configuration steps,

When I perform "Step 4 Verfiy that received redo has been applied." my query result is not as expected, following is the result,



    5 NO
    6 NO
    7 NO
    8 NO

4 rows selected.

Appreciate any advice on how to proceed, thanks.

share|improve this question
need a bit more detail - anything in the alert.log? are the files present on the standby box? (i.e. have they been successfully copied off the primary)? are there any architecture differences between the two boxes? (64 vs 32 bit)? – Mark Regensberg Mar 22 '10 at 9:19
Where to look for the alert log? Yes the files should be present on the standby box as I verified with the command prior to Step 4, ie. "Step 3 Verify the new redo data was archived on the standby database." and the result was as expected. Both boxes are the exact same architecture. – Arthur Aoife Mar 22 '10 at 9:58
if you haven't specified a location, it will be in $ORACLE_HOME/RDBMS/trace, alternatively run - select value from v$parameter where name = 'background_dump_dest'; and this will give you the location. – Mark Regensberg Mar 22 '10 at 13:00


alter database recover managed standby database nodelay disconnect from session;

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.