Restoring database
Date: Thu, 25 Apr 2002 08:06:50 -0400
Message-ID: <Pine.LNX.4.33.0204250800250.22006-100000_at_tarpon.exis.net>
Hello,
I'm trying to restore a cold copy of my database and I've run into a
problem (which I'm sure is easy to fix.. I hope). All the guides I read on
doing this show the archive log's automaticly applying or have a prompt
(sugguested, auto, etc). What command do I need to do to make it apply my
log? I don't have an auto/suggested promp and hitting enter does nothing.
(which is what he guide I read suggested... hit enter until you can
cancele). if I do alter database recover cancel, it says :
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u03/oradata/gold/system01.dbf'
Not sure what to do at this point.
I'll past my session below:
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> _at_/test.ctl
ORACLE instance started.
Total System Global Area 123354640 bytes Fixed Size 48656 bytes Variable Size 44482560 bytes Database Buffers 78643200 bytes Redo Buffers 180224 bytesStatement processed.
SVRMGR> SVRMGR> alter database recover database until cancel using backup controlfile;
alter database recover database until cancel using backup controlfile *
ORA-00279: change 17960182 generated at 04/23/02 21:01:21 needed for thread 1
ORA-00289: suggestion : /u06/oracle/admin/gold/arch13729_1.dbf ORA-00280: change 17960182 for thread 1 is in sequence #13729 SVRMGR> Received on Thu Apr 25 2002 - 14:06:50 CEST