|
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¿¡¼ ÀÛ¾÷Çß½À´Ï´Ù.
|