DB recover until return RMAN-03999: : ORA-01801:
Hello,
OS: Linux 2.4.21-37.ELsmp and
ORACLE 10.2.0
I got a problem by recover my DB until time "to date. Where can i check the wrong DATE format is defined ?
could you please help me to complete the recover ?
If you need more info please let me know.
many thanks
Giorgio
<!-- @page { margin: 2cm } PRE { font-family: "Times New Roman" } P { margin-bottom: 0.21cm } --> <!-- @page { margin: 2cm } PRE { font-family: "Times New Roman" } P { margin-bottom: 0.21cm } -->
OS: Linux 2.4.21-37.ELsmp and
ORACLE 10.2.0
I got a problem by recover my DB until time "to date. Where can i check the wrong DATE format is defined ?
could you please help me to complete the recover ?
If you need more info please let me know.
many thanks
Giorgio
<!-- @page { margin: 2cm } PRE { font-family: "Times New Roman" } P { margin-bottom: 0.21cm } --> <!-- @page { margin: 2cm } PRE { font-family: "Times New Roman" } P { margin-bottom: 0.21cm } -->
Recovery Manager: Release 10.2.0.4.0 - Production on Ven. Août 31 11:08:29 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target
connected to target database: IGS (DBID=1039639150, not open)
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=IGS,OB2BARLIST=IGS-OracleFullBackupDB)';
3> set until time "to_date('2012-08-30:16:15:00','YYYY-MM-DD:HH24:MI:SS')";
4> restore database;
5> recover database;
6> }
using target database control file instead of recovery catalog
allocated channel: dev_0
channel dev_0: sid=159 devtype=SBT_TAPE
channel dev_0: Data Protector A.06.10/611
executing command: SET until clause
Starting restore at Août 31 2012 11:14:16
skipping datafile 1; already restored to file /opt/oracle/oradata/IGS/system01.dbf
skipping datafile 3; already restored to file /opt/oracle/oradata/IGS/sysaux01.dbf
skipping datafile 8; already restored to file /opt/oracle/oradata/IGS/fdbindex.dbf
skipping datafile 4; already restored 0