From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Using RMAN scripts

Using RMAN scripts - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Using RMAN scripts

“

- [Instructor] Instead of having to manually type backup commands into the RMAN prompt to achieve database backup and recovery, RMAN also supports backup scripts. These scripts can be integrated with a scheduler such as crontab on Linux to run automatic RMAN backups on a regular basis. Let's see RMAN scripts in action. We'll start by opening an RMAN prompt to our target database. So, I'll type RMAN target equals backslash. Now, because we have taken multiple backups throughout this course and to make sure that we won't run out of space on our virtual machine, let's delete any existing backups we have taken of both our database data files, archive read logs and control files. You can find the three delete noprompt backup commands included in your exercise file. The first command deletes any backups of data files, the second commands deletes any backups we have of our archived read logs and the third command deletes any backups we have of the database control file. So, we can copy these…

Contents