Review the Prerequisites for Oracle Database
To back up an Oracle database with consistent data, ensure that the ARCHIVELOG mode is enabled to archive the Redo logs.
Follow these steps to verify if the ARCHIVELOG mode is enabled:
- Log into the Oracle server as an Oracle user with SYSDBA privileges.
- Enter the following command at the SQL*Plus prompt:
- Archive log settings for the current instance is displayed.
- Configure the following settings:
- Start the ARCHIVELOG mode.
ARCHIVE LOG LIST;
Database log mode: Archive Mode
Automatic archival: Enabled
Note: If the ARCHIVELOG mode is not enabled, start the ARCHIVELOG mode to back up the database.
Follow these steps to start the ARCHIVELOG mode:
- Shut down the Oracle server.
- Run the following statements in Oracle:
- By default, archive logs are written to the flash recovery area. If you do not want to write archive logs to the flash recovery area, set the LOG_ARCHIVE_DEST_n parameter to the location where you want to write archive logs.
- Archive log settings for the current instance is displayed.
- Configure the following settings:
CONNECT SYS/SYS_PASSWORD AS SYSDBA
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
SQL>ALTRE SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=e:\app\administrator\oradata\<oracle_database_name>\arch' SCOPE= BOTH;
System altered.
SQL> ARCHIVE LOG LIST;
Database log mode: Archive Mode
Automatic archival: Enabled
Archive destination: E:\app\oracle\oradata\<oracle_database_name>\arch
Oldest online log sequence: 21
Current log sequence: 23
The Oracle VSS writer service started and is functioning properly.
Note: If Oracle VSS Writer Service is not running, Arcserve UDP Agent (Windows) will automatically start it before taking the snapshot.
- Arcserve UDP Agent (Windows) is installed and a plan is scheduled.
Ensure that you have selected the volumes that include all the Oracle data files, server parameter file, control files, archived redo logs, and online redo logs for the backup.
-
Review the Compatibility Matrix that provides the supported operating systems, databases, and browsers.
If you want to perform a BMR for a disaster recovery, ensure that you have selected the system volumes and the volumes which includes all the oracle installation files.