Switch on and off Archive logs in oracle
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database noarchivelog; // to switch off
SQL> alter database archivelog; //to switch on
SQL>alter database open;
To check current status:
SQL>archive log list;
0 Comments