Data Guard Follow-up
- From: Scott Canaan <srcdco@xxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 03 Jun 2013 11:51:32 -0400
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@xxxxxxx<mailto:Scott.Canaan@xxxxxxx>)
(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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
