Change from noarchive mode to archive mode

[Former Member]

Hello Gurus,

I want to change my database mode to archive mode in one of my systems.

I am not sure about which procedure to follow....which is the safest to follow.

Through sql :

Shutdown databse

sql> startup mount;

sql> alter database archivelog;

sql> alter database open;

OR sould I use BRTOOLS for this work?

Which is the best approch to do this change and also can u pls tell me the brtools steps?

Thanks in advance!!

[former_member227283 · Accepted solution]

Hi,

If I use brtools do I have to manually stop database first and start it later or brtools will handle this by itself.

Check the my previous reply which is highlighted green, check point no. 10 , where you give option as yes , it mean brtools itself forcefully stop the database and after complition of swtich, it will start the database automatically.

Also note , if you don't want to user Force option in brtools, then you can do the activity manually thorugh sql command.

Thanks

Anil

[Former Member]

Thanks all for your help!!

[former_member227283]

*10. type as

• keep in mind while doing this acitivty you database will stop for some time , so it is recommend to stop sap only and not database and then do the brtools activity for arhchive log mode swtich**

yes once you get above output and press enter , then you will Force instance shutdown will swtich from no yes.*

11. Press c i.e continue continue for 2 times , it will take some time and you will get confirmation once the database is swtich to arcihve log mode

12. just for confirmation you can login to sqlplus "/as sysdba" and run the below command for confirming the archive log status.

sqlplus> archive log list

you should get the below outputof above command

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

13. Now you can start the SAP and you database is in archive log mode.

Thanks

Anil

Edited by: Anil Bhandary on Oct 20, 2009 8:12 PM

[former_member227283]

Hi,

Which is the best approch to do this change and also can u pls tell me the brtools steps

Brtools is a best option rather than sql command. Pls follow the below step to swtich database from noarchive mode to archive mode.

1. Run brtools from command prompt.

2. Select option 1 i.e 1 = Instance management

3. then select option 3 i.e 3 - Alter database instance

4. Then Press c for 2 time i.e you have select continue , continue 2 time

5. after pressing continue you will get the below output

-

---

Alter database instance main menu

1 - Switch redolog file

2 - Force database checkpoint

3 - Set archivelog mode

4 - Set noarchivelog mode

5 - Show instance status

6 * Exit program

7 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

6. Select option 3 i.e 3 - Set archivelog mode

7. after selecting option 3 you will get below output* ----

---

Options for alter of database instance RD1 *1 * Current archivelog mode (mode) .. [noarchlog]* *2 * Alter database action (action) .. [archivelog]* 3 - Force instance shutdown (force) . [no] 4 - SQL command (command) ........... [alter database archivelog] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ----

---

*8. select option * 3* i.e 3 - Force instance shutdown (force) . [no]* 9. you will get below output. BR0662I Enter your choice: 3 BR0280I BRSPACE time stamp: 2009-10-20 22.42.26 BR0663I Your choice: '3' BR0280I BRSPACE time stamp: 2009-10-20 22.42.26 BR0681I Enter string value for "force" (yes|no) [no]: *Edited by: Anil Bhandary on Oct 20, 2009 7:21 PM

Edited by: Anil Bhandary on Oct 20, 2009 8:11 PM

[ashish_vikas]

Hey !

Even using SQL are fine as far as you know this :

u2022 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.

u2022 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.

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

SQL> select log_mode from v$database;

LOG_MODE

-

---

ARCHIVELOG

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

SQL> alter system archive log start;

System altered.

u2022 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

 But this solution is not permanent in Oracle-9i and automatic archival will be disabled again after restarting the database; so for permanent change we must set parameter u2018log_archive_startu2019 to u2018TRUEu2019:
SQL> alter system set log_archive_start=TRUE scope=both; 

[Former Member]

Hi Learning SAP,

every time that I have to change the archive mode in one of my DBs I use the same procedure that you wrote (startup mount; / alter database archivelog; / alter database open;) without any problems.

Regards,

Federico Biavati

[ashish_vikas]

HI,

I f you are new to SAP/oracle, i would suggest you to use BRTOOLS to change parameters in system. Using brtools also you can eaisly changed to archiving mode for database.

Call BRTOOLS and choose Instance management u2192 Instance

status (confirm twice with “continue”).

Information about the status of database instance DEV

1 - Instance number (number) ........... 1

2 - Instance thread (thread) ........... 1

3 - Instance status (status) ........... OPEN

4 - Instance start time (start) ........ 2009-10-11 12.14.00

5 - Oracle version (version) ........... 10.2.0.2.0

6 - Database creation time (create) ....

7 - Last resetlogs time (resetlogs) ....

8 - Archivelog mode (archmode) ......... NOARCHIVELOG

9 - Archiver status (archiver) ......... STOPPED

10 - Current redolog sequence (redoseq) . 54

11 - Current redolog SCN (redoscn) ...... 2123

12 - Number of SAP connections (sapcon) . 0

Call BRGUI or BRTOOLS and choose Instance management u2192 Alter

database instance u2192 Set archivelog mode.

Your database instance will be stopped and restarted into mount state, archive log mode will be turned on, and the database will be opened.

ashish

[Former Member]

If I use brtools do I have to manually stop database first and start it later or brtools will handle this by itself.