Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Backup Planning

G.B.Q.Mar 28 2006 — edited Mar 29 2006

Hi, Guys. Just need your comments on my backup plan changes.

Since my database is now too big, I would like to make daily tablespace backup instead of weekend whole database backup. Suppose I will backup like this:

Monday: SYSTEM + SYSAUX tablespace
Tudesday: APP_1
Wednesday: APP_2
Thursday: APP_3
Friday: APP_4
Staturday: APP_5
Sunday: APP_6

I configure the record keep time of control file to 8 days and backup archivelog for every backup. Delete obsolete on every backup. A few concerns here:

1 - I'm not able to do PITR to time before last tablespace backup, right?
2 - I need to restore evevery data file from backups to do PITR, right?
3 - UNDO tablespace (I configured a undo tablespace under auto-undo management option) is not backed-up since I assume it can be re-configure in mount state before doing recovery of datafiles, am I right?

Thanks for any inputs, again.
G.B.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2006

Added on Mar 28 2006

#performance-availability, #recovery-manager-rman

1 comment

360 views