Re: Backup & Recovery Scenario..

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 29 Aug 2000 08:05:53 -0400
Message-Id: <10603.115718@fatcity.com>

If I follow your scenario and you want to end up with step 5 completed = after the restore you can restore the database from tape and apply the = archivelogs to bring you to the step you want. ROR
>>> yangken_at_cbn.net.id 08/29/00 06:00AM >>>
Dear lister,

This is my second mail today. Right now I am doing backup & recovery = testing.
Suppose I have database condition like this:

1. Full backup of database (cold backup) and copy to tape
2. Create table A and insert records
3. Create table B and insert records
4. Hot backup of database
5. Drop table A

And after the 5th condition, I do the backup & recovery testing with = several
scenarios. So, recovery will be taken from condition no 4. What I want to know is can we recover from the 1st condition again ? If = yes, can
I just
1. shutdown the database
2. copy the datafiles, controlfile, initfile, password file from tape to = the
original location
3. startup the database again ?

I am using Windows NT 4.0 and Oracle 8.0.5. Forgive me for my 'beginner' question. Thank you.

Regards,

Slamet Fusianto

--=20
Author: Slamet Fusianto
  INET: yangken_at_cbn.net.id=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 29 2000 - 07:05:53 CDT