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.

Requirements for PITR

Requirements for PITR - Oracle Database Tutorial

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

Start my 1-month free trial

Requirements for PITR

“

- [Instructor] In order for us to be able and perform point-in-time-recovery, using a combination of database backups and database archived read logs, there's several prerequisites and configuration options we need to configure. Firs of all in order for archived read logs to be generated in the first place, we need to make sure our Oracle database is set to ARCHIVELOG mode. You can do that by shutting down your database, starting it up in mount mode, and running the alter database archivelog command. Following that you can open your database using the alter database open command and your database will now generated archived read logs. This can also be configured during database creation. Most if not all production Oracle databases are presumably running with the archived log mode option enabled. By default archived read logs will be stored in the directory, specified via the db_recovery_file_dest parameter. You can also specify a maximum allowed size of your archived read logs using…

Contents