Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> help on point in time recovery of a partition
I am trying to create a backup recovery strategy and would appreciate
comments.
The following is my configuration.
The system that I use is an online system with a batch window for each partition. (I.e. while a batch window is open for one partition all other partitions must be available for online work.).
I need to be able to perform forward recovery on any partition in the case of a media failure e.g. disk crash.
I also need to be able to recover a particular partition to a point in time. E.g. recover partition 1 to before last nights batch.
The recovery procedure should be automatic (e.g. the user will execute a script backrcvpart1 or forrcvpart1).
I am a DB2 DBA who is quite new to ORACLE.
From what I have read and tried the following is my conclusion
![]() |
![]() |