RAC¿¡¼­ archive ¸ðµå·Î ÀüȯÇÏ·Á¸é
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2007-07-04 15:20:12
 

1.    ÀÏ´Ü ÇöÀç DB°¡ spfile·Î ±¸µ¿µÇ¾î ÀÖ´Ù¸é spfileÀ» ÆíÁýÇÏÁö ¸»°í,
Init fileÀ» ¸¸µé¾î¼­ ÆíÁýÀ» ÇÑ´Ù.(Primary node¿¡¼­)
SQL> create pfile from spfile;
#>cd $ORACLCE_HOME/dbs
#>vi initSID.ora
<instance1>.log_archive_dest_1=¡¯location=°æ·Î¡¯  //Primary archive°æ·Î
<instance2>.log_archive_dest_1=¡¯location=°æ·Î¡¯  //Secondary archive°æ·Î
log_archive_format=¡¯arch_%t_%s.arc ¡¯ // archive file format
log_archive_start=TRUE // archive mode enable
*.cluster_database=false // archive mode ÀÛ¾÷½Ã Single mode·Î
*.cluster_database_instance=1
2.    DB 2 node shutdown
SQL> shutdown immediate;
3.    DB mount(Primary node)
SQL> startup mount exclusive pfile=¡¯$ORACLE_HOME/dbs/initSID.ora¡¯;
// ÆíÁýÇÒ pfile·Î DB¸¦ mount½ÃÅ´
4.    archive mode·Î Àüȯ(Primary node)
SQL> alter database archivelog;
// archive mode º¯È¯
5.    DB open (Primary node)
    SQL> alter database oepn;
6.    DB RAC Parameter ¿øº¹ (Primary node)
SQL> create spfile from pfile; //ÆíÁýÇÑ pfileÀ» spfile·Î ´Ù½Ã Àû¿ë
SQL> shutdown immediate;
SQL> startup;
SQL> alter system set cluster_database=true scope=spfile;
SQL> alter system set cluster_database_instances=2 scope=spfile;
// RAC Parameter ¿øº¹
    SQL> shutdown immediate;
7.    DB startup (2-node ¸ðµÎ)
    SQL> startup;
    SQL> archive log list; // archive mode È®ÀÎ
    SQL> alter system switch logfile;
    * archive log destinationÀÇ owner¿Í permissionÀ» È®ÀÎÇÒ °Í!

oracle 9i¿¡¼­ ÀÛ¾÷Çß½À´Ï´Ù.


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦