Chiappa,
Acho que encontrei uma solução... configurei CONFIGURE CHANNEL DEVICE TYPE DISK
FORMAT '/backup/rman/%d_%s';
Mas temo desabiliar esse DATAFILE / ARCHIVELOG BACKUP COPIES? Pelo o que
entendi, ele são os resposanceis por gerar uma copia.
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/backup/rman/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 14 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/rman/%d_%s';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/backup/rman/snapcf_jbsdtsulems.f';
run {
backup as compressed backupset full database format
'/backup/rman/dtf-%d-%t_%s_%p.rman' database;
backup current controlfile format '/backup/rman/ctrl-%d-%t_%s_%p.rman';
sql "alter system switch logfile";
backup device type disk format '/backup/rman/arch-%d-%t_%s_%p.rman' archivelog
all delete all input;
backup current controlfile format '/backup/rman/ctrl-%d-%t_%s_%p.rman';
backup spfile format '/backup/rman/spfile-%d-%t_%s_%p.rman';
}
Obrigado,
Ednilson Silva
De: sentto-1682896-122757-15505836...@returns.groups.yahoo.com
[mailto:sentto-1682896-122757-15505836...@returns.groups.yahoo.com] Em nome de
jlchia...@yahoo.com.br [oracle_br]
Enviada em: terça-feira, 19 de fevereiro de 2019 10:40
Para: oracle_br@yahoogrupos.com.br
Assunto: [oracle_br] Re: backup rman
PARECE ser os backup pieces mesmo do backup (se vc não der um format específico
ele usa um randômico, tipo isso que vc vê) mas pra termos CERTEZA, PLEASE nos
mostra teu script RMAN....
Abraços,
Chiappa
