Oracle Noarchivelog query

[former_member759680]

Hello,

I am about to set noarchivelog using BRTOOLS using teh following method.

Brtools - 1. Instance Management - 3. Alter Database Instance - c- continue - 4. Set noarchivelog mode - 3. Force -

Now, BRTOOLS will restart the database, so, should I stop SAP prior to executing this ?

or will BRTOOLS take care of it?

Thanks.

Edited by: Gautam Poddar on Dec 5, 2008 11:01 AM

[Former Member]

Hello Gauatam,

Always remember that Application should be down when you are shutting down the DB ..If you are not comfortable with Brtools you can try this command at the SQL prompt

Shutdown immediate;

startup mount;

alter databse noarchivelog;

Alter database open;

then You can shutdown your DB & startup and check .

Regards,

Ershad Ahmed

[former_member759680]

Ershad,

I do not understand the necessity/requirement for the 2nd shutdown.

________________________________________________

Shutdown immediate;

startup mount;

alter databse noarchivelog;

Alter database open;

then You can shutdown your DB & startup and check .

___________________________________________________

[former_member204746]

You will need to shutdown SAP before. BRTOOLS does not start or shutdown SAP for you.