.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
can 't open database after restore

can 't open database after restore

2005-12-14       - By Drake Emko
Reply:     1     2  

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 (See ORA-01152.ora-code.com): file 1 was not restored from a sufficiently old backup
ORA-01110 (See ORA-01110.ora-code.com): data file 1: '/usr/local/oracle/oradata/webct/system01.dbf'

SQL> recover datafile '/usr/local/oracle/oradata/webct/system01.dbf';
ORA-00283 (See ORA-00283.ora-code.com): recovery session canceled due to errors
ORA-01610 (See ORA-01610.ora-code.com): recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile;
ORA-00279 (See ORA-00279.ora-code.com): change 813300829 generated at 12/07/2005 01:00:05 needed for
thread
1
ORA-00289 (See ORA-00289.ora-code.com): suggestion :
/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc
ORA-00280 (See ORA-00280.ora-code.com): change 813300829 for thread 1 is in sequence #11702

SQL> recover database until cancel using backup controlfile;
ORA-00279 (See ORA-00279.ora-code.com): change 813300829 generated at 12/07/2005 01:00:05 needed for
thread
1
ORA-00289 (See ORA-00289.ora-code.com): suggestion :
/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc
ORA-00280 (See ORA-00280.ora-code.com): change 813300829 for thread 1 is in sequence #11702

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01152 (See ORA-01152.ora-code.com): file 1 was not restored from a sufficiently old backup
ORA-01110 (See ORA-01110.ora-code.com): data file 1: '/usr/local/oracle/oradata/webct/system01.dbf'

ORA-01112 (See ORA-01112.ora-code.com): media recovery not started

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308 (See ORA-00308.ora-code.com): cannot open archived log
'/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc'
ORA-27037 (See ORA-27037.ora-code.com): unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


Thanks for any help you can offer!
--
http://www.freelists.org/webpage/oracle-l