Table Level Recovery from backup – 12c now has the ability to recover a single table from an RMAN backup with the user of RECOVER TABLE option.
RMAN Command-Line SQL – RMAN utility now allows for the execution of SQL commands against target database without using SQL key word. RMAN also now support the SQLPLUS DESCRIBE command for tables and views.
Active Database Duplication – RMAN supports the ability to clone a source database to an auxiliary database over the network. Retrieving all backup sets from source database over network and allows for use of block compression during the duplication process.
NOOPEN option for Duplicate database creation, which allows for recovered database to not be open with resetlogs before administrative tasks can be performed.
duplicate target database
to newdatabase
from active database
noopen;
SECTION SIZE option with Image Copies – RMAN now allows you to divide data files into subsections and split upon multiple recovery channels.
backup
as copy
section size 500M
database;
Incremental Backups can include the SECTION SIZE option which allows for parallel channels to be used, thus reducing the time for backup.
backup
incremental level 1
section size 500m
Datafile ‘/u01/oradata/orcl/data01.dbf’;
SNAPSHOT with the use of BACKUP mode, 12c allows for the use of VM snapshots or storage snapshot without placing database in backup mode. The snapshot requires 3 things for use:
- Database is consistent at time of snapshot.
- Write order is maintained for snapshot.
- Snapshot stores time of snapshot.
SNAPSHOT TIME option has become part of RECOVER command which allows for recovery from OS snapshot to a consistent point.
Larry Catt
OCP