thiagofm.
thiagofmAmigos,
Existe maneira de recuperar um schema apagado com o RMAN, sem ser criando uma nova instancia, voltando o backup full para essa instancia e fazendo um exp/imp para a instancia antiga???
obrigado
abs!
ramasineThiago, qual a versão do teu banco de dados e como é a sua política de backup?
thiagofmbanco 10g rodando em windows 2003
lvl 1 de segunda a sabado e domingo lvl 0
scripts abaixo!
estou com a rotina de backup parada para os backups nao sobrescreverem os antigos que tem os dados do schema
abs!
#configuração do catalogo
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘G:prtbkprmanctl_%F’;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 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 ‘G:prtbkprmanbks_%d_%s_%p_%t’;
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 ‘G:PRTBKPRMANSNCFEHUNTER.ORA’;
#lvl0
{resync catalog;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
crosscheck backup;
crosscheck archivelog all;
sql “alter system switch logfile”;
sql “alter system archive log current”;
backup incremental level 0 as compressed backupset
database tag ‘db_level0_weekly’
format ‘G:prtbkprmanbkslevel0_%d_%s_%p_%t.bkp’
plus archivelog tag ‘db_level0_weekly_arc’
format ‘G:prtbkprmanarclevel0_%d_%s_%p_%t.bkp’
delete input;
crosscheck backup;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
delete force noprompt backup completed before ‘sysdate-1’;
release channel c1;
release channel c2;
release channel c3;}
#lvl 1
{resync catalog;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
crosscheck backup;
crosscheck archivelog all;
sql “alter system switch logfile”;
sql “alter system archive log current”;
BACKUP INCREMENTAL LEVEL 1 TAG db_dayly
DATABASE PLUS ARCHIVELOG delete input;
crosscheck backup;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
release channel c1;
release channel c2;
release channel c3;
}