Home -> Mailing Lists -> Oracle-L -> RE: Data Guard Follow-up

RE: Data Guard Follow-up

From: Scott Canaan <srcdco_at_rit.edu>
Date: Mon, 03 Jun 2013 13:44:00 -0400
Message-id: <A9F069F06B325049A1D90D1F8EBEB8B6EEF6A145C1_at_ex02mail02.ad.rit.edu> 





I started with nothing and created the primary database from scratch  - LNX8TEST.  By default, it is not in archivelog mode and does not have a password file.
I created the empty directories for LNX9TEST, in another window.


- Created password file.



    
  
  •   changed remote_login_passwordfile=exclusive initLNX8TEST.ora file
  
  •   restared database
  
  •   turned on archiving
  
  •   alter database force logging;
  
  •   added 6 standby redo log groups
  
  •   added the following to the initLNX8TEST.ora file:
log_archive_config='DG_CONFIG=(LNX8TEST,LNX9TEST)'
log_archive_dest_1  'location=/oracle/data/LNX8TEST/arch
  valid_for=(all_logfiles,all_roles)
  db_unique_name=LNX8TEST'
log_archive_dest_2  'service=LNX9TEST LGWR SYNC
  valid_for=(online_logfiles,primary_role)
  db_unique_name=LNX9TEST'





log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=ENABLE
log_archive_max_processes 




db_unique_name='LNX8TEST'


fal_server=LNX9TEST


fal_client=LNX8TEST


standby_file_management=auto


log_file_name_convert='/oracle/data/LNX8TEST/','/oracle/data/LNX8TEST/','/oracle/data/LNX8TEST/mirror_files/','/oracle/data/LNX8TEST/mirror_files/'


- shutdown LNX8TEST



    
  
  •   startup nomount LNX8TEST
  
  •   create spfile from pfile;
  
  •   shutdown LNX8TEST
  
  •   startup mount LNX8TEST
  
  •   alter database create standby controlfile as '/oracle/data/LNX9TEST/control01.ctl';
  
  •   alter database open;
  
  •   in /oracle/data/LNX9TEST, copy control01.ctl to control02.ctl and mirror_files/control03.ctl
  
  •   copy /oracle/data/admin/LNX8TEST/pfile/orapwLNX8TEST to /oracle/data/admin/LNX9TEST/pfile/orapwLNX9TEST
  
  •   copy /oracle/data/admin/LNX8TEST/pfile/initLNX8TEST.ora to /oracle/data/admin/LNX9TEST/pfile/initLNX9TEST.ora
  
  •   change audit_file_dest, controlfiles, and diagnostic_dest to point to LNX9TEST
  
  •   Change above to:
log_archive_config='DG_CONFIG=(LNX8TEST,LNX9TEST)'
log_archive_dest_1   ='LOCATION=/oracle/data/admin/LNX9TEST/arch/ valid_for=(all_logfiles,all_roles) db_unique_name=LNX9TEST'
log_archive_dest_2='service=LNX8TEST LGWR SYNC valid_for=(online_logfiles,primary_role) db_unique_name=LNX8TEST'
log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=ENABLE
log_archive_max_processes 
db_unique_name='LNX9TEST'
fal_server=LNX8TEST
fal_client=LNX9TEST
standby_file_management=auto
log_file_name_convert='/oracle/data/LNX8TEST/','/oracle/data/LNX8TEST/','/oracle/data/LNX8TEST/mirror_files/','/oracle/data/LNX8TEST/mirror_files/'

  
  •   create links to /oracle/data/admin/LNX9TEST/initLNX9TEST.ora and orapwLNX9TEST in $ORACLE_HOME/dbs

  
  •   update /var/opt/oracle/oratab, adding an entry for LNX9TEST

  
  •   update /var/opt/oracle/tnsnames.ora, changing LNX8TEST to service_name (from SID), and adding an entry for LNX9TEST

  
  •   update /var/opt/oracle/listener.ora, adding an entry to LNX9TEST

  
  •   bounce the listener

  
  •   log out and back in on LNX9TEST to set the environment correctly

  
  •   shutdown LNX8TEST (primary)

  
  •   copy /oracle/data/LNX8TEST/*.dbf to /oracle/data/LNX9TEST

  
  •   copy /oracle/data/LNX8TEST/*.log to /oracle/data/LNX9TEST (redo and standby redo logs)

  
  •   copy /oracle/data/LNX8TEST/mirror_files/*.log to /oracle/data/LNX9TEST/mirror_files (redo and standby logs)

  
  •   copy /oracle/data/admin/LNX8TEST/arch/*.* to /oracle/data/admin/LNX9TEST/arch (existing archive log files)

  
  •   startup LNX8TEST (primary)

  
  •   startup nomount LNX9TEST (standby)

  
  •   create spfile from pfile (on LNX9TEST)

  
  •   shutdown LNX9TEST

  
  •   startup mount LNX9TEST

  
  •   on LNX9TEST - ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;






At this point, I checked the alert logs to see if there were any errors and noticed that both databases were trying to use the same set of physical files.



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.



From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
Sent: Monday, June 03, 2013 12:12 PM


To: Scott Canaan


Cc: oracle-l_at_freelists.org


Subject: Re: Data Guard Follow-up



Can you post what *you* have done.



By the way if you are trying to learn this I'd definitely recommend using a couple of vms



On Mon, Jun 3, 2013 at 4:51 PM, Scott Canaan <srcdco_at_rit.edu<mailto: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:srcdco_at_rit.edu><mailto:Scott.Canaan_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>>)
(585) 475-7886<tel:%28585%29%20475-7886> - work           (585) 339-8659<tel:%28585%29%20339-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




--
Niall Litchfield
Oracle DBA
http://www.orawin.info

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


Received on Mon Jun 03 2013 - 19:44:00 CEST












Original text of this message