RMAN

[vieriParticipante]

Vamos lá:

diretórios:

drwxr-xr-x 3 oracle oinstall 8192 Jul 23 14:25 wis
chmod 777 /u03/wis
drwxrwxrwx 3 oracle oinstall 8192 Jul 23 14:25 wis

drwxrwx— 12 oracle oinstall 4096 Jul 21 13:35 u03
chmod 777 u03
drwxrwxrwx 12 oracle oinstall 4096 Jul 21 13:35 u03

está ok né ?

mesmo erro :

creating datafile fno=1 name=/u03/wis/system01.dbf
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 restore command at 07/23/2009 14:57:00
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘/u02/oracle/oradata/wis/system01.dbf’

crosscheck’s:

RMAN> CROSSCHECK backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

RMAN> CROSSCHECK backup of database;

using channel ORA_DISK_1

RMAN> CROSSCHECK backup of controlfile;

using channel ORA_DISK_1

RMAN> CROSSCHECK archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
specification does not match any archive log in the recovery catalog

Algo de errado com os archives, mas
será que tem have com esse erro ?

obs: Estou no modo nocatalog o crosschek faz a checagem com
o control file ?

Vou fazer o backup do archive levar para lá, e catalogar eles
e rodar o restore denovo… só por via de dúvidas.

continuando…

vamos catalogar:

RMAN> catalog backuppiece ‘/u03/wis/full_wis_692811273_2’;

using target database control file instead of recovery catalog
cataloged backuppiece
backup piece handle=/u03/wis/full_wis_692811273_2 recid=1 stamp=692982164

RMAN> catalog backuppiece ‘/u03/wis/full_wis_692814747_3’;

cataloged backuppiece
backup piece handle=/u03/wis/full_wis_692814747_3 recid=2 stamp=692982200

RMAN> catalog backuppiece ‘/u03/wis/full_wis_692824194_4’;

cataloged backuppiece
backup piece handle=/u03/wis/full_wis_692824194_4 recid=3 stamp=692982216

RMAN> list backup of database summary ;

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
——- — — – ———– ————— ——- ——- ———- —
2 B F A DISK 21-JUL-09 1 1 NO TAG20090721T163226

rodando novamente após essas mudanças!!

creating datafile fno=1 name=/u03/wis/system01.dbf
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 restore command at 07/23/2009 15:05:28
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘/u02/oracle/oradata/wis/system01.dbf’

mesmo erro !
Sei que estou fazendo algo errado mas quero saber aonde?