Enabling ARCHIVELOG

Take a trace of controlfile for backup. 

SERVER:sidadm 1> sqlplus "/as sysdba" 

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Mar 5 14:34:06 2009 

Copyright (c) 1982, 2005, Oracle. All Rights Reserved. 

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options 

SQL> alter database backup controlfile to trace; 

Database altered. 

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options 

• Now stop sap and oracle database normally. Listener process need not to be stopped. 

SERVER:sidadm 2> stopsap 

Checking SID Database
------------------------------
ABAP Database is running 

Stopping the SAP instance DVEBMGS80
----------------------------------
Shutdown-Log is written to /home/sidadm/stopsap_DVEBMGS80.log
Instance on host SERVER stopped
Waiting for cleanup of resources...................
Running /usr/sap/SID/SYS/exe/run/stopdb
Trying to stop SID database ...
Log file: /home/sidadm/stopdb.log
SID database stopped
/usr/sap/SID/SYS/exe/run/stopdb completed successfully 

Checking SID Database
------------------------------
ABAP Database is not available via R3trans 

• Now we have to start oracle in mount stage. 

SERVER:orasid 1> sqlplus "/as sysdba" 

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Mar 5 14:44:07 2009 

Copyright (c) 1982, 2005, Oracle. All Rights Reserved. 

Connected to an idle instance. 

SQL> startup mount;
ORACLE instance started. 

Total System Global Area 1.1123E+10 bytes
Fixed Size 2068808 bytes
Variable Size 9009368760 bytes
Database Buffers 2097152000 bytes
Redo Buffers 14704640 bytes
Database mounted. 

• We will now change to archivelog mode for oracle and then will open the database. 

SQL> alter database archivelog; 

Database altered. 

SQL> alter database open; 

Database altered. 

• Archivelog mode can be verified by command select log_mode from v$database 

SQL> select log_mode from v$database; 

LOG_MODE
------------
ARCHIVELOG 

• For enabling automatic archival we can use the following SQL commands 

SQL> alter system archive log start; 

System altered. 

• Now we can see that automatic archival is enabled 

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/SID/oraarch/SIDarch
Oldest online log sequence 28151
Next log sequence to archive 28154
Current log sequence 28154 

• Now we can start sap system. 

SERVER:sidadm 1> startsap 

Checking SID Database
------------------------------
ABAP Database is running 

Starting SAP-Collector Daemon
------------------------------
Start of saposcol failed 

Starting SAP Instance DVEBMGS80
------------------------------
Startup-Log is written to /home/sidadm/startsap_DVEBMGS80.log
Instance Service on host SERVER started
Instance on host SERVER started