Home » Server Options » Data Guard » data guard configuration on windows (10g, 10.2.0.5, windows 2008 )
data guard configuration on windows [message #630220] Tue, 23 December 2014 04:08 Go to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
kindly post me the link for the step by step procedure to configure standby database

I have followed so many links but still so much confuse in creating stndby redologs,first will be creating stdbyREDO04.log,stdbyREDO05.log,stdbyREDO06.log,in primary and later on we copy the dbf files and control files,onlinelog files redolog files to standby server.

do we need to create stdbyREDO.logs file in standby database as well?

please send the exact steps for dataguard configuration on windows
Re: data guard configuration on windows [message #630221 is a reply to message #630220] Tue, 23 December 2014 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is the same on all platform.

Re: data guard configuration on windows [message #630222 is a reply to message #630220] Tue, 23 December 2014 04:41 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
What links have you been following? Which part of the instructions did you have trouble with?
As for step-by-step inastructions, those in the docs http://docs.oracle.com/cd/B19306_01/server.102/b14239/toc.htm are pretty clear.
Re: data guard configuration on windows [message #630226 is a reply to message #630220] Tue, 23 December 2014 05:40 Go to previous messageGo to next message
pvsarat
Messages: 10
Registered: October 2012
Location: CHENNAI
Junior Member
Yes you need to create in standby as well
Re: data guard configuration on windows [message #630321 is a reply to message #630226] Wed, 24 December 2014 07:22 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
kindly check the alert_stdby.log file

ed Dec 24 15:32:43 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
processes = 150
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\STDBY\STDBY.CTL
db_file_name_convert = ora, stdby
log_file_name_convert = C:\oracle\product\10.2.0\oradata\ora, C:\oracle\product\10.2.0\oradata\stdby
db_block_size = 8192
compatible = 10.2.0.3.0
log_archive_config = DG_CONFIG=(ora,stdby)
log_archive_dest_1 = LOCATION=c:\oracle\product\10.2.0\ARCHIVE VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stdby
log_archive_dest_2 = SERVICE=ora LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_max_processes= 30
log_archive_format = %t_%s_%r.arc
fal_client = stdby
fal_server = ora
db_file_multiblock_read_count= 16
standby_file_management = AUTO
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=stdbyXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\STDBY\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\STDBY\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\STDBY\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\STDBY\CDUMP
db_name = ora
db_unique_name = stdby
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=4948
PSP0 started with pid=3, OS id=4668
MMAN started with pid=4, OS id=836
DBW0 started with pid=5, OS id=5276
LGWR started with pid=6, OS id=4392
CKPT started with pid=7, OS id=5492
SMON started with pid=8, OS id=3332
RECO started with pid=9, OS id=4404
CJQ0 started with pid=10, OS id=4864
MMON started with pid=11, OS id=4896
Wed Dec 24 15:32:43 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1700
Wed Dec 24 15:32:43 2014
starting up 1 shared server(s) ...
Wed Dec 24 15:33:35 2014
Shutting down instance: further logons disabled
Wed Dec 24 15:33:35 2014
Stopping background process CJQ0
Wed Dec 24 15:33:36 2014
Stopping background process MMNL
Wed Dec 24 15:33:37 2014
Stopping background process MMON
Wed Dec 24 15:33:38 2014
Shutting down instance (immediate)
License high water mark = 1
Wed Dec 24 15:33:38 2014
Stopping Job queue slave processes
Wed Dec 24 15:33:38 2014
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Wed Dec 24 15:33:39 2014
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Dec 24 15:33:55 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
processes = 150
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\STDBY\STDBY.CTL
db_file_name_convert = ora, stdby
log_file_name_convert = C:\oracle\product\10.2.0\oradata\ora, C:\oracle\product\10.2.0\oradata\stdby
db_block_size = 8192
compatible = 10.2.0.3.0
log_archive_config = DG_CONFIG=(ora,stdby)
log_archive_dest_1 = LOCATION=c:\oracle\product\10.2.0\ARCHIVE VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stdby
log_archive_dest_2 = SERVICE=ora LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_max_processes= 30
log_archive_format = %t_%s_%r.arc
fal_client = stdby
fal_server = ora
db_file_multiblock_read_count= 16
standby_file_management = AUTO
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=stdbyXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\STDBY\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\STDBY\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\STDBY\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\STDBY\CDUMP
db_name = ora
db_unique_name = stdby
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3520
PSP0 started with pid=3, OS id=5672
MMAN started with pid=4, OS id=2084
DBW0 started with pid=5, OS id=4540
LGWR started with pid=6, OS id=1596
CKPT started with pid=7, OS id=4064
SMON started with pid=8, OS id=1812
RECO started with pid=9, OS id=2556
CJQ0 started with pid=10, OS id=1676
MMON started with pid=11, OS id=220
Wed Dec 24 15:33:55 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2016
Wed Dec 24 15:33:55 2014
starting up 1 shared server(s) ...
Wed Dec 24 15:33:56 2014
ALTER DATABASE MOUNT
Wed Dec 24 15:34:00 2014
Setting recovery target incarnation to 2
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=4088
ARC1 started with pid=17, OS id=5400
ARC2 started with pid=18, OS id=316
ARC3 started with pid=19, OS id=5356
ARC4 started with pid=20, OS id=2772
ARC5 started with pid=21, OS id=1228
ARC6 started with pid=22, OS id=2628
ARC7 started with pid=23, OS id=5796
ARC8 started with pid=24, OS id=5256
ARC9 started with pid=25, OS id=3720
ARCa started with pid=26, OS id=5232
ARCb started with pid=27, OS id=336
ARCc started with pid=28, OS id=1984
ARCd started with pid=29, OS id=4744
ARCe started with pid=30, OS id=4024
ARCf started with pid=31, OS id=3932
ARCg started with pid=32, OS id=4576
ARCh started with pid=33, OS id=1032
ARCi started with pid=34, OS id=5700
ARCj started with pid=35, OS id=5976
ARCk started with pid=36, OS id=4256
ARCl started with pid=37, OS id=3652
ARCm started with pid=38, OS id=4084
ARCn started with pid=39, OS id=1404
ARCo started with pid=40, OS id=4588
ARCp started with pid=41, OS id=4116
ARCq started with pid=42, OS id=3924
ARCr started with pid=43, OS id=5828
ARCs started with pid=44, OS id=2920
Wed Dec 24 15:34:00 2014
ARC0: Archival started
Wed Dec 24 15:34:00 2014
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARCj: Archival started
ARCk: Archival started
ARCl: Archival started
ARCm: Archival started
ARCn: Archival started
ARCo: Archival started
ARCp: Archival started
ARCq: Archival started
ARCr: Archival started
ARCs: Archival started
ARCt: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Dec 24 15:34:00 2014
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Thread not mounted
Wed Dec 24 15:34:00 2014
Successful mount of redo thread 1, with mount id 1485359012
Wed Dec 24 15:34:00 2014
Physical Standby Database mounted.
ARCt started with pid=45, OS id=5644
Wed Dec 24 15:34:02 2014
ARC1: Becoming the heartbeat ARCH
Completed: ALTER DATABASE MOUNT
Wed Dec 24 15:36:16 2014
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
MRP0 started with pid=46, OS id=4736
Managed Standby Recovery not using Real Time Apply
Wed Dec 24 15:36:21 2014
Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby_dbw0_4540.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\SYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Wed Dec 24 15:36:21 2014
Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby_dbw0_4540.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\UNDOTBS01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Wed Dec 24 15:36:21 2014
Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby_dbw0_4540.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\SYSAUX01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Wed Dec 24 15:36:21 2014
Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby_dbw0_4540.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\USERS01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

MRP0: Background Media Recovery terminated with error 1110
Wed Dec 24 15:36:21 2014
Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby_mrp0_4736.trc:
ORA-01110: data file 1: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\SYSTEM01.DBF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\SYSTEM01.DBF'

Wed Dec 24 15:36:21 2014
Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby_mrp0_4736.trc:
ORA-01110: data file 1: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\SYSTEM01.DBF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\SYSTEM01.DBF'


Re: data guard configuration on windows [message #630322 is a reply to message #630321] Wed, 24 December 2014 07:23 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
kindly check the pfile of standby

stdby.__db_cache_size=427819008
stdby.__java_pool_size=4194304
stdby.__large_pool_size=4194304
stdby.__shared_pool_size=167772160
stdby.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0\admin\STDBY\adump'
*.background_dump_dest='C:\oracle\product\10.2.0\admin\STDBY\bdump'
*.compatible='10.2.0.3.0'
*.control_files='C:\oracle\product\10.2.0\oradata\stdby\stdby.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0\admin\STDBY\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.DB_FILE_NAME_CONVERT='ora','stdby'
*.DB_NAME='ora'
*.DB_UNIQUE_NAME='stdby'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=stdbyXDB)'
*.FAL_CLIENT='stdby'
*.FAL_SERVER='ora'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(ora,stdby)'
*.LOG_ARCHIVE_DEST_1='LOCATION=c:\oracle\product\10.2.0\ARCHIVE VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stdby'
*.LOG_ARCHIVE_DEST_2='SERVICE=ora LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.LOG_FILE_NAME_CONVERT='C:\oracle\product\10.2.0\oradata\ora','C:\oracle\product\10.2.0\oradata\stdby'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0\admin\stdby\udump'
Re: data guard configuration on windows [message #630323 is a reply to message #630322] Wed, 24 December 2014 07:26 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
when iam checking the query on standby database

SQL> select sequence#, first_time, next_time,applied from v$archived_log order b
y sequence#;

SEQUENCE# FIRST_TIM NEXT_TIME APP
---------- --------- --------- ---
4 24-DEC-14 24-DEC-14 NO
5 24-DEC-14 24-DEC-14 NO
6 24-DEC-14 24-DEC-14 NO
7 24-DEC-14 24-DEC-14 NO
8 24-DEC-14 24-DEC-14 NO
9 24-DEC-14 24-DEC-14 NO
10 24-DEC-14 24-DEC-14 NO

7 rows selected.

the applied status is NO

the statsu has to be yes,how could i solve this issue...
Re: data guard configuration on windows [message #630325 is a reply to message #630323] Wed, 24 December 2014 07:27 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
please check the p file of primary

ora.__db_cache_size=415236096
ora.__java_pool_size=16777216
ora.__large_pool_size=4194304
ora.__shared_pool_size=167772160
ora.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0\admin\ora\adump'
*.background_dump_dest='C:\oracle\product\10.2.0\admin\ora\bdump'
*.compatible='10.2.0.3.0'
*.control_files='C:\oracle\product\10.2.0\oradata\ora\control01.ctl','C:\oracle\product\10.2.0\oradata\ora\control02.ctl','C:\oracle\ product\10.2.0\oradata\ora\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0\admin\ora\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ora'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oraXDB)'
*.job_queue_processes=10
*.local_listener='LISTENER_ORA'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0\admin\ora\udump'
############Added by NDS
DB_NAME=ora
DB_UNIQUE_NAME=ora
LOG_ARCHIVE_CONFIG='DG_CONFIG=(ora,stdby)'
LOG_ARCHIVE_DEST_1='LOCATION=c:\oracle\product\10.2.0\ARCHIVE VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora'
LOG_ARCHIVE_DEST_2='SERVICE=stdby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stdby'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
DB_FILE_NAME_CONVERT='stdby','ora'
LOG_FILE_NAME_CONVERT='C:\oracle\product\10.2.0\oradata\stdby','C:\oracle\product\10.2.0\oradata\ora'
STANDBY_FILE_MANAGEMENT=AUTO
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=stdby
FAL_CLIENT=orcl



Re: data guard configuration on windows [message #630326 is a reply to message #630325] Wed, 24 December 2014 07:46 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
SQL> select sequence#, first_time, next_time, archived, applied from v$archived_log order by sequenc
e#;

SEQUENCE# FIRST_TIM NEXT_TIME ARC APP
---------- --------- --------- --- ---
4 24-DEC-14 24-DEC-14 YES NO
4 24-DEC-14 24-DEC-14 YES NO
5 24-DEC-14 24-DEC-14 YES NO
5 24-DEC-14 24-DEC-14 YES NO
6 24-DEC-14 24-DEC-14 YES NO
6 24-DEC-14 24-DEC-14 YES NO
7 24-DEC-14 24-DEC-14 YES NO
7 24-DEC-14 24-DEC-14 YES NO
8 24-DEC-14 24-DEC-14 YES NO
8 24-DEC-14 24-DEC-14 YES NO
9 24-DEC-14 24-DEC-14 YES NO

SEQUENCE# FIRST_TIM NEXT_TIME ARC APP
---------- --------- --------- --- ---
9 24-DEC-14 24-DEC-14 YES NO
10 24-DEC-14 24-DEC-14 YES NO
10 24-DEC-14 24-DEC-14 YES NO

14 rows selected.
Re: data guard configuration on windows [message #630329 is a reply to message #630326] Wed, 24 December 2014 08:20 Go to previous message
BlackSwan
Messages: 25715
Registered: January 2009
Location: SoCal
Senior Member
below seems problematic to me

ORA-01110: data file 1: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\SYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Wed Dec 24 15:36:21 2014
Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby_dbw0_4540.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'C:\STDBYCLE\PRODUCT\10.2.0\STDBYDATA\STDBY\UNDOTBS01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
Previous Topic: Data Guard Broker warning
Next Topic: Data Guard in 10 minutes: demo today
Goto Forum:
  


Current Time: Sat Nov 18 07:59:59 CST 2017

Total time taken to generate the page: 0.01975 seconds