RE: problem with recovery
- From: "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 22 Aug 2004 13:49:45 -0400
When I give the recovery the name of the online
file, it gets:
ORA-353 Log curruption near block 81=20
----
Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx
If C gives you engouth rope to hang yourself, then C++ gives
you enough rope to hang yourself, your dog, your co-workers,
and everyone in your neighborhood.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mladen Gogala
Sent: Sunday, August 22, 2004 1:43 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: problem with recovery
On 08/22/2004 01:34:20 PM, "Adams, Matthew (GE Consumer & Industrial)" =
wrote:
> While all tablespaces were in backup mode,
> Oracle reported corruption in the controlfiles
> and crashed.=3D20
>=20
> A checksum of the controlfiles found them to be identical,=3D20
> so I re-created them. Then I took the datafiles out
> of backup mode.
>=20
> When I went to open the database, oracle tells me that
> the datafiles still need recovery, and that the archive
> file needed is sequence #15339. But this is the online
> redo logfile that was the current file at time of crash.
That is a standard stuff. Don't use autorecovery and when oracle asks
for archived redo log, you give the path name for the online redo
log file that contains the deseired information. You can get the=20
group number containining the desired change number from V$LOG
SQL> desc v$log
Name Null? Type
----------------------------------------- -------- =
---------------------------- GROUP# =
NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
MEMBERS NUMBER
ARCHIVED VARCHAR2(3)
STATUS VARCHAR2(16)
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
=20
and then get member pathname(s) from V$LOGFILE:
SQL> desc v$logfile
Name Null? Type
----------------------------------------- -------- =
---------------------------- GROUP# =
NUMBER
STATUS VARCHAR2(7)
TYPE VARCHAR2(7)
MEMBER VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
=20
The command to start recovery with would be:
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
I've seen database ask for the SCNs in the online logfiles quite a few =
times.
No big deal.
--=20
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
