ARCHIEVE MODE

[Former Member]

HI,

how can i set the archieve mode?

regards

vijay

[Former Member]

Thanks and I regret for closing the thread lately

[Former Member]

Hi Vijay,

Login to sqlplus as sysdba,

sqlplus "/as sysdba"

SQL> archive log list

will show you the current archive mode.

To change from noarchive log mode to archive log mode, startup the database in mount mode.

>startup mount

> alter database archivelog;

> archive log list

> alter database open;

Hope this helps.

Regards,

Nisch

[Former Member]

Hi vijay,

refer note number 863417 or follow below steps.

1.stop sap and database.

2.check below values in init(sid).ora file

LOG_ARCHIVE_START ,LOG_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT

3.start Database in mount state

>startup mount

4.to enable archive mode

>alter database archivelog;

5.next open the database and SAP.

Regards

nani