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

Unlock the full course today

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

Manual backup of control files and archived logs

Manual backup of control files and archived logs - Oracle Database Tutorial

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

Start my 1-month free trial

Manual backup of control files and archived logs

“

- [Instructor] In addition to performing online backups of your database data files as we did in our previous video, you will also need to take a backup of the database control file. To do that, we need to connect to the root container, so we'll type quit, open SQL Plus again, as assisted BA user, connect into the root container. You can verify that by typing show con_name, and run the older database backup control file and a destination where we want oracle to create a control file backup. You can can find this command included in your exercise file, so let's copy this command and paste it to our SQL Plus window. Pressing enter, we'll initiate a backup of the control file and store it in the following path. You can of course change this path to whatever is appropriate in your own environment. Remember to keep these control file backup safe as you'll need it to recover a database. Remember that in a production or an environment the location to where you backup move your control file…

Contents