Advantages of running a database in archive log mode - oracle

What are the advantages of running a database in archive log mode?

An Oracle database can run in one of two modes. By default, the database is created in NOARCHIVELOG mode

When in NOARCHIVELOG mode the database runs normally, but there is no capacity to perform any type of point in time recovery operations or online backups. Thus, you have to shutdown the database to back it up, and when you recover the database you can only recover it to the point of the last backup.

When you run a database in ARCHIVELOG mode, the database will make copies of all online redo logs after they are filled. These copies are called archived redo logs. The archived redo logs are created via the ARCH process. The ARCH process copies the archived redo log files to one or more archive log destination directories.
What is dba_segment in oracle? - oracle
What is dba_segment in oracle? - DBA_SEGMENTS tells about the space allocated for all segments in the database for storage...
What is dba_segment in oracle? - oracle
What is dba_segment in oracle? - DBA_SEGMENTS tells about the space allocated for all segments in the database for storage...
Purpose of using Nextval while creating the sequence - oracle
Purpose of using Nextval - NextVal gives you the available number in the sequence asked for...
Post your comment