ORACLE Database / WAS (iAS) / SQL 자료실 - 포기하지 않으면 실패하지 않는다!
Vote Reply Modify Delete Forward Prev Next List

  Author   : 조성환 [ ladmin ] Vote: 1180, Modifies: 1, Hit: 4427, Lines: 105, Category: Etc.
노아카이브 로그모드 만들기

[oracle]% >  svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
With the Partitioning option
JServer Release 8.1.7.3.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR>

SVRMGR> startup

ORACLE instance started.
Total System Global Area                        369811616 bytes
Fixed Size                                          73888 bytes
Variable Size                                   225017856 bytes
Database Buffers                                134217728 bytes
Redo Buffers                                     10502144 bytes
Database mounted.
Database opened.



SVRMGR> archive log list ;

Database log mode              Archive Mode
Automatic archival             Disabled
Archive destination            /export/home/oracle8/OraHome1/dbs/arch
Oldest online log sequence     38435
Next log sequence to archive   38438
Current log sequence           38438
SVRMGR>



SVRMGR> shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.



SVRMGR> startup mount

ORACLE instance started.
Total System Global Area                        369811616 bytes
Fixed Size                                          73888 bytes
Variable Size                                   225017856 bytes
Database Buffers                                134217728 bytes
Redo Buffers                                     10502144 bytes
Database mounted.



SVRMGR> alter database noarchivelog ;

Statement processed.



SVRMGR> archive log list ;

Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /export/home/oracle8/OraHome1/dbs/arch
Oldest online log sequence     38435
Current log sequence           38438



SVRMGR> alter database open ;

Statement processed.



SVRMGR> show sga

Total System Global Area                        369811616 bytes
Fixed Size                                          73888 bytes
Variable Size                                   225017856 bytes
Database Buffers                                134217728 bytes
Redo Buffers                                     10502144 bytes



SVRMGR> archive log list ;

Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /export/home/oracle8/OraHome1/dbs/arch
Oldest online log sequence     38435
Current log sequence           38438
SVRMGR>




Prev: ORA-01033 Oracle initialization or shutdown 에러
Next: 오라클 DB 자동 Start/Stop 스크립트
2003/12/23(22:21) from 211.253.82.82
CrazyWWWBoard 2000

Vote Reply Modify Delete Forward Prev Next List
(c) Nobreak Technologies, Inc.