In the Backup Mode section, select either Online Backup or Offline Backup.
#ORACLE DATABASE BACKUP FULL#
In the Backup Type section, select Full Backup. In this page you specify the options for this whole database backup. The Schedule Customized Backup: Options page appears.
#ORACLE DATABASE BACKUP PASSWORD#
Make sure the Username and Password fields are correct in the Host Credentials section and then click Schedule Customized Backup. In the Customized Backup section, select Whole Database to make a full backup of your database immediately or schedule one as part of a user-designed backup strategy. The Customized Backup section, where you can schedule a one-time or repeated backup of database objects you select. The Oracle-Suggested Backup section, where you can click Schedule Oracle-Suggested Backup to choose among backup strategies recommended by the database The following sections of this page are important: The Oracle-Suggested Strategy for backups is based upon incrementally updated backups.ĭescription of "Figure 9-1 Schedule Backup Page" The reason is that media recovery to the present time or a point in time in the recent past can begin at the time of the last level 1 backup applied rather than the time of the last full database backup. Incorporating incrementally updated backups into your backup strategy shortens expected recovery times. The effect is to roll the file forward in time, so that its contents are equivalent, for the purposes of database recovery, to an image copy full datafile backup made at the time of the last incremental level 1 backup. All blocks changed since the image copy was created are overwritten with their new contents as of the time of the last level 1 incremental backup. You can roll the old copy forward to the point in time of the last level 1 incremental backup. The incrementally updated backups feature of Oracle lets you use one or more level 1 incremental backups with an older image copy backup of your datafiles. Incrementally Updated Backups: Rolling Forward Image Copies of Datafiles The redo logs are only used for changes from the period not covered by level 1 incremental backups.
#ORACLE DATABASE BACKUP UPDATE#
Because an incremental level 1 backup captures the final contents of all datafile blocks changed during the period covered by the incremental, the recovery process can skip reapplying individual updates from the redo logs of that period and simply update each block with its final contents. Recovering changed blocks from incremental backups is used to improve media recovery performance. Level 1 backups can be cumulative, in which case all blocks changed since the most recent level 0 backup are included, or differential, in which case only those blocks changed since the most recent level 0 or level 1 incremental backup are included. Subsequent level 1 incremental backups, typically made at regular intervals such as once each day, capture images of each block in a datafile that changed. A level 0 backup captures all blocks in the datafile. In a typical incremental backup strategy, a level 0 incremental backup is used as a starting point. Incremental backups capture only those blocks that change between backups in each datafile.
0 kommentar(er)
