Switch on and off Archive logs in oracle

 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;

Post a Comment

0 Comments

  PFile and SPFile in oracle