|
|
[ÀϹÝ] [DB] ¿À¶óŬ ½ºÅĹÙÀÌ ¼¹ö ±¸ÃàÇϱâ #1 |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 121.¢½.39.7 |
ÀÐÀ½:3079 |
|
|
Creating physical standby database
1. standby controlfile »ý¼º(At Primary DB)
SQL>alter database create standby controlfile as '/data1/standby.ctl';
SQL>shutdown immediate;
2. Copy datafiles, standby controfile, archive logs, online logs from Primary to Standby
-- ÆĶó¹ÌÅÍ ÆÄÀÏÀº ¹Ì¸® º¹»çÇÑ ÈÄ standby db¿¡ ¸Â°Ô ¼öÁ¤ÇØ ³õ¾Æ¾ßÇÑ´Ù.
-- control file º¹»ç
cp /data1/standby.ctl /data1/oradata/STBY/control01.ctl
cp /data1/standby.ctl /data1/oradata/STBY/control02.ctl
cp /data1/standby.ctl /data1/oradata/STBY/control03.ctl
3. Start and Mount Standby instance(At Standby DB)
sqlplus "/as sysdba"
SQL>startup nomount
SQL>alter database mount standby database;
-- standby redo log »ý¼º(online redo log¿Í °°Àº Å©±â·Î »ý¼ºÇؾßÇÑ´Ù.)
SQL>alter database add standby logfile '/data1/oradata/standby01.log' size 1M;
SQL>alter database add standby logfile '/data1/oradata/standby02.log' size 1M;
Note: ¾Æ·¡ 3°¡Áö ¹æ¹ý Áß ¸¶Áö¸· ¹æ¹ýÀ» »ç¿ëÇÑ´Ù.
SQL>recover standby database; (normal recovery mode)
...
Specify log:{<RET>=suggested | filename | auto | cancel}
- or -
SQL>recover managed standby database; (by forground process. waiting)
- or -
SQL>recover managed standby database disconnect (from session) (parallel n); (by MRP process)
4. È®ÀÎ
(At Primary)
SQL>select database_role, protection_mode from v$database;
DATABASE_ROLE PROTECTION_MODE
-------------------------------------------
PRIMARY MAXIMUM PERFORMANCE
(At Standby)
SQL>select database_role, protection_mode from v$database;
DATABASE_ROLE PROTECTION_MODE
------------------------------------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE
5. Archive Àü¼Û Test
(At Primary)
SQL>alter system switch logfile;
SQL>alter system switch logfile;
SQL>alter system switch logfile;
...
SQL>col error format a20
SQL>select dest_id, status, error from v$archive_dest
where dest_id <=2;
DEST_ID STATUS ERROR
-------------------------------------
1 VALID
2 VALID
(At Standby)
archive log file È®ÀÎ
6. Data Àü¼Û È®ÀÎ Test
(At Primary)
SQL>create table hr.test(a number);
SQL>insert into hr.test values(100);
SQL>commit;
SQL>alter system archive log current;
(At Standby)
SQL>recover managed standby database cancel;
SQL>alter database open read only;
SQL>select * from hr.test;
A
---------
100
-- Read only => managed recovery mode Àüȯ
SQL>shutdown
SQL>startup nomount
SQL>alter database mount standby database;
SQL>recover managed standby database disconnect;
|
|
|
|
|
|