spfile »ç¿ë¿¡¼­ archive mode·Î º¯°æÇϱâ
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2016-02-12 10:11:34
 

SQL> alter system set log_archive_dest1='/home/oracle/oradata/ORCL/ArchiveLog1' scope=spfile;
SQL> alter system set log_archive_dest2='/home/oracle/oradata/ORCL/ArchiveLog2' scope=spfile;
SQL> alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;

DB À籸µ¿

SQL> shutdown immediate;
SQL> startup mount;

¾ÆÄ«ÀÌºê »ç¿ë ¼³Á¤

SQL> alter database archivelog;
SQL> alter database open;


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