Recover from a deleted System datafile?

From: Greg Akins <gakins_at_gatewayhealthplan.com>
Date: 4 Dec 2001 06:30:53 -0800
Message-ID: <cf62a659.0112040630.6f40fc4@posting.google.com>

Hello,

I just started developing a backup/recovery routine. I'm pretty new to this so forgive my stupid mistakes.

The backup is a hot backup. I take tablespaces offline, copy them and put them back online. I keep copies of all the archive logs from start of backup up until current.

Testing a deleted System datafile.

I delete the datafile
Try to start database <bombs!>
Copy the backup system datafile and start mount. When I issue $svrmgr> recover database until cancel ; recover starts asking for archive logs up until '3017' which causes the recovery to fail because that archive log was never created. It's not in the backup area, or the current log destination.

What am I doing wrong here?

-greg Received on Tue Dec 04 2001 - 08:30:53 CST