Data Guard Follow-up

From: Scott Canaan <srcdco_at_rit.edu>
Date: Mon, 03 Jun 2013 11:51:32 -0400
Message-id: <A9F069F06B325049A1D90D1F8EBEB8B6EEF6A1457E_at_ex02mail02.ad.rit.edu>

I'm really getting confused on this data guard thing. I've followed several different people's steps and I cannot get it to work. This is the second time that I've ended up with the standby database trying to open the primary databases physical files (yes, they are on the same server, just so I can get the steps down). I don't understand why it is doing that. The two databases are LNX8TEST and LNX9TEST, with LNX8TEST being the primary. This is what I'm seeing in LNX9TEST: SQL> select * from v$dbfile;

     FILE#                NAME
----------  --------------------------------------------------------------------------------
         4                     /oracle/data/LNX8TEST/users01.dbf
         3                     /oracle/data/LNX8TEST/undotbs01.dbf
         2                     /oracle/data/LNX8TEST/sysaux01.dbf
         1                     /oracle/data/LNX8TEST/sys01.dbf

SQL> Then, in the alert log for LNX9TEST, I see the following errors:

Mon Jun 03 11:22:29 2013
Errors in file /oracle/data/admin/LNX9TEST/diag/rdbms/lnx9test/LNX9TEST/trace/LNX9TEST_dbw0_32404.trc:

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oracle/data/LNX8TEST/sys01.dbf'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8
Additional information: 32359
Errors in file /oracle/data/admin/LNX9TEST/diag/rdbms/lnx9test/LNX9TEST/trace/LNX9TEST_dbw0_32404.trc:

ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/oracle/data/LNX8TEST/sysaux01.dbf'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8
Additional information: 32359
Errors in file /oracle/data/admin/LNX9TEST/diag/rdbms/lnx9test/LNX9TEST/trace/LNX9TEST_dbw0_32404.trc:

ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/oracle/data/LNX8TEST/undotbs01.dbf'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8
Additional information: 32359
Errors in file /oracle/data/admin/LNX9TEST/diag/rdbms/lnx9test/LNX9TEST/trace/LNX9TEST_dbw0_32404.trc:

ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/oracle/data/LNX8TEST/users01.dbf'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8
Additional information: 32359
MRP0: Background Media Recovery terminated with error 1110 Errors in file /oracle/data/admin/LNX9TEST/diag/rdbms/lnx9test/LNX9TEST/trace/LNX9TEST_pr00_32544.trc:

ORA-01110: data file 1: '/oracle/data/LNX8TEST/sys01.dbf'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oracle/data/LNX8TEST/sys01.dbf'

Managed Standby Recovery not using Real Time Apply Slave exiting with ORA-1110 exception
Errors in file /oracle/data/admin/LNX9TEST/diag/rdbms/lnx9test/LNX9TEST/trace/LNX9TEST_pr00_32544.trc:

ORA-01110: data file 1: '/oracle/data/LNX8TEST/sys01.dbf'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oracle/data/LNX8TEST/sys01.dbf'

Recovery Slave PR00 previously exited with exception 1110 MRP0: Background Media Recovery process shutdown (LNX9TEST)

I've verified several times throughout the process that the environment is correct.

What is going on?

Scott Canaan '88 (srcdco_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>) (585) 475-7886 - work (585) 339-8659 - cell "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 03 2013 - 17:51:32 CEST