RMAN getting error ORA-01861: literal does not match format string
819348Nov 30 2010 — edited Nov 30 2010Hello Oracle experts,
I getting the error ORA-01861 on restore with rman.
I ready any posts about this erros but I can't to fix it.
I'm running 10.2.0.3 Solaris 10 x86-64
Please, Does they have any idea ?
[oracle@olapdti ~]$NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
[oracle@olapdti ~]$export NLS_LANG
[oracle@olapdti ~]$NLS_DATE_FORMAT="Mon DD YYYY HH24:MI:SS"
[oracle@olapdti ~]$export NLS_DATE_FORMAT
[oracle@olapdti ~]$export ORACLE_SID=dbprd11
[oracle@olapdti ~]$rman target / nocatalog
Recovery Manager: Release 10.2.0.3.0 - Production on Tue Nov 30 09:59:23 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount pfile='$ORACLE_HOME/dbs/initdbprd11.ora';
Oracle instance started
Total System Global Area 6291456000 bytes
Fixed Size 2082048 bytes
Variable Size 1073744640 bytes
Database Buffers 5200936960 bytes
Redo Buffers 14692352 bytes
RMAN> restore controlfile from '/u02/prd1/c-2784746309-20101127-00';
Starting restore at Nov 30 2010 09:59:44
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=871 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
output filename=+DADOS/dbprd1/controlfile/current.276.736423193
Finished restore at Nov 30 2010 09:59:53
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> catalog start with '/u02/prd1';
RMAN> run
2> {
3> SET UNTIL Time 'Nov 26 2010 18:30:13';
4> RESTORE DATABASE SKIP TABLESPACE TBSD_CAF_PD
5> ,TBSD_DOC
6> ,TBSD_GW_SYBASE
7> ,TBSD_HORDE
8> ,TBSD_REQPRO
9> ,TBSD_SCD
10> ,TBSD_SCS
11> ,TBSD_SEF
12> ,TBSD_SIAFEM
13> ,TBSD_SRM
14> ,TBSL_HORDE
15> ,TBSL_SEF
16> ,TBSD_SINTSERPRO
17> ,TBSD_SAP
18> ,TBSD_COLETA
19> ,TBSD_PPDIPVA
20> ,TBSD_FACMUTUO
21> ,TBSD_ITCMD
22> ,TBSD_AUDIT
23> ,TBSD_SCA
24> ,TBSD_EMS
25> ,TBSD_TIBADM
26> ,TBSD_IPROCESS
27> ,TBSD_SPOTFIRE_DATA
28> ,SPOTFIRE_TEMP
29> ,TBSD_BAM
30> ,TBSD_GED
31> ,TBSD_SSD
32> ,TBSD_SDD;
33> RECOVER DATABASE;
34> }
executing command: SET until clause
Starting restore at Nov 30 2010 10:00:31
using channel ORA_DISK_1
using channel ORA_DISK_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/30/2010 10:00:35
ORA-01861: literal does not match format string