Re: Is it possible to recover just one datafile/tablespace "until cancel"?

In <3F787827.EBBFA335_at_remove_spam.peasland.com> Brian Peasland <dba_at_remove_spam.peasland.com> writes:

>Yes...as I've stated in your other thread. Here are the steps:
 

>1. Restore datafile from backup
>2. STARTUP MOUNT
>3. RECOVER DATAFILE 'filename' UNTIL CACNEL;
>4. Apply logs and choose CANCEL at any time
>5. ALTER DATABASE OPEN RESETLOGS; (since you did incomplete recovery)
>6. Take a complete backup

Thanks!

I'll give that a try just as soon as my backup tape finisehs. I'm close enough to a working instance, that I think it is wise to take a snapshot (cold) of it.

Thanks, again!

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin