привет. подскажите плиз. был стабильно работающий сервер, потом его зашифровали и ночью rman пытался сделать бэкап. зашифровали только dbf.
бэкап скрипт
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
run
{
CONFIGURE ENCRYPTION FOR DATABASE CLEAR;
CONFIGURE ENCRYPTION ALGORITHM CLEAR;
CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CLEAR;
CONFIGURE DEVICE TYPE DISK PARALLELISM 6;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ARCHIVELOG DELETION POLICY CLEAR;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;
CONFIGURE RETENTION POLICY CLEAR;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
configure retention policy to redundancy 1;
backup incremental level 0 cumulative database TAG='MAIN_BKP' plus archivelog delete input;
delete noprompt obsolete;
}
после восстановил бд, но с архивлогами беда ...
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
RMAN> RESTORE ARCHIVELOG ALL VALIDATE;
Starting restore at 19-SEP-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/19/2018 14:09:26
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1137 and starting SCN of 522240167 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1136 and starting SCN of 522239038 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1135 and starting SCN of 522219786 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1134 and starting SCN of 522218127 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1133 and starting SCN of 522214073 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1132 and starting SCN of 522213017 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1131 and starting SCN of 522207470 found to restore
пропускаю с помощью
recover database noredo;
подскажите куда копать чтоб при последующих бэкапах все корректно восстанавливалось?
