Skip to Main Content

Oracle Database Discussions

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!

Applying archive logs to a cold backup

742842Sep 4 2010 — edited Sep 7 2010
Hello all,

One of my clients does a cold backup every Sunday without using RMAN. The database runs in archive log mode. They have set up a shell script that shuts down the database, then copies all data files, control files and online redo logs to a different location on disk.

Let's assume that we lose all data files/control and redo files on Wednesday. To get the database back online we copy the data files/control and redo from the backup location and start it up. The database is now open and is current as of Sunday. Is there a way to roll forward by applying Monday's and Tuesday' archive logs to the database? I know this is not possible as the database becomes consistent once we start up the database as it's a cold backup but just wanted to get your input to find out if there is a way that I'm not aware of to be able to achieve this.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2010
Added on Sep 4 2010
8 comments
2,012 views