can't open database after restore
- From: Drake Emko <drakee@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Dec 2005 10:29:26 -0500
Hi everyone,
I have a large database that is used by our online learning software. At
some point a couple classes were deleted by an application
administrator. I have been trying to recover the classes by restoring
the entire database onto our test database server (different machine)
via RMAN, but have not been able to open the database once the
restore/recover is complete.
The restore seemed to go well, but the recover threw errors (unable to
find archive logs), which isn't surprising because no archivelogs could
be retrieved. I am running archivelog mode, and archivelogs are being
backed up, but the media manager can't find the particular logs that are
needed.
Is there any way to get the database running without having to apply
these missing logs?
My goal is just to have a working copy of the database. I don't care
about recovering to the latest point in time - I only want to be able
to start up the database so we can extract the data from the missing
classes.
Nothing I try seems successfully to open the database:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/usr/local/oracle/oradata/webct/system01.dbf'
SQL> recover datafile '/usr/local/oracle/oradata/webct/system01.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile;
ORA-00279: change 813300829 generated at 12/07/2005 01:00:05 needed for
thread
1
ORA-00289: suggestion :
/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc
ORA-00280: change 813300829 for thread 1 is in sequence #11702
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 813300829 generated at 12/07/2005 01:00:05 needed for
thread
1
ORA-00289: suggestion :
/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc
ORA-00280: change 813300829 for thread 1 is in sequence #11702
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/usr/local/oracle/oradata/webct/system01.dbf'
ORA-01112: media recovery not started
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Thanks for any help you can offer!
--
//www.freelists.org/webpage/oracle-l
Other related posts: