RMAN – Recovery Manager
- Backup is happen on the data block level. It can save time and space. Would detect the HWM on the file and do not backup data block higher the HWM.
- Can detect the bad data block
- Backup Level 0-5. 0 is Full backup. 1-5 can be differential or incremental .
-- Create tablepsace to hold repository
CREATE TABLESPACE RMAN
DATAFILE '/u01/app/oracle/oradata/oracledb1/RMAN01.DBF' SIZE 50M REUSE
AUTOEXTEND ON NEXT 64K MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
-- Create rman schema owner
CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;
GRANT connect, resource, recovery_catalog_owner TO rman;
- If SID is not provided, it use the current $ORACLE_SID
- Catalog’s username name and password is the one we create in the above.
- In below screenshot, we only connect to the catalog
In below screenshot, we connect to the $ORACLE_SID database and catalog and then register database.
backup database plus archivelog;
Here is the screenshot of the backup database plus archivelog
backup tablespace <TABLESPACE NAME>
backup tablepsace exmple;
Backup data file
backup datafile [datafile path]
backup datafile '/u01/app/oracle/oradata/oracledb1/example01.dbf';
Backup control file
backup current controlfile;
Differential Incremental backup
- Incremental backup would only backup the changed block since the last level 0 incremental backup.
- If there is no level 0 incremental backup. RMAN will first create level 0 and then create the level 1 backup.
- Oracle would not use the FULL backup as base (parent ) for increment backup ( level 1).
- The level 1 backup would only backup the changes since last level 0 or level 1 backup.
backup incremental level 1 database;
Cumulative Incremental backup
RMAN can also backup Cumulative backup base on the last level 0 backup.
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE database
# Show all backup
# Show/Delete items not needed for recovery