Caros Amigos,
Consegui finalizar… nao foi 100% mas bem próximo
O datafile dados01 tem 59GB mas restaurou 53GB
Td bem, vou dar prosseguimento, depois vejo isso…
Meu script finaliza dessa forma
RESTORE DATABASE;
switch datafile all;
RECOVER DATABASE ;
ALTER DATABASE OPEN RESETLOGS;
E apareceu a seguinte msg:
Starting recover at 18-JAN-11
starting media recovery
archive log thread 1 sequence 7502 is already on disk as file /logs/redo_asoec10/redo9.log
archive log thread 1 sequence 7503 is already on disk as file /logs/redo_asoec10/redo2.log
archive log thread 1 sequence 7504 is already on disk as file /logs/redo_asoec10/redo3.log
archive log thread 1 sequence 7505 is already on disk as file /logs/redo_asoec10/redo4.log
archive log thread 1 sequence 7506 is already on disk as file /logs/redo_asoec10/redo5.log
archive log thread 1 sequence 7507 is already on disk as file /logs/redo_asoec10/redo6.log
archive log thread 1 sequence 7508 is already on disk as file /logs/redo_asoec10/redo1.log
archive log thread 1 sequence 7509 is already on disk as file /logs/redo_asoec10/redo7.log
archive log thread 1 sequence 7510 is already on disk as file /logs/redo_asoec10/redo8.log
unable to find archive log
archive log thread=1 sequence=1
released channel: C1
released channel: C2
released channel: C3
released channel: C4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/18/2011 16:06:26
RMAN-06054: media recovery requesting unknown log: thread 1 seq 1 lowscn 536781
Ao tentar o ALTER DATABASE OPEN;
SQL> ALTER DATABASE OPEN;
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
E ao tentar novamente o RESETLOGS;
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘/u01/app/oracle/oradata/asoec10/system01.dbf’
Acho que agora falta pouco…
mpvargas.
mpvargas.
CleitonHanzen
CleitonHanzen
mpvargas