Performing Oracle Advanced Recovery - OCP: Oracle Database 12c Administrator Certified Professional - page 320

schema. Note that you can't recover a specific schema, only the tables in it, so your RECOVER
command will specify the schema and table names of the tables you need to restore.

When you restore a table, the restore will fail if that table already exists.
In this case, you need to either rename the table in the database or drop it.
Another option is to remap the table name to something different than the
original table or remap the table to a new schema.

Before you start the restore, you need to decide where you want the auxiliary database-
related files to be stored. In this case, we have chosen to use the directory /u01/app/oracle/
aux . Once you confirm that the directory exists, you log into RMAN and start the restore:

[oracle@server12c ~]$ rman target=/
recover table hr.emp, hr.dept, hr.bonus, hr.salgrade
until time "to_date('03/27/2013 10:24:29','mm/dd/yyyy hh24:mi:ss')"
auxiliary destination '/u01/app/oracle/aux';

When you press Enter, RMAN will start the restore. The output of the restore is quite
lengthy, so we decided not to include it here. In summary, you will see the following in
the output:

Allocation of channels

■

The creation of the auxiliary instance

■

Restore of the control file for the auxiliary instance

■

A list of data files that will be restored, followed by their restore and recovery in the
auxiliary instance

■

Export of tables from the auxiliary instance via Oracle Data Pump

■

Import of tables, constraints, indexes, and other dependent objects into the target
database from the Data Pump export file

■

Cleanup of the auxiliary instance

■

ASM-Related Backups

Automatic Storage Management (ASM) has become very commonly used in Oracle Database
architectures to manage the disks that are used by the database. With respect to ASM, there
are some backup considerations that you will need to be aware of for your OCP exam. We
will address these in this section as follows:
1. Quick overview of ASM
2. ASM diskgroup metadata backups
3. Restore ASM disk groups