Home » RDBMS Server » Backup & Recovery » RMAN recovery (10.1.0.4 DB on RHEL 4)
RMAN recovery [message #508522] Sun, 22 May 2011 17:55 Go to next message
oradba888
Messages: 2
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...



Re: RMAN recovery [message #508527 is a reply to message #508522] Mon, 23 May 2011 00:03 Go to previous messageGo to next message
John Watson
Messages: 4417
Registered: January 2010
Location: Global Village
Senior Member
Quote:
SQL> recover database using backup controlfile until time '21-05-2011 20:55:00';
ORA-01861: literal does not match format string


Your tme format must be 'YYYY-MM-DD:HH24:MI:SS'.
Re: RMAN recovery [message #508528 is a reply to message #508527] Mon, 23 May 2011 00:04 Go to previous message
oradba888
Messages: 2
Registered: May 2011
Location: California
Junior Member
Thanks..
I finally resolved this issue by setting the incarnation back to the parent and re-running restore/recover.

regards
Previous Topic: Flash Recovery Area 9i
Next Topic: copy database to newlocation
Goto Forum:
  


Current Time: Sat Aug 02 00:30:13 CDT 2014

Total time taken to generate the page: 0.12014 seconds