OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN recovery (10.1.0.4 DB on RHEL 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN recovery [message #508522]

Sun, 22 May 2011 17:55

oradba888
Messages: 3
Registered: May 2011
Location: California

Junior Member

Hi All,

Have this issue.

1). Trying to do a restore/recover using RMAN.
2). Run into this error:

unable to find archive log
archive log thread=1 sequence=33983
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/22/2011 15:14:52
RMAN-06054: media recovery requesting unknown log: thread 1 seq 33983 lowscn 10861639555267

3). From SQLPLUS trying to do user managed recovery:

SQL> recover database using backup controlfile until time '21-05-2011 20:55:00';
ORA-01861: literal does not match format string

SQL> recover database until time to_date ('2011-05-21:20:55:00','YYYY-MM-DD:HH24:MI:SS');
ORA-00285: TIME not given as a string constant

here is a list of backups:

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
329 Full 4G DISK 00:10:17 19-MAY-11
BP Key: 329 Status: AVAILABLE Compressed: YES Tag: TAG20110519T200006
Piece Name: /u01/oracle/backup/patriadb_aamcoc27_1_1
List of Datafiles in backup set 329
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 10861638181175 19-MAY-11 /u01/oracle/oradata/patriadb/system01.dbf
2 Full 10861638181175 19-MAY-11 /u01/oracle/oradata/patriadb/undotbs01.dbf
3 Full 10861638181175 19-MAY-11 /u01/oracle/oradata/patriadb/sysaux01.dbf
4 Full 10861638181175 19-MAY-11 /u01/oracle/oradata/patriadb/users01.dbf
5 Full 10861638181175 19-MAY-11 /u01/oracle/oradata/patriadb/dcm.dbf
6 Full 10861638181175 19-MAY-11 /u01/oracle/oradata/patriadb/portal.dbf
7 Full 10861638181175 19-MAY-11 /u01/oracle/oradata/patriadb/ptldoc.dbf

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
331 78M DISK 00:00:11 19-MAY-11
BP Key: 331 Status: AVAILABLE Compressed: YES Tag: TAG20110519T201035
Piece Name: /u01/oracle/backup/patriadb_acmcocls_1_1

List of Archived Logs in backup set 331
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 33459 10861638096057 18-MAY-11 10861638099989 18-MAY-11
1 33460 10861638099989 18-MAY-11 10861638110311 18-MAY-11
1 33461 10861638110311 18-MAY-11 10861638115220 18-MAY-11
1 33462 10861638115220 18-MAY-11 10861638117748 18-MAY-11
1 33463 10861638117748 18-MAY-11 10861638129894 19-MAY-11
1 33464 10861638129894 19-MAY-11 10861638142315 19-MAY-11

any ideas are appreciated...

Report message to a moderator