|
|
[ÀϹÝ] Standby Database ±¸Ãà[ GOOD GOOD ] |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 121.¢½.39.7 |
ÀÐÀ½:1640 |
|
|
Standby Database ±¸Ãà [DB] ¿À¶óŬ 2008/01/03 14:45
http://blog.naver.com/zoom7810/50026288980
1. Standby DataBase ÀåÁ¡
µ¥ÀÌÅͺ£À̽º Àå¾Ö½Ã ¹Ì¸® ¹é¾÷ ¹Þ¾ÆµÐ datafile °ú archivelog ¸¦ ¸ðµÎ restore ÇÏ¿© º¹±¸ÇÏ°Ô µÇ´Âµ¥ ÀÌ°æ¿ì º¹±¸ ½Ã°£ÀÌ ±æ¾î Àå¾Ö½Ã°£ÀÌ ±æ¾îÁö°Ô µÈ´Ù.
ÀÌ·²°æ¿ì¸¦ ´ëºñÇÏ¿© ¹Ì¸® Standby Database ¸¦ ±¸¼ºÇÏ¿© Standby Database¿¡ Recovery¸¦ ÁøÇàÇØ
µÎ°í Primary Database Àå¾Ö ½Ã ¹Ù·Î Standby Database¸¦ Active ½ÃÅ°¸é Down TimeÀ» ÃÖ¼ÒÈ
ÇÒ ¼ö ÀÖ´Ù.
2. Standby DataBase ±¸ÃàÀýÂ÷
Standby DB ±¸¼ºÀ» À§ÇØ Primary DB¿ÍÀÇ datafile, archivelog µîÀÇ sequence# ¸¦ µ¿±âÈ ½ÃÄÑ¾ß Çϱ⠶§¹®¿¡ ÀýÂ÷»ó ¼ø¼°¡ ¸Å¿ì Áß¿äÇÏ´Ù
0) Standby DB°¡ ±¸¼ºµÉ ½Ã½ºÅÛ¿¡ Oracle À» Primary DB¿Í µ¿ÀÏÇÑ version À¸·Î install ÇÑ´Ù
@ Primary DB path = /dbms/oracle/oradata/ORA
@ Standby DB path = /backup/dbms/oracle/oradata/ORA
----------------------------------------------------------------------------
Primary DB
----------------------------------------------------------------------------
1) Primary DB°¡ OpenµÇ¾î ÀÖ´Â »óÅ¿¡¼ Standby DB¿ë Control fileÀ» »ý¼ºÇÏ°í À̸¦
Standby DB¿¡ Control file ·Î º¹»ç
SQL> alter database create standby controlfile as '/dbms/oracle/oradata/ORA/stby01.ctl';
SQL> alter database create standby controlfile as '/dbms/oracle/oradata/ORA/stby02.ctl';
SQL> alter database create standby controlfile as '/dbms/oracle/oradata/ORA/stby03.ctl';
2) Primary DBÀÇ Ãʱâ Datafile À» Standby DB·Î º¹»ç
[¹æ¹ý1] dbf ÆÄÀÏÀ» ftp ·Î Àü¼Û
[¹æ¹ý2] ¿À¶óŬ DRD ÃʱâÈ
A. ÃʱâÈ ´ë»ó DRD Á¶È¸
SQL> select tablespace_name, file_name, bytes/1024/1024 mega from
dba_data_files;
TABLESPACE_NAME FILE_NAME MEGA
-------------------- ---------------------------------------- ---------
USERS /dbms/oracle/oradata/ORA/users01.dbf 5
SYSAUX /dbms/oracle/oradata/ORA/sysaux01.dbf 310
UNDOTBS1 /dbms/oracle/oradata/ORA/undotbs01.dbf 35
SYSTEM /dbms/oracle/oradata/ORA/system01.dbf 490
EXAMPLE /dbms/oracle/oradata/ORA/example01.dbf 100
# mkdir dr_copy
SQL> alter tablespace users begin backup;
SQL> !cp /dbms/oracle/oradata/ORA/users01.dbf /dbms/oracle/oradata/ORA/dr_copy
SQL> alter tablespace users end backup;
µîµîµî....
ÅÆÇÁÆÄÀÏÀº ±×³É º¹»çÇÑ´Ù.
SQL> select name, bytes/1024/1024 mega from v$tempfile;
NAME MEGA
---------------------------------------- --------- /dbms/oracle/oradata/ORA/temp01.dbf 20
dr_copy¸¦ ¾ÐÃàÀ¸·Î ¹¾î¼ dr ÀÇ ../oradata/ORA/ ¹Ø¿¡ Ç®¾î³õ´Â´Ù
3) Primary DBÀÇ Archivelog ÆÄÀÏÀ» Standby DB·Î º¹»ç
----------------------------------------------------------------------------
Standby DB
----------------------------------------------------------------------------
4) ÀνºÅϽº¸¦ nomount ¸ðµå·Î ±¸µ¿ÇÑ´Ù
SQL> startup nomount
5) °æ¿ì¿¡ µû¶ó ÃʱâÈ ÆÄÀÏÀ» È®ÀÎÇÑ´Ù
¾î¶² ÃʱâÈ ÆÄÀÏÀ» ¹°°í ¿Ã¶ó°¡´ÂÁö È®ÀÎÇÏ·Á¸é
/dbms/oracle/product/10.2.0/Db_1/dbs °æ·Î¿¡ spfileORA.ora ÆÄÀÏÀÌ ÀÖÀ¸¸é spfile ¸ðµåÀÌ°í,
¾øÀ¸¸é pfile ¸ðµå
[ pfile ÀÎ °æ¿ì ]
è initORA.ora ÆÄÀÏÀ» »ý¼ºÇÑ´Ù.
è standby ±¸¼º ½Ã ÃʱâÈ ÆÄÀÏ(initORA.ora)À» Á÷Á¢ ¼öÁ¤ÇÑ´Ù
DR½Ã½ºÅÛÀÇ /dbms/oracle/product/10.2.0/Db_1/admin/ORA/pfile °æ·Î¿¡ »ý¼ºµÈ init.ora.xxxx
ÆÄÀÏÀ» /dbms/oracle/product/10.2.0/Db_1/dbs °æ·Î¿¡ ÆÄÀÏ À̸§À» º¯°æÇÏ¿© º¹»çÇÑ´Ù.
# mv ./init.ora.xxxx /dbms/oracle/product/10.2.0/Db_1/dbs/initORA.ora
[ spfile ÀÎ °æ¿ì ]
è standby ±¸¼º ½Ã sqlplus ¸ðµå¿¡¼ alter ¸í·É¾î·Î ±¸¼ºÇÑ´Ù
SQL> show parameter file
è Primary DB¿Í Standby DB°£¿¡ datafile, redo log file ÀÌ À§Ä¡ÇÏ´Â directory °¡
´Ù¸¦ °æ¿ì db_file_name_convert ¿Í log_file_name_convert¸¦ »ç¿ëÇÏ¿© directory À̸§
Áß ´Ù¸¥ºÎºÐÀ» ġȯ ÇÒ ¼ö ÀÖµµ·Ï ÇÑ´Ù
SQL> alter system set db_file_name_convert =
'/dbms/oracle/oradata/ORA','/backup/oracle/oradata/ORA' scope= spfile;
//µé¾î¿Â °æ·Î, ġȯÇÒ °æ·Î
6) Standby DB¸¦ mount ¹× recovery Àû¿ëÇÑ´Ù
SQL> alter system set log_archive_dest_1='location=/dbms/oracle/product/10.2.0/Db_1/dbs/arch'
scope=both;
SQL> alter database mount standby database;
SQL> ALTER SYSTEM SET log_archive_format= '%t_%s_%r.arc' SCOPE=SPFILE;
SQL> shutdown immediate
SQL> startup nomount
SQL> alter database mount standby database;
SQL> set autorecovery on;
SQL> recover managed standby database disconnect; <----- #1¿ä·¸°Ô ¹Ù²Þ
Media recovery complete.
SQL> alter database archivelog;
7) Á¤ÇÕ¼º È®ÀÎ
Primary DB¿Í Standby DB°£ÀÇ sequence#°¡ µ¿±âÈ µÇ¾î ÀÖ´ÂÁö È®ÀÎÇÑ´Ù
SQL> select max(sequence#) from v$log_history;
MAX(SEQUENCE#)
----------------------------
1146
[Ãâó] Standby Database ±¸Ãà|ÀÛ¼ºÀÚ ¸ðÄ«»§
|
|
|
|
|
|