Auditing RMAN operations

In this recipe, you'll see that RMAN operations are audited by default.

Getting ready

In this recipe, we assume that database is in the ARCHIVELOG mode. To complete this recipe, you'll need an existing user who has the SYSBACKUP privilege (for example, tom) and an existing user who has the dba role (for example, maja).

How to do it...

1. Connect to the target database as a user who has the SYSBACKUP privilege (for example, tom).

   $ rman target '"tom@ora12cR1 AS SYSBACKUP"'
   

2. Backup the EXAMPLE tablespace and view information about backups:

   RMAN> backup tablespace EXAMPLE;
   
   RMAN> list backup;
   
   RMAN> exit
   

3. Connect to the database as a user who has the DBA role (for example, maja):

   $ sqlplus maja
   

4. Find the location of datafile for EXAMPLE tablespace:

   SQL> select file_name from dba_data_files where
          tablespace_name='EXAMPLE';
   FILE_NAME
   ----------------------------------------------------------
   /u01/app/oracle/oradata/ORA12CR1/datafile/...