Authentication password file, Enabling archived logging, 170 enabling archived logging – HP A.06.11 User Manual

Page 170: Authentication password, File

Advertising
background image

Example

For the following configuration:

Oracle instance: PRO ORACLE_HOME: /app/oracle816/product

run:

id
uid=102(oraprod) gid=101(dba)
export ORACLE_SID=PRO
export ORACLE_HOME=/app/oracle816/product
export SHLIB_PATH=/app/oracle816/product/lib:/opt/omni/lbin
sqlplus /nolog
SQLPLUS> connect system/manager@PRO as sysdba;
Connected.
SQLPLUS> connect system/manager@PRO as sysoper;
Connected.

Authentication password file

Enable the use of the authentication password file for the database administrator:

1.

Shut down the Oracle target database.

2.

In the initORACLE_SID.ora file, specify:

remote_login_passwordfile = exclusive

For instructions on how to set up the password file, see the Oracle documentation.

Enabling archived logging

When you set the database to the archived logging mode, you protect the unsaved
online redo logs from being overwritten. Online backup of data files is useless without
the related redo logs because you cannot recover the database to a consistent state.

TIP:

Archive the redo log files generated during the online backup immediately after
BRBACKUP completes.

To protect the archive directory from overflowing, clear the directory regularly.

To enable archived logging:

Integrating SAP R/3 and Data Protector

170

Advertising