 | | | recovery error | recovery error 2004-07-13 - By Mike Hennesy
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 (See ORA-01589.ora-code.com): 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
-- ---- ---- ---- ---- ---- -----
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|