본문 바로가기

쓰기

oracle 10g 아카이브 모드 설정

2021.09.22 00:52

이곤아이 조회 수:366

  1. 아카이브 모드 상태 확인
    	SQL> archive log list
    	
    	Database log mode              No Archive Mode
    	Automatic archival             Disabled
    	Archive destination            USE_DB_RECOVERY_FILE_DEST
    	Oldest online log sequence     1
    	Current log sequence           2
    	
    	
    	SQL> show parameter spfile
    	
    	NAME                                 TYPE        VALUE
    	------------------------------------ ----------- ------------------------------
    	spfile                               string      /u01/app/oracle/product/10.2.0
    	                                                 /db_1/dbs/spfileTSH1.ora

     
  2. 아카이브 모드 설정
    	SQL> ALTER SYSTEM SET log_archive_dest_1='location=/u01/app/oracle/oradata/data reopen=60' scope=spfile;
    	System altered.
    	
    	
    	SQL> ALTER SYSTEM SET log_archive_format='%t_%s_%r.arc' scope=spfile;
    	System altered.
  3. Oracle 종료
    	SQL> shutdown immediate
    	Database closed.
    	Database dismounted.
    	ORACLE instance shut down.
  4. Oracle 시작
    	SQL> startup mount
    	.ORACLE instance started.
    	
    	Total System Global Area  608174080 bytes
    	Fixed Size                  1220844 bytes
    	Variable Size             171970324 bytes
    	Database Buffers          432013312 bytes
    	Redo Buffers                2969600 bytes
    	Database mounted.
  5. log모드 변경
    	SQL> alter database archivelog;
    	Database altered.
  6. 아카이브모드 설정내용 확인
    	SQL> archive log list
    	Database log mode              Archive Mode
    	Automatic archival             Enabled
    	Archive destination            /u01/app/oracle/oradata/data
    	Oldest online log sequence     1
    	Next log sequence to archive   2
    	Current log sequence           2
  7. DB Open
    	SQL> alter database open;
    	Database altered.
  8. DB 셧다운 & Cold Backup 권장
    	SQL> shutdown immediate
    	Database closed.
    	Database dismounted.
    	ORACLE instance shut down.
  9. log파일 생성확인
    	SQL> ALTER SYSTEM SWITCH LOGFILE;
    	
    	System altered.

     
번호 제목 글쓴이 조회 수 날짜

등록된 글이 없습니다.