|
-
First you need to create a file that will track changed blocks. Otherwise your incremental/differential backups will be much larger then they need to be.
Code:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
USING FILE '/oracle/oradata/sidname/block_change_tracking.dbf';
I think by generic, vnktummala meant that they are commands that anyone could use, however, your environment might require different options/commands. If you backup to the flash recovery area the commands will be very simple, but you need to make sure that the flash recovery is configured properly. Meaning that you have the right retention and enough space allocated both at the os level and in the database.
Also using a repository can be helpful. Think about retention, if you set the retention policy to 1 week, you will have one weeks worth of backups in the repository. If you set it longer, then "delete noprompt obsolete;" will leave additional backup on disk, probably beyond what you want. Just my 2 cents.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|