Recuperacion de Datos
Publicado por Louis (2 intervenciones) el 08/01/2008 19:10:42
Estoy tratando de realizar una recuperación de los datos en un punto en el tiempo, al realizar el Restore todo funciona bien, pero al momento de hacer el Recover obtengo un error.
Alguien podría decirme el motivo y ayudarme??
Nota: Al realizar la recuperación al dia si obtengo un resultado satisfactorio.
El siguiente es el error...
RMAN> run {
2> restore database until time "to_date('2008-01-07 16:24:52', 'YYYY-MM-DD HH24:MI:SS')";
3> recover database until time "to_date('2008-01-07 16:24:52', 'YYYY-MM-DD HH24:MI:SS')";
4> }
Starting restore at 08-JAN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
skipping datafile 1; already restored to file /u01/data/ISCRATCH/ISCRATCH/system01.dbf
skipping datafile 2; already restored to file /u01/data/ISCRATCH/ISCRATCH/undotbs01.dbf
skipping datafile 3; already restored to file /u01/data/ISCRATCH/ISCRATCH/sysaux01.dbf
skipping datafile 4; already restored to file /u01/data/ISCRATCH/ISCRATCH/users01.dbf
skipping datafile 5; already restored to file /usr/amxw/v80510b12ISCRATCH/oratables/NEWLAB01
skipping datafile 6; already restored to file /usr/amxw/v80510b12ISCRATCH/oraindexes/NEWLAB02
skipping datafile 7; already restored to file /u01/data/ISCRATCH/ISCRATCH/ipmaq01
restore not done; all files readonly, offline, or already restored
Finished restore at 08-JAN-08
Starting recover at 08-JAN-08
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/08/2008 10:59:57
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'JAN 07 2008 16:24:52'
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
RMAN> exit;
Recovery Manager complete.
Gracias...
Alguien podría decirme el motivo y ayudarme??
Nota: Al realizar la recuperación al dia si obtengo un resultado satisfactorio.
El siguiente es el error...
RMAN> run {
2> restore database until time "to_date('2008-01-07 16:24:52', 'YYYY-MM-DD HH24:MI:SS')";
3> recover database until time "to_date('2008-01-07 16:24:52', 'YYYY-MM-DD HH24:MI:SS')";
4> }
Starting restore at 08-JAN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
skipping datafile 1; already restored to file /u01/data/ISCRATCH/ISCRATCH/system01.dbf
skipping datafile 2; already restored to file /u01/data/ISCRATCH/ISCRATCH/undotbs01.dbf
skipping datafile 3; already restored to file /u01/data/ISCRATCH/ISCRATCH/sysaux01.dbf
skipping datafile 4; already restored to file /u01/data/ISCRATCH/ISCRATCH/users01.dbf
skipping datafile 5; already restored to file /usr/amxw/v80510b12ISCRATCH/oratables/NEWLAB01
skipping datafile 6; already restored to file /usr/amxw/v80510b12ISCRATCH/oraindexes/NEWLAB02
skipping datafile 7; already restored to file /u01/data/ISCRATCH/ISCRATCH/ipmaq01
restore not done; all files readonly, offline, or already restored
Finished restore at 08-JAN-08
Starting recover at 08-JAN-08
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/08/2008 10:59:57
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'JAN 07 2008 16:24:52'
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
RMAN> exit;
Recovery Manager complete.
Gracias...
Valora esta pregunta


0