Re: recovery error

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 14 Jul 2004 23:08:10 +0800
Message-Id: <6.1.0.6.0.20040714230237.0245ddb8@pop.singnet.com.sg>

I presume that you included all the datafiles of the database in your CREATE CONTROLFILE ? If not, you are trying to recover only some datafiles. If the files being recovered have no transactions to be applied, then the recovery would not do much -- ie, when recovering, it would read the archive logs, match them against the files being recovered and if the archive logs have no transactions for these files would not write back from the archivelogs to the files.
As you are doing a time-based recovery, you are doing an incomplete recovery. You MUST issue an ALTER DATABASE OPEN RESETLOGS. Have you tried issuing the command ? If any files are inconsistent, you would get an error there.
I don't see why you attempted an ARCHIVELOG ALL. What files are you archiving out ? A RESETLOGS would clear your online redo logs and reset the Log Sequence Number to 0.

Your email :

I just had this dropped on my desk. Oracle 8.1.7.3 . The objective was to restore a backup of PRD on a different host and recover from the 6/30 5:00 AM backup until 7/1 at 4:30 AM.

I was told that the media recovery complete was almost instantaneous (didn't show processing of any archive logs, should have processed 15) and the ALTER SYSTEM ARCHIVE LOG ALL took about 45 seconds to complete.

The following file with datafiles removed was executed after connect internal.

STARTUP NOMOUNT pfile=/u01/app/oracle/admin/fin/pfile/initprd.ora CREATE CONTROLFILE REUSE DATABASE "PRD" NORESETLOGS ARCHIVELOG MAXLOGFILES 32
.
. datafiles
.

CHARACTER SET WE8ISO8859P1
;
recover database until time '2004-07-01:04:30:00'; ALTER SYSTEM ARCHIVE LOG ALL;
ALTER DATABASE OPEN; Produced the following.
ORACLE instance started.

Total System Global Area                        966713504 bytes
Fixed Size                                          73888 bytes
Variable Size                                   693010432 bytes
Database Buffers                                253952000 bytes
Redo Buffers                                     19677184 bytes

Statement processed.
SVRMGR> recover database until time '2004-07-01:04:30:00'; Media recovery complete.
SVRMGR> ALTER SYSTEM ARCHIVE LOG ALL;
Statement processed.
SVRMGR> ALTER DATABASE OPEN;
ALTER DATABASE OPEN
*
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

I have access to the backed up files so I can restore what I need to. I'm not sure why the archive logs weren't processed. If anyone can shed some light I'd appreciate it. Do I have to recover all the datafiles?

Thanks - Mike

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital
"A man's reputation is what other people think of him; his character is what he really is."

Miner, Jack

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 14 2004 - 10:12:21 CDT