Backup and Restore Oracle DataBase using RMAN
General information
- RMAN Utility (Recovery Manager)
- Working with restore points
- Basic RMAN views
- Not enough free space in Fast Recovery Area
Creating backups using Recovery Manager (RMAN)
- Creating backups using RMAN
- Creating backups using RMAN (NOARCHIVELOG)
- RMAN script for backups. Example 1. Backup to FRA (ARCHIVELOG)
- RMAN script for backups. Example 2. Backup to directory (ARCHIVELOG)
- Example shell script for backup
- Creating an incremental database copy using RMAN
Checks using RMAN (Recovery Manager)
Restoring from backups using RMAN (Recovery Manager)
Deleting RMAN (Recovery Manager) objects
Example with incarnations
RMAN Catalog (I haven’t found a practical use for it yet)
- Creating RMAN Catalog (For storing backup information in a special Oracle database)
- Change db_unique_name in RMAN catalog
Creating a database copy using RMAN
- Creating a database copy from backup using RMAN on the same server
- Creating a copy of an active database using RMAN
Connecting in a bash script
// How to log into rman in a bash script, for example, with password !!PASSword!!
// Put the entire connection string in single quotes, password in double quotes
rman target 'sys/"!!PASSword!!"@MYBASE'
“Trendiest” RMAN script for creating Oracle backups. Sends telegram notifications about backup errors
https://github.com/wildmakaka/oracle-rman-with-telegram-notifications