1 |
Start SQL*Plus, and connect with administrator privileges to the database. |
1 |
Start SQL*Plus, and connect with administrator privileges to the database. |
3 |
Optionally, set the DB_FLASHBACK_RETENTION_TARGET to the length of the desired flashback window in minutes. |
IMPORTANT: Because it introduces minimal performance overhead on the database during normal operations, Block Change Tracking is disabled by default on Oracle 10g and later. However, the benefits of avoiding full datafile scans during Incremental Backups are considerable, especially if only a small percentage of data blocks are changed between backups. For more information on Incremental Backups and change tracking, refer to Improving Incremental Backup Performance Change Tracking in the Oracle Database Backup and Recovery Basics guide. |
1 |
Start SQL*Plus, and connect with administrator privileges to the target database. |
• |
To store it in the default location: |
• |
Set the DB_CREATE_FILE_DEST parameter for the target database. |
• |
To store it in a user-defined location, issue the following SQL statement: |
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center