To Enable and Disable Archive logs in System
Enable:
hostname:oracs5 55>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Apr 19 10:53:48 2014
Copyright (c) 1982, 2011, Oracle.
All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data mining and Real Application Testing
options
SQL>shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>select status from v$instance;
select status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 19669
Session ID: 405 Serial number: 49
SQL>startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS
instance
ORACLE instance started.
Total System Global Area 4777603072 bytes
Fixed Size
2236008 bytes
Variable Size
2332033432 bytes
Database Buffers
2298478592 bytes
Redo Buffers
144855040 bytes
Database mounted.
SQL>alter database archivelog;
Database altered.
SQL>alter database open;
Database altered.
SQL>archive log list;
Database log mode Archive Mode
Automatic archival
Enabled
Archive destination
/oracle/CS5/oraarch/CS5arch
Oldest online log sequence
6394
Next log sequence to archive
6397
Current log sequence
6397
SQL>
Disable:
hostname:oracs5 55>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Apr 19 10:53:48 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data mining and Real Application Testing options
SQL>shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>select status from v$instance;
select status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 19669
Session ID: 405 Serial number: 49
SQL>startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 4777603072 bytes
Fixed Size 2236008 bytes
Variable Size 2332033432 bytes
Database Buffers 2298478592 bytes
Redo Buffers 144855040 bytes
Database mounted.
SQL>alter database Noarchivelog;
Database altered.
SQL>alter database open;
Database altered.
SQL>archive log list;
Database log mode No Archive
Mode
Automatic archival
Enabled
Archive destination
/oracle/CS5/oraarch/CS5arch
Oldest online log sequence
6394
Next log sequence to archive
6397
Current log sequence
6397
SQL>
No comments:
Post a Comment