Re: backup question
From: Annie STECZYCKI <armoni_at_club-internet.fr>
Date: Mon, 29 Jan 2001 13:20:54 +0100
Message-ID: <953nb1$iet$1_at_front1m.grolier.fr>
Date: Mon, 29 Jan 2001 13:20:54 +0100
Message-ID: <953nb1$iet$1_at_front1m.grolier.fr>
Sorry for my english, but i try to give you some answers:
If your system crash and you are not in "archivelog mode":
- 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
- 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 - 13:20:54 CET