검색결과 리스트
archivelogmode에 해당되는 글 1건
- 2015.07.16 - Archive log mode 확인 및 모드 변경 1
글
- Archive Log mode 확인
SYS@PROD>archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log sequence 24 Current log sequence 26 |
- Archive Log Mode로 변경
해당 모드로의 변경은 데이터베이스가 Mount 상태일 때 가능.
SYS@PROD>alter database archivelog; alter database archivelog * ERROR at line 1: ORA-01126: database must be mounted in this instance and not open in any instance SYS@PROD>shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SYS@PROD>startup mount ORACLE instance started.
Total System Global Area 417546240 bytes Fixed Size 2213936 bytes Variable Size 327157712 bytes Database Buffers 83886080 bytes Redo Buffers 4288512 bytes Database mounted.
Database altered.
SYS@PROD>archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log sequence 24 Next log sequence to archive 26 Current log sequence 26 |
- No Archive Log mode 변경
SYS@PROD>startup mount ORACLE instance started.
Total System Global Area 417546240 bytes Fixed Size 2213936 bytes Variable Size 327157712 bytes Database Buffers 83886080 bytes Redo Buffers 4288512 bytes Database mounted. SYS@PROD>alter database noarchivelog;
Database altered.
SYS@PROD>archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log sequence 24 Current log sequence 26 |
'ORACLE > TIP' 카테고리의 다른 글
- Tablespace 사용률 관리 확인 스크립트 (1) | 2015.07.16 |
---|---|
- Redo Log 상태 확인 스크립트 (0) | 2015.07.16 |
- SQL Prompt 변경하기. (ex. SYS@PROD) (0) | 2015.07.16 |
RECENT COMMENT