![]() ![]() The BACKUP INCREMENTAL line will perform a complete backup (level 0) the first day it is run, with all subsequent backups being level 1 incremental backups. line will not do anything until the script has been running for more than 7 days. ![]() RECOVER COPY OF DATABASE WITH TAG 'mydb_incr_backup' UNTIL TIME 'SYSDATE - 7' īACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'mydb_incr_backup' DATABASE The following example shows how this can be used. Using this feature, all changes between the SCN of the original image copy and the SCN of the incremental backup are applied to the image copy, winding it forward to make the equivalent of a new database image copy without the overhead of such a backup. The flashback technologies are covered in the Flashback New Features and Enhancements in Oracle Database 10g article. The following example shows the parameters used to configure the flash recovery area.ĪLTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 2G ĪLTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u01/app/oracle/flash_recovery_area' ĪLTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET = 1440 If there is not enough space to complete an operation obsolete, backed up or redundant files are removed to free up some space. ![]() Space within the flash recovery area is managed by the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |