cancel
Showing results for 
Search instead for 
Did you mean: 

How to use brtools to disable achive

Former Member
0 Kudos

Hi guys

How do you disable the achive using brtools?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

go to brtools using command line (type brtools)

1. select Instance management

2. select alter database instance

3. select alter database action & enter noarchlog

4. select database instance & enter SID

select C(continue) till the brtools finish, this will switch your DB to no archive log mode if it is in archive log mode.

I suggest that do not switch it to noarchlog because you need this archive file to restore the system.

Regards,

Rajesh

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

you can simply use this command with SQLPlus :

startup mount exclusive

connect internal

alter database noarchivelog;

alter database open;

Regards

Former Member
0 Kudos

Wee,

Use this,

BRTOOLS ->Instance Management ->Alter database ->Set noarchivelog mode