Primary
Server :-
|
|
Hostname |
db_Uniq_name |
SID |
Tnsnames |
Service_name |
|
Primary |
bcibms55 |
XPROD |
XPROD |
XPROD |
XPROD |
|
Standby |
bcibmp15 |
XPRODDR |
XPROD |
XPRODDR |
XPROD |
|
|
Primary
Database
|
Physical
Standby
|
|
Oracle Net Service
name
|
XPROD |
XPRODDR |
|
SID |
XPROD |
XPROD |
|
DB_UNIQUE_NAME |
XPROD |
XPRODDR |
Primary Database IFile Detail :-
#### Entry for Data Guard FROM CHAIN.SYS
####
db_unique_name = XPROD
log_archive_dest_1 =
'LOCATION=/xprodarch/xprodarch/XPROD/archive'
log_archive_dest_2='service=XPRODDR
valid_for=(online_logfiles,primary_role) db_unique_name=XPRODDR LGWR
ASYNC=20480 OPTIONAL REOPEN=15 NET_TIMEOUT=30'
log_archive_dest_state_1=enable
#log_archive_dest_state_2 = defer
log_archive_dest_state_2 = enable
log_archive_min_succeed_dest = 1
standby_file_management = AUTO
#remote_archive_enable = TRUE
Remote_login_passwordfile = exclusive
log_archive_format = XPROD_%t_%s_%r.arch
db_file_name_convert =
'/xproddata1/xproddata1/XPROD/data/','/xproddata1/xproddata1/XPROD/data/','/xproddata2/xproddata2/XPROD/data/','/xproddata2/xproddata2
/XPROD/data/','/xproddata3/xproddata3/XPROD/data/','/xproddata3/xproddata3/XPROD/data/'
log_file_name_convert =
'/xprodarch/xprodarch/XPROD/archive/','/xprodarch/xprodarch/XPROD/archive/'
fal_server = XPRODDR
fal_client = XPROD
Add tnsnames.ora to Primary server for
Standby:-
XPRODDR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
bcibms15.hilbcdom.com)(PORT = 1571))
)
(CONNECT_DATA =
(SERVICE_NAME = XPROD)
)
)
xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0)#
sqlplus
SQL*Plus: Release 11.1.0.7.0 - Production on
Thu Jul 26 18:39:32 2012
Copyright (c) 1982, 2008, Oracle. All rights
reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2155464 bytes
Variable Size 452987960 bytes
Database Buffers 1660944384 bytes
Redo Buffers 21798912 bytes
SQL> alter database mount;
Database altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination
/xprodarch/xprodarch/XPROD/archive
Oldest online log sequence 75
Current log sequence 77
SQL> alter database archivelog;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination
/xprodarch/xprodarch/XPROD/archive
Oldest online log sequence 75
Next log sequence to archive 77
Current log sequence 77
SQL> alter database open;
Database altered.
SQL> ALTER DATABASE FORCE LOGGING;
Database altered.
SQL> show parameter db_name;
NAME TYPE
VALUE
------------------------------------
----------- ------------------------------
db_name string
XPROD
SQL> show parameter db_unique_name;
NAME TYPE
VALUE
------------------------------------
----------- ------------------------------
db_unique_name string
XPROD
SQL>exit
xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0/dbs)#
orapwd file=orapwXPROD password=sys entries=20 force=y ignorecase=y
xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0/dbs)#
sqlplus “/as sysdba”
Create Log files for Standby:-
SQL> alter database add standby logfile
group 4 '/xproddata1/xproddata1/XPROD/data/log04a.dbf' size 500M;
No comments:
Post a Comment