Applying archive logs to a cold backup
742842Sep 4 2010 — edited Sep 7 2010Hello 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.