|
|
[ÀϹÝ] ¾ÆÄ«ÀÌºê ¹æ½ÄÀÇ ¹é¾÷¼¹ö ±¸Ãà standby |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 220.¢½.198.178 |
ÀÐÀ½:3297 |
|
|
# ¾ÆÄ«ÀÌºê ¸ðµå·Î ¹é¾÷¼¹ö·Î Àû¿ëÇÏ´Â ¸í·É
SQL> startup nomount
SQL> alter database mount standby database;
SQL> recover managed standby database disconnect;
# ¾ÆÄ«ÀÌºê ¹é¾÷¼¹ö·Î Àü¼ÛµÈ ÆÄÀÏÀ» ¼öµ¿À¸·Î Àû¿ëÇÏ´Â ¸í·É
SQL> startup nomount;
SQL> recover standby database;
>>>>>>>>>>>>>>>>>>>>>>>>>
¿À¶óŬ ÆĶó¹ÌÅÍ ¹é¾÷¼¹ö initOOO.ora file
###############################################
# DATA GUARD CONFIGURATION#
###############################################
#******************
# Primary Role
#******************
#log_archive_dest_state_2=ENABLE # primary DBÀÏ °æ¿ì
#*******************
# Standby Role
#*******************
log_archive_dest_state_2=DEFER # standby DBÀÏ °æ¿ì
#*******************
# Common
#*******************
log_archive_format='_%S.arc'
*.log_archive_start=true
log_archive_dest_1='location=/data2/ARCH/arch'
log_archive_dest_2='SERVICE=dreeeem LGWR SYNC AFFIRM reopen=120'
log_archive_dest_state_1=ENABLE
remote_archive_enable=TRUE
*.log_archive_format='_%S.arc'
*.log_archive_start=true
standby_archive_dest=/data2/ARCH/arch
db_file_name_convert=("/data1/oradata/ORA9/DAT","/data2/oradata/ORA9/DAT")
log_file_name_convert=("/home/app/oracle/oradata/ORA9","/data2/oradata/ORA9/SYSTEM")
DG_BROKER_START=TRUE
service_names='ORAQQ'
log_archive_trace=0
fal_server=dreeeem
fal_client=stby
remote_archive_enable=true
#standby_file_management=auto
|
|
|
220.¢½.198.178
|
|
|
08-11-12 14:31
|
121.¢½.39.7
|
|
|
08-12-03 09:14
|
121.¢½.39.7
|
|
|
09-06-15 13:00
|
|