HP Application Recovery Manager software Integration guide (March 2008)

SQL> connect system/manager@PROD as sysdba;
Connected.
• For online backup only, enable the Oracle automatic log archiving:
1. Shut down the Oracle target database instance on the application system.
2. Back up the entire database using a filesystem backup.
3. Select the location for archive logs:
• If SPFILE is used:
Run:
alter system set log_archive_dest=path_to_archive_logs
SCOPE=SPFILE;
• If the init.ora file is used:
Run:
log_archive_start=true
log_archive_dest=path_to_archive_logs
The default path of the file is:
Windows: ORACLE_HOME\database\initDB_NAME.ora
UNIX: ORACLE_HOME/dbs/initDB_NAME.ora
where DB_NAME is the name of the Oracle database instance.
4. Mount the target database and to enable the archive log mode, start SQL*Plus
and type:
startup mount
alter database archivelog;
alter database open;
Example
If the user name for the target database is system, password manager,
and instance name PROD, then the commands will look like:
sqlplus /nolog
SQL> connect system/manager@PROD as sysdba;
Connected.
SQL> startup mount;
SQL> alter database archivelog;
Statement processed.
SQL> archive log start;
Statement processed.
SQL> alter database open;
Integration guide 95