Re: backup question

Sorry for my english, but i try to give you some answers:

If your system crash and you are not in "archivelog mode":

1. With your export.dmp: remove all the database's datafiles (files,control,redo ...) re-create your database (CREATE DATABASE ....) execute catalog.sql and catproc.sql import full in your new database startup the database
2. If you have backed-up the database's datafiles (files,control,redo ...) after database shutdown: remove all the database's datafiles (files,control,redo ...) copy the datafiles from tape to their initial places on your disk startup the database

However if your database is in "archivelog mode" , the statement 2 is good but you don't have to try to startup the database in normal mode, but you have to use a recover way :

startup mount pfile=....;
recover database until cancel using backup controlfile; alter database open resetlogs;

But the recover's subject is very large and depends on what you have and also depends that there was no controlfile'modifications since the backup....

See your doc or send a contract <vbg>

Annie STECZYCKI from FRANCE Received on Mon Jan 29 2001 - 06:20:54 CST