Ednilson A pergunta que nao quer calar... Vc precisou de restaurá-los pra valer ? Ou foi só o deixar de lado e agora retomou, pra terminar de configurar..?
Não esqueça de testar tudo antes ( backup, restauracao) antes de colocar em produção.. parece bobagem eu comentar isso aqui mas, é sempre uma dica que salva muitas e muitas vidas.. On 24 February 2014 09:30, Ednilson Silva <[email protected]> wrote: > > > Pessoal, > > Tive alguns imprevistos aqui na empresa e acabei deixando de lado o rman, > retomando fiz as config abaixo e criei dois scripts para fazer um backup > diário (Segunda a Sábado) e outro semanal (Domingo) conforme ensinamentos > do mestre Ederson. > > Algo que não entendi bem, o RMAN esta com REDUNDANCY 2, não deveria manter > apenas dois backup? > > > > [root@mtzbdofv01 rman]# ls -lh > > -rw-r----- 1 oracle10 dba 6.8G Feb 20 10:23 DBSIM3G_3559765569_118.rman > > -rw-r----- 1 oracle10 dba 59M Feb 20 10:23 DBSIM3G_3559765569_119.rman > > -rw-r----- 1 oracle10 dba 1.6G Feb 20 20:05 DBSIM3G_3559765569_121.rman > > -rw-r----- 1 oracle10 dba 1003M Feb 20 20:11 DBSIM3G_3559765569_122.rman > > -rw-r----- 1 oracle10 dba 5.4M Feb 20 20:11 DBSIM3G_3559765569_123.rman > > -rw-r----- 1 oracle10 dba 1.8G Feb 21 20:05 DBSIM3G_3559765569_125.rman > > -rw-r----- 1 oracle10 dba 1.5G Feb 21 20:13 DBSIM3G_3559765569_126.rman > > -rw-r----- 1 oracle10 dba 5.4M Feb 21 20:13 DBSIM3G_3559765569_127.rman > > -rw-r----- 1 oracle10 dba 377M Feb 22 20:01 DBSIM3G_3559765569_129.rman > > -rw-r----- 1 oracle10 dba 264M Feb 22 20:05 DBSIM3G_3559765569_130.rman > > -rw-r----- 1 oracle10 dba 3.8M Feb 22 20:05 DBSIM3G_3559765569_131.rman > > -rw-r----- 1 oracle10 dba 150M Feb 23 10:00 DBSIM3G_3559765569_133.rman > > -rw-r----- 1 oracle10 dba 6.7G Feb 23 10:23 DBSIM3G_3559765569_134.rman > > -rw-r----- 1 oracle10 dba 5.3M Feb 23 10:23 DBSIM3G_3559765569_135.rman > > -rw-r----- 1 oracle10 dba 13M Feb 23 10:23 snapcf_dbSim3g.f > > -rw-r----- 1 oracle10 dba 13M Feb 23 10:23 > DBSIM3G_c-3559765569-20140223-00.cf > > > ----------------------------------------------------------------------------------------- > > *CONFIG RMAN* > > > > RMAN> show all; > > > > using target database control file instead of recovery catalog > > RMAN configuration parameters are: > > CONFIGURE RETENTION POLICY TO REDUNDANCY 2; > > CONFIGURE BACKUP OPTIMIZATION ON; > > CONFIGURE DEFAULT DEVICE TYPE TO DISK; > > CONFIGURE CONTROLFILE AUTOBACKUP ON; > > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO > '/d01/backup/dbSim3g/rman/%d_%F.cf'; > > CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED > 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 > '/d01/backup/dbSim3g/rman/%d_%I_%s.rman'; > > CONFIGURE MAXSETSIZE TO UNLIMITED; # default > > CONFIGURE ENCRYPTION FOR DATABASE OFF; # default > > CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default > > CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default > > CONFIGURE SNAPSHOT CONTROLFILE NAME TO > '/d01/backup/dbSim3g/rman/snapcf_dbSim3g.f'; > > > ----------------------------------------------------------------------------------------- > > *BACKUP DIARIO* > > > > ORACLE_SID=dbSim3g > > ORACLE_HOME=/d01/app/oracle/product/10gR2 > > PATH=/d01/app/oracle/product/10gR2/bin > > rman target=/ log=/d01/backup/dbSim3g/logs/backup_diario.log << EOF > > RUN { > > crosscheck archivelog all; > > BACKUP incremental level 1 DATABASE PLUS ARCHIVELOG; > > } > > EXIT; > > EOF > > > ----------------------------------------------------------------------------------------- > > *BACKUP SEMANAL* > > > > ORACLE_SID=dbSim3g > > ORACLE_HOME=/d01/app/oracle/product/10gR2 > > PATH=/d01/app/oracle/product/10gR2/bin > > rman target=/ log=/d01/backup/dbSim3g/logs/backup_semanal.log << EOF > > RUN { > > crosscheck archivelog all; > > crosscheck backup; > > BACKUP AS COMPRESSED BACKUPSET incremental level 0 DATABASE PLUS > ARCHIVELOG delete all input; > > delete noprompt obsolete; > > } > > EXIT; > > EOF > > > > Grato > > Ednilson Silva > > >
