cancel
Showing results for 
Search instead for 
Did you mean: 

how to stop archiving mode

Former Member
0 Kudos

Hi Friends,

I have a slight confusion here, since i have to stop archiving mode and below mentioned are the commands for that...

But before executing below mentioned commands do i have to stop sap and stop oracle for this (this is the confusion) or i can execute below mentioned commands with SAP and Oracle (lsnrctl) both in running state. ?

=========================================

4. If you need to reset ARCHIVELOG mode, do this in one of the following ways:

a. Do one of the folloeong out of three options men

1.Choose Instance Management ->Alter database instance in BRGUI or BRTOOLS and choose the action -> Set archivelog mode.

2. Enter the command brspace u2013f dbalter u2013a archlog from the command line

3. Enter the following commands in the Oracle tool SQLPLUS:

SQL> connect / as sysdba

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open;

SQL> archive log list

=======================================

Please advice

Regards

Ayush

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ayush

There is no confusion

whenever you want to stop the Archive log mode, you have to

stop SAP only not in oracle.

you simply put stopsap R3 ( this command will stop SAP only) and then

goto brtools from that menu you can stop the Archive log mode.

After changing the Archive log mode, then you put startsap R3.

Regards,

Sundar.c

Former Member
0 Kudos

Hi Sundar,

I appreciate your reply and i exactly did what i said.

Its only we have to shutdown SAP not Oracle to switch the archivelog mode.

Once SAP is stop we can toggle the archivelog mode by going in BRTOOLS -> Instance management (without stopping the lsnrctl)

Regards

Ayush

stefan_koehler
Active Contributor
0 Kudos

Hello Ayush and Sundar,

please take a closer look before posting such untrue statements.

The BR*Tools are shutdowning down oracle and then executing the commands.

The archivelog mode can only be changed in the MOUNT state and not in the OPEN state.

If the database is opened and you try to change the logmode:


Database opened.
SQL> alter database noarchivelog;
alter database noarchivelog
*
ERROR at line 1:
ORA-01126: database must be mounted EXCLUSIVE and not open for this operation

And now what are the BR*Tools are doing BRTOOLS -> Instance management :


BR0342I Database instance <SID> is open
BR0750I Database instance <SID> will be remounted now with mode 'IMMEDIATE'

Completed: ALTER DATABASE CLOSE NORMAL
Tue Aug  5 13:55:16 2008
ALTER DATABASE   MOUNT
Tue Aug  5 13:55:24 2008
Successful mount of redo thread 1, with mount id 982955975
Tue Aug  5 13:55:24 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Tue Aug  5 13:55:24 2008
/* BRSPACE */ alter database archivelog
Completed: /* BRSPACE */ alter database archivelog
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Tue Aug  5 13:55:24 2008
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...

You can see that the BR*Tools are shutdowning down the database for you, if it is still in an "unsupported" state for changing the log mode.

> (without stopping the lsnrctl)

The listener has nothing to do with the database itself. It is just for establishing connections. You can also shutdown the listener while your database is running or shutdown the database while the listener is running.

Regards

Stefan

Answers (1)

Answers (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Ayush,

the procedure of enabling/disabling the archivelog mode depends also on the oracle version. (For example with the init parameter LOG_ARCHIVE_START in Oracle 9i).

I would guess, that you are using Oracle 10g (because of the generated commands, that you have posted).

> SQL> connect / as sysdba

> SQL> startup mount

> SQL> alter database archivelog;

> SQL> alter database open;

> SQL> archive log list

I have marked the important part bold. You have to shutdown your database and start it in the MOUNT state.

Then you can change the log mode and after that OPEN or restart your database normal.

So the answer: You have to stop your SAP and Oracle database to switch the logmode.

Regards

Stefan