Viewing Database Logging Status |
 Previous |
 Next |
Every Oracle database includes two or more redo log files. You can view redo log files on the Database Logging page. A set of redo log files is collectively known as the redo log for the database. These log files function to record all changes made to data.
Archiving your redo log files is an effective way to protect your database from media failure.
|
See Also: "About Database Storage Structures" in Oracle Database Express Edition 2 Day DBA Guide for more information on redo log files |
Topics:
Accessing the Database Logging Page
To access the Database Logging page:
-
On the Database Home Page, click the Administration icon and then Storage.
-
If prompted, enter the appropriate administrator username and password and click Login.
The Storage page appears. See "Monitoring the Space Available" .
-
On the Tasks list, click View Logging Status.
The Database Logging page appears.
|
Tip: You can also navigate to the Database Logging page by clicking the Log Archiving link on the Usage Monitor. See "About the Usage Monitor" |
About Redo Log Files
Redo log files are the most crucial structure for database recovery. This set of files is collectively known as the redo log for the database. A redo log is made up of redo entries, which are also called redo records.The primary function of the redo log is to record all changes made to data in the database. If an Oracle instance failure or operating system failure prevents modified data from being permanently written to the datafiles, the changes can be recovered from the redo log so that committed data updates are not lost.
|
See Also: "About Database Storage Structures" in Oracle Database Express Edition 2 Day DBA Guide and Oracle Database Administrator's Guide for more details about redo log |
About the Flash Recovery Area
Oracle Database XE stores database backups and archived redo logs in the flash recovery area. The flash recovery area is a directory, separate from the database itself, where recovery-related structures are stored.
The default configuration of Oracle Database XE stores the flash recovery area on the same disk as your database files. In this configuration, if a media failure occurs, you can lose both your database and your backups. For any database where data protection is essential, change the location of the flash recovery area so that it is stored on a different disk.
|
See Also : "Setting Flash Recovery Area Location and Size" in Oracle Database Express Edition 2 Day DBA Guide |
About ARCHIVELOG Mode
Oracle Database XE can be configured to be in ARCHIVELOG mode or in NOARCHIVELOG mode. In ARCHIVELOG mode, a background archiving process copies filled, inactive redo log files to the flash recovery area before they are reused. In NOARCHIVELOG mode, the Oracle Database XE is not configured to archive its redo logs.
To simplify the management of your database, log archiving is disabled by default. Oracle recommends that you enable ARCHIVELOG mode for optimal data protection.
|
See Also:
|