oracle 9i -RMAN-20201 datafile not found in the recovery catalog:

Certo dia tivemos um problema com uma tablespace de dados que nao estava mais no catalogo do RMAN, ao verificarmos a mesma  tinha sido deletada e  ao tentar  restaurar apenas o backup full:
#restaurando o backup full
shutdown immediate;

startup nomount;

alter database mount;

run{
set newname for datafile 1 to 'D:\oracle_novo\ora90\oradata\brasil\system01.dbf';
 set newname for datafile 2 to 'D:\oracle_novo\ora90\oradata\brasil\undotbs01.dbf';
 set newname for datafile 3 to 'D:\oracle_novo\ora90\oradata\brasil\cwmlite01.dbf';
 set newname for datafile 4 to 'D:\oracle_novo\ora90\oradata\brasil\drsys01.dbf';
 set newname for datafile 5 to 'D:\oracle_novo\ora90\oradata\brasil\example01.dbf';
 set newname for datafile 6 to 'D:\oracle_novo\ora90\oradata\brasil\indx01.dbf';
 set newname for datafile 7 to 'D:\oracle_novo\ora90\oradata\brasil\tools01.dbf';
 set newname for datafile 8 to 'D:\oracle_novo\ora90\oradata\brasil\users01.dbf';
set newname for datafile 9 to 'D:\oracle_novo\ora90\oradata\brasil\tbs_dados_01.dbf';
set newname for datafile 10 to 'D:\oracle_novo\ora90\oradata\brasil\tbs_dados_02.dbf';

 SET UNTIL SCN 268118;
 RESTORE DATABASE;
 SWITCH DATAFILE ALL;
 RECOVER DATABASE;
 }

Apareceu a mensagem de erro:
RMAN-20201 datafile not found in the recovery catalog.
RMAN-06010 error while looking up datafile 9

Ao fazer a busca pelo backups verificamos que a tablespace deletada estava sendo encontrada:

alter database open;

RMAN> list backup;

irá apresentar a saida abaixo:


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
32 Full 525.67M DISK 00:01:31 06-MAY-08
BP Key: 33 Status: AVAILABLE Compressed: NO Tag: TAG20080506T150716
Piece Name: /oradata2/o1_mf_nnndf_TAG20080506T150716_421c355f_.bkp
List of Datafiles in backup set 32
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\system01.dbf'
2 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\undotbs01.dbf
3 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\cwmlite01.dbf
4 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\drsys01.dbf
5 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\example01.dbf
6 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\indx01.dbf
7 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\tools01.dbf
8 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\users01.dbf
9 Full 268118 27-08-10
10 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\tbs_dados_02.dbf


Para resolver esse problema foi necessário primeiro restaurar o controlfile do ultimo bkp full.

shutdown immediate;

startup nomount;

restore controlfile from 'd:\oracle_novo\backup\testebkpfullcomnfe_300810.bkp';

shutdown immediate;


startup nomount;


alter database mount;

alter database open resetlogs;

RMAN> list backup;

irá apresentar a saida abaixo:


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
32 Full 525.67M DISK 00:01:31 06-MAY-08
BP Key: 33 Status: AVAILABLE Compressed: NO Tag: TAG20080506T150716
Piece Name: /oradata2/o1_mf_nnndf_TAG20080506T150716_421c355f_.bkp
List of Datafiles in backup set 32
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\system01.dbf'
2 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\undotbs01.dbf
3 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\cwmlite01.dbf
4 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\drsys01.dbf
5 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\example01.dbf
6 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\indx01.dbf
7 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\tools01.dbf
8 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\users01.dbf
9 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\tbs_dados_01.dbf
10 Full 268118 27-08-10 D:\oracle_novo\ora90\oradata\brasil\tbs_dados_02.dbf

shutdown immediate;

startup nomount;

alter database mount;

run{
set newname for datafile 1 to 'D:\oracle_novo\ora90\oradata\brasil\system01.dbf';
 set newname for datafile 2 to 'D:\oracle_novo\ora90\oradata\brasil\undotbs01.dbf';
 set newname for datafile 3 to 'D:\oracle_novo\ora90\oradata\brasil\cwmlite01.dbf';
 set newname for datafile 4 to 'D:\oracle_novo\ora90\oradata\brasil\drsys01.dbf';
 set newname for datafile 5 to 'D:\oracle_novo\ora90\oradata\brasil\example01.dbf';
 set newname for datafile 6 to 'D:\oracle_novo\ora90\oradata\brasil\indx01.dbf';
 set newname for datafile 7 to 'D:\oracle_novo\ora90\oradata\brasil\tools01.dbf';
 set newname for datafile 8 to 'D:\oracle_novo\ora90\oradata\brasil\users01.dbf';
set newname for datafile 9 to 'D:\oracle_novo\ora90\oradata\brasil\tbs_dados_01.dbf';
set newname for datafile 10 to 'D:\oracle_novo\ora90\oradata\brasil\tbs_dados_02.dbf';

 SET UNTIL SCN 268118;
 RESTORE DATABASE;
 SWITCH DATAFILE ALL;
 RECOVER DATABASE;
 }

alter database open resetlogs;

Oracle Error :: RMAN-20208- erro ao restaurar backup full.

Ao tentar restaurar um backup full no oracle 9i, me deparei com o seguinte erro:

Oracle Error :: RMAN-20208-  UNTIL CHANGE is before RESETLOGS change
Que foi resolvido apos fazer um restore apenas do controlfile e após isso fazer um restore full do banco que já foi mostrado anteriormente no  blog, clique nos links acima para acessar os textos.

Oracle 9i - Restaurando o controlfile de um backup full

Oracle 9i - Restaurando o controlfile de um backup full
rman

connect target /

shutdown immediate;

startup nomount;

restore controlfile from 'd:\oracle_novo\backup\testebkpfullcomnfe_300810.bkp';

shutdown immediate;

startup nomount;


alter database mount;

alter database open resetlogs;