Tuesday, December 21, 2010

Switching Off/On Archive Log in Oracle Database

Hi All,

Login to the system as root, then follow these steps:
-----------------------Switching Archive log Off----------------------------
su - SIDadm
>sqlplus /nolog
>conn sys as sysdba
Enter password: (Press Enter)
>startup mount; (Press Enter)
>alter database noarchivelog; (Press Enter)
> alter database open;

Now Start the SAP Instance only.

-----------------------Switching Archive log On----------------------------

su - SIDadm
>sqlplus /nolog
>conn sys as sysdba
Enter password: (Press Enter)
>startup mount; (Press Enter)
>alter database archivelog; (Press Enter)
> alter database open;

Proceed with starting SAP instance.

Note: Please refer to SAP/Oracle note for exact steps.

No comments:

Post a Comment