Re: HELP: problem restoring from cold backup

Why are you removing LOG files, only remove CONTROL files ! Here is an example of creating new control file:

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "TEST01" RESETLOGS NOARCHIVELOG     MAXLOGFILES 254
    MAXLOGMEMBERS 2
    MAXDATAFILES 1022
    MAXINSTANCES 1
    MAXLOGHISTORY 680
LOGFILE
  GROUP 1 (
    '/d01/oradata/TEST01/redo1G1.dbf',
    '/d04/oradata/TEST01/redo2G1.dbf'
  ) SIZE 5M,
  GROUP 2 (
    '/d01/oradata/TEST01/redo1G2.dbf',
    '/d04/oradata/TEST01/redo2G2.dbf'
  ) SIZE 5M
DATAFILE
'/d04/oradata/TEST01/system01.dbf',
'/d02/oradata/TEST01/rbs01.dbf',
'/d05/oradata/TEST01/tools01.DBF',
'/d05/oradata/TEST01/users01.DBF',
'/d05/oradata/TEST01/temp01.DBF',
'/d05/oradata/TEST01/interim01.DBF',
'/d05/oradata/TEST01/find01.dbf',
'/d05/oradata/TEST01/gld01.dbf',
'/d05/oradata/TEST01/apd01.dbf',
'/d05/oradata/TEST01/ard01.dbf',
'/d05/oradata/TEST01/pod01.dbf',
'/d05/oradata/TEST01/invd01.dbf',
'/d05/oradata/TEST01/oed01.dbf',
'/d05/oradata/TEST01/bomd01.dbf',
'/d05/oradata/TEST01/mrpd01.dbf',
'/d05/oradata/TEST01/wipd01.dbf',
'/d05/oradata/TEST01/applsys01.dbf',
'/d05/oradata/TEST01/asd01.dbf',
'/d05/oradata/TEST01/ced01.dbf',
'/d05/oradata/TEST01/csd01.dbf',
'/d05/oradata/TEST01/ecd01.dbf',
'/d05/oradata/TEST01/fad01.dbf',
'/d03/oradata/TEST01/finx01.dbf',
'/d03/oradata/TEST01/glx01.dbf',
'/d03/oradata/TEST01/apx01.dbf',
'/d01/oradata/TEST01/arx01.dbf',
'/d01/oradata/TEST01/arx02.dbf',
'/d01/oradata/TEST01/pox01.dbf',
'/d03/oradata/TEST01/invx01.dbf',
'/d02/oradata/TEST01/oex01.dbf',
'/d03/oradata/TEST01/oex02.dbf',
'/d01/oradata/TEST01/bomx01.dbf',
'/d01/oradata/TEST01/mrpx01.dbf',
'/d01/oradata/TEST01/wipx01.dbf',
'/d01/oradata/TEST01/applsysx01.dbf',
'/d01/oradata/TEST01/asx01.dbf',
'/d01/oradata/TEST01/cex01.dbf',
'/d01/oradata/TEST01/csx01.dbf',
'/d01/oradata/TEST01/ecx01.dbf',
'/d01/oradata/TEST01/fax01.dbf',
'/d05/oradata/TEST01/ctxd01.dbf'

;
ALTER DATABASE OPEN; Vitaliy Mogilevskiy

ichwan.rachmat_at_creditlyonnais.fr wrote:

> 5. Remove control (*.ctl) files and log (log*.dbf) files in this directory Received on Thu Mar 25 1999 - 13:18:56 CST