1.

Explain What Are The Steps To Switch A Databases Archiving Mode Between No Archivelog And Archivelog Mode?

Answer»

To check database is in which MODE:

  1. Conn sys/sys as sysdba
  2. SELECT log_mode from v$database

To set database in Archivelog mode:

  1. shutdown immediate;
  2. STARTUP mount;
  3. alter database archivelog;
  4.  alter database open;

To set database in NOARCHIVELOG Mode:

  1. shutdown immediate;
  2. startup mount;
  3. alter database noarchivelog;
  4. alter database open;

To check database is in which mode:

To set database in Archivelog mode:

To set database in NoArchivelog Mode:


Discussion

No Comment Found

Related InterviewSolutions