Wednesday, May 9, 2012

Getting Started with Oracle Database Vault

Deploying Database Vault Administrator to a Standalone OC4J Container You can manually deploy Database Vault Administrator to the Oracle Application Server Containers for J2EE (OC4J) home, which by default is in the ORACLE_HOME\oc4j\j2ee\home directory.
To manually deploy Database Vault Administrator:
  1. Edit the file ORACLE_HOME\oc4j\j2ee\home\config\server.xml. Enter the following line just before the last line that reads, </application-server>:
    <application name="dva" path="ORACLE_HOME\dv\jlib\dva_webapp.ear" auto-start="true" />
    
    For example:
    <application name="dva" path="C:\oracle\product\10.2.0\db1\dv\jlib\dva_webapp.ear"
    auto-start="true" />
    
  2. Edit the file ORACLE_HOME\oc4j\j2ee\home\config\http-web-site.xml. Enter the following line just above the last line that reads, </web-site>:
    <web-app application="dva" name="dva_webapp" root="/dva" />
    

Sunday, May 6, 2012

Oracle database cold backup!!

Cold backup files are:


select file_name from dba_data_files;

select member from v$logfile;

select value from v$parameter where name ='spfile';

select name from v$controlfile;

select name from v$tempfile;