Data Guard in Same Machine [message #495529] |
Sun, 20 February 2011 11:31 |
waseem62002
Messages: 4 Registered: July 2009 Location: Mumbai
|
Junior Member |
|
|
Hi Guys,
I am Doing Data Guard in single Machine please find step
Primary Database (chicago) ---- Standby database (boston)
1) shutdown immediate
2) startup mount
3) alter database archivelog
4) alter database force logging
5) alter database open
----------------------------------
The Archiving path D:\Archive
6) creata pfile='D:\test.ora' from spfile
Make the neccessary change
chicago.__db_cache_size=159383552
chicago.__java_pool_size=4194304
chicago.__large_pool_size=4194304
chicago.__shared_pool_size=113246208
chicago.__streams_pool_size=0
*.audit_file_dest='D:\oracle\product\10.2.0/admin/chicago/adump'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/chicago/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oracle\product\10.2.0\oradata\chicago\control01.ctl','D:\oracle\product\10.2.0\oradata\chicago\control02.ctl','D: \oracle\product\10.2.0\oradata\chicago\control03.ctl'
*.core_dump_dest='D:\oracle\product\10.2.0/admin/chicago/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='boston','chicago'
*.db_name='chicago'
*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='chicago'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=chicagoXDB)'
*.fal_client='chicago'
*.fal_server='boston'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'
*.log_archive_dest_1='location=D:\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=chicago'
*.LOG_ARCHIVE_DEST_2='SERVICE=boston LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_file_name_convert='D:\oracle\product\10.2.0\oradata\boston','D:\oracle\product\10.2.0\oradata\chicago'
*.open_cursors=300
*.pga_aggregate_target=95420416
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=287309824
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\product\10.2.0/admin/chicago/udump'
7) copy the passwordfile
shutdown immediate
9) copy the datafiles and redo log
10) oradim -new -sid boston -startmode manual
11) create pfile for boston and make neccessary changes
boston.__db_cache_size=180355072
boston.__java_pool_size=4194304
boston.__large_pool_size=4194304
boston.__shared_pool_size=92274688
boston.__streams_pool_size=0
*.audit_file_dest='D:\oracle\product\10.2.0/admin/boston/adump'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/boston/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oracle\product\10.2.0\oradata\boston\boston01.ctl'
*.core_dump_dest='D:\oracle\product\10.2.0/admin/boston/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='chicago'
*.db_unique_name='boston'
*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=chicagoXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=95420416
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=287309824
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\product\10.2.0/admin/boston/udump'
*.db_file_name_convert='chcago','boston'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'
*.log_archive_dest_1='location=D:\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=chicago'
*.LOG_ARCHIVE_DEST_2='SERVICE=boston LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_file_name_convert='D:\oracle\product\10.2.0\oradata\chicago','D:\oracle\product\10.2.0\oradata\boston'
*.fal_client='boston'
*.fal_server='chicago'
*.STANDBY_FILE_MANAGEMENT='AUTO'
12) now listener part
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = syedather.lan)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CHICAGO)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
)
)
13) TNS Names
CHICAGO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = syedather.lan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = chicago)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
BOSTON =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = syedather.lan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = boston)
)
)
14) Startup the primary Database
15) startup nomount (standby database)
16) alter database mount standby database
17) alter database recover managed disconnect from session
..... Now the problem i could able sync with primary Database
0ra-16004 backup database requires recover
Please guide me
|
|
|
|
Re: Data Guard in Same Machine [message #495532 is a reply to message #495529] |
Sun, 20 February 2011 12:35 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
How did you manage to do this
16) alter database mount standby database
17) alter database recover managed disconnect from session
if you never created a standby controlfile?
And your log_archive_dest_1/2 parameters for boston are wrong.
|
|
|