Dúvidas No Recovery

[brazaParticipante]

[quote=”braza”:2xn4rdrg][quote=”vieri”:2xn4rdrg]faltou o comando Swith datafile all

Example
Switching Datafile Filenames After a Restore: Example
This example allocates one disk device and one tape device to allow RMAN to restore both from disk and tape.

RUN
{
ALLOCATE CHANNEL dev1 DEVICE TYPE DISK RATE 1000;
ALLOCATE CHANNEL dev2 DEVICE TYPE sbt;
SQL “ALTER TABLESPACE tbs_1 OFFLINE IMMEDIATE”;
SET NEWNAME FOR DATAFILE ‘/disk7/oracle/tbs11.f’
TO ‘/disk9/oracle/tbs11.f’;
RESTORE TABLESPACE tbs_1;
SWITCH DATAFILE ALL;
RECOVER TABLESPACE tbs_1;
SQL “ALTER TABLESPACE tbs_1 ONLINE”;
}[/quote]

Ok Pessoal. Deu certo.

Valeu!!!![/quote]

Olha eu de novo!!!!

Fui fazer esse mesmo procedimento em um outro banco de dados e obtive a seguinte mensagem:

Starting recover at 13-APR-11
using channel ORA_DISK_1

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘F:ORACLE_10G_DADOSBD_AJURIAPLICACAO_AJURIDADOSSYST
EM01.DBF’

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/13/2011 09:27:15
RMAN-06561: available space must be larger than 1998808 kb

Como proceder agora ????