Implications of test database running in NOARCHIVELOG mode - Oracle Datafiles and Tempfiles

Q.  What are the implications if your test database is running in a NOARCHIVELOG mode?
- Published on 03 Aug 15

a. You can perform open database backups
b. You can perform closed database backups
c. You cannot perform schema-level logical backups
d. You can perform the backup of only the SYSTEM tablespace when the database is open

ANSWER: You can perform closed database backups


  • Nirja Shah   -Posted on 25 Sep 15
    - When you run your database in NOARCHIVELOG mode, you disable the archiving of the redo log.

    - The database control file indicates that filled groups are not required to be archived.

    - Therefore, when a filled group becomes inactive after a log switch, the group is available for reuse by LGWR.

    - NOARCHIVELOG mode protects a database from instance failure but not from media failure.

    - Only the most recent changes made to the database, which are stored in the online redo log groups, are available for instance recovery.

    - If a media failure occurs while the database is in NOARCHIVELOG mode, you can only restore the database to the point of the most recent full database backup.

    - You cannot recover transactions subsequent to that backup.

    - In NOARCHIVELOG mode you cannot perform online tablespace backups, nor can you use online tablespace backups taken earlier while the database was in ARCHIVELOG mode.

    - To restore a database operating in NOARCHIVELOG mode, you can use only whole database backups taken while the database is closed.

    - Therefore, if you decide to operate a database in NOARCHIVELOG mode, take whole database backups at regular, frequent intervals.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)