01001010111

확인

archive log list

설정

 shutdown immeidate

startup mount

alter database archvelog

alter database open

끗

끄기

shutdown immeidate

startup mount

alter database noarchvelog          <<<--플래시백
끄고
이거
해야됨

alter database open

 끗

설명

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     6

Next log sequence to archive   8

Current log sequence           8

#vi initSID.ora를
다음과
같이
수정
후

log_archive_start = true  --
①

log_archive_dest = $ORACLE_HOME/dbs/arch  -- ②

log_archive_format = arch_%s.arc  -- ③

archive log list

재확인

SVRMGR> select GROUP#,SEQUENCE#,BYTES ,MEMBERS,ARCHIVED,

STATUS  from v$log;

SQL> select GROUP#,SEQUENCE#, BYTES ,MEMBERS  ,ARCHIVED ,STATUS  from v$log;

    GROUP#  SEQUENCE#      BYTES    MEMBERS ARC STATUS

---------- ---------- ---------- ---------- --- ----------------

         1          7   52428800          2 YES INACTIVE

         2          8   52428800          2 NO  CURRENT

         4          6   52428800          2 YES INACTIVE

원본 위치 <http://hhyride.springnote.com/pages/3713611>