› Fóruns › Banco de dados Oracle › I/O – error RMAN › I/O – error RMAN
Rodrigo já testei com todos meus scripts de backup’s possiveis segue o ultimo. Outra informação meu ambiente é um rac de 2nodes.
script de backup:
configure retention policy to recovery window of 7 days;
configure controlfile autobackup on;
configure default device type to Disk;
configure device type Disk parallelism 2;
configure datafile backup copies for device type Disk to 1;
set controlfile autobackup format for device type Disk to ‘/u02/backup/rman/deprac/level0/dbs/DEPRAC_ctl_%F’;
run{
debug on;
allocate channel ch1 type Disk maxpiecesize = 2G ;
backup incremental level 0 filesperset 1
format ‘/dba/wis/rman/deprac/level0/dbs/dep_%U.rman’
(database include current controlfile);
release channel ch1;
debug off;
}
run {
allocate channel ch1 type Disk ;
sql “alter system archive log current”;
backup archivelog all filesperset 10
format ‘/dba/wis/rman/deprac/level0/arch/arch_%U.rman’
delete all input;
release channel ch1;
resync catalog;
}
CROSSCHECK BACKUP;
##RESTORE TABLESPACE SYSTEM VALIDATE;
##RESTORE ARCHIVELOG ALL VALIDATE;
LIST BACKUP OF DATABASE;
REPORT UNRECOVERABLE;
REPORT SCHEMA;
REPORT NEED BACKUP;
REPORT OBSOLETE;
quit
EOF