Home
All Oracle Error Codes
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

RE: Production DB Crash Recovery process - Some immediate advice ASAP pls

VIVEK_SHARMA

2006-02-12

Replies:

DATABASE is UP & OPEN Hemant, Jeremiah.

Thanks indeed for all the Support

It was a Case of 1 Datafile NOT being in sync with the rest of Database.
This had been added after the Last HOT backup(being used in recovery).

This File was made OFFLINE & DB was opened on completion of recovery.

Thanks again Folks for responding ever so quickly.

Good Wishes

Vivek

P.S. Hemant, if you in SG? I am in Bangalore & can meet, if you come by
sometime. Jeremiah, I assume is in Seattle but nevertheless very welcome
to come to Bangalore.


-----Original Message-----
From: Hemant K Chitale [mailto:hkchital@(protected)]
Sent: Sunday, February 12, 2006 12:03 PM
To: VIVEK_SHARMA; Oracle-L
Subject: RE: Production DB Crash Recovery process - Some immediate
advice ASAP pls


A) If this was an online backup and you are attempting to recover the
whole database
AND the *last* END BACKUP in that backup set was *after* 6pm of 11-Feb,
then Oracle would still want recovery.

B) If you are using the *current* controlfile or any controlfile whose
timestamp
is *after* 6pm of 11-Feb, then Oracle would still want recovery.

C) If any of the datafiles on disk that you are applying recovery to is
*after* 6pm of 11-Feb,
then Oracle would still want recovery.

If you've received ORA-1194 when attempting to OPEN, that doesn't mean
that
you cannot continue with that backup.
1. Identify the actual datafiles that you need in that backup set.
2. RECREATE the Controlfile (with a CREATE CONTROLFILE sql -- even if
generated
from the current image of the controfile, you can exclude the newer
files
(ie those *after* 6pm of 11-Feb)
from the script.
3. Use RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
4. Issue CANCEL at the last ArchiveLog you want to apply
5. Issue an ALTER DATABASE OPEN RESETLOGS

Note : IF  A) or C) above applies to your case, you should be
restoring
from an *OLDER* backup.

Hemant

At 01:34 PM Sunday, VIVEK_SHARMA wrote:



-----Original Message-----
From: Jeremiah Wilton [mailto:jeremiah@(protected)]
Sent: Sunday, February 12, 2006 11:28 AM
To: VIVEK_SHARMA; 'Oracle-L'
Subject: RE: Production DB Crash Recovery process - Some immediate
advice ASAP pls
Importance: Low

If you are using a backup controlfile, then you should let create the
new
datafiles when it comes to that point in the redologs. You should not
use
the datafiles that are consistent with the CURRENT point in time, if you
are
trying to recover the whole database to a point in time in the PAST.

Do the new datafiles appear in v$datafile?

What do the recovery SCNs look like in v$recover_file? Find the high
SAN
values in this view to find which datafiles are out of sync in the
recovery.

Jeremiah Wilton
ORA-600 Consulting
Recoveries - Seminars - Hiring
http://www.ora-600.net


>Could ORA1194 be due to some Datafiles having being ADDED AFTER the
LAST
>Cold backup of 10 Feb 2006, BUT Before occurrence of the CRASH around 6
>pm on 11 Feb 2006, which continue to exist in the respective
Directories
>during the recovery process?
>
>
>Qs How can we identify these Datafiles which are NOT in sync with the
>rest of the Database files after getting ORA1194 when attempting to
open
>the Databse?
>
>Qs Should we consider removing Such Files, if there, before
>RE-initiating the CANCEL based recovery process again?
>
>Reference is to the following Article:-
>
>http://www.orafaq.com/usenet/comp.databases.oracle.server/2003/08/20/17
6
>0.htm
>
>Thanks indeed
>


Hemant K Chitale
http://web.singnet.com.sg/~hkchital



**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
http://www.freelists.org/webpage/oracle-l