Re: Data Guard Follow-up

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Mon, 3 Jun 2013 21:47:57 +0530
Message-ID: <CAABGLuJf84Xf9JM5odkO00T7zai32_G5DGw1zfBnmyLRSwGuEA_at_mail.gmail.com>



Scott,
When you have both databases in same server, Have you copied the LNX8TEST datafiles to the use of LNX9TEST datafiles? What is the datafile location for LNX8TEST and LNX9TEST?

Because from the LNX9TEST datafiles when you query "v$dbfile" you can see the datafiles locations which is pointing to still "/oracle/data/*LNX8TEST*/users01.dbf"
LNX8TEST database files.

Also the errors are clear, These files already using by LNX8TEST again the database LNX9TEST trying to use the same file, which is already enqueue on the datafiles.

Here have you performed renaming of datafiles after you perform copy/refresh? such as
*SQL> alter database rename file '/oracle/data/LNX8TEST/users01.dbf' to '/oracle/data/LNX9TEST/users01.dbf'*
>
> So review above my comments and check these changes you have not performed
yet.

Thanks & Regards,
Nassyam Basha.
www.oracle-ckpt.com

On Mon, Jun 3, 2013 at 9:21 PM, Scott Canaan <srcdco_at_rit.edu> wrote:

> 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
>
>
>

-- 
Thanks & Regards,
Nassyam Basha.


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 03 2013 - 18:17:57 CEST

Original text of this message