есть рабочея БД оракл 11 кто то до меня сделал скрипт по бэкапам ... бэкапы логи успешно создаються ...
но скрипта по востановлению базы из бэкапа нет( гуглил неделю мучелся и нащел то что скрипт взят с сайта ораклано но команд или скрипта по востановлению из него нигде не нахожу ..
помогите с командами по востановлению базы !!!! жизнено необходимо наити коректное решение
СКРИПТ БЭКАПА
run {
CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
RECOVER COPY OF DATABASE WITH TAG "whole_db_copy";
# Make an incremental backup of the database to the flash recovery area.
BACKUP CHECK LOGICAL INCREMENTAL LEVEL 1
FOR RECOVER OF COPY WITH TAG "whole_db_copy"
DATABASE plus archivelog;
DELETE OBSOLETE;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'g:\backupdir\%T_%s_%p.bak';
}
СЫЛКА НА ИСТОЧНИК ОТКУДА КАК Я ПОНИМАЮ ОН БЫЛ ВЗЯТ
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkscenar001.htm
A.1.1.1.2 Daily Script
The daily backup script would look like this:
RMAN> RECOVER COPY OF DATABASE WITH TAG "whole_db_copy";
# Make an incremental backup of the database to the flash recovery area.
RMAN> BACKUP INCREMENTAL LEVEL 1
FOR RECOVER OF COPY WITH TAG "whole_db_copy"
DATABASE;
Assume that there are no backups tagged "whole_db_copy" as of the first day of this backup scheme. The results of running this script daily are as follows:
On the first day, the RECOVER statement would have no effect, and the BACKUP... FOR RECOVER OF COPY would create the initial level 0 database copy.
On the second day, the RECOVER statement still has no effect, as there is no level 1 incremental backup to be applied to the level 0 incremental database copy. The BACKUP command creates the first incremental level 1 backup.
Each day after that, the incremental level 1 from the previous day is applied over the level 0 database copy, rolling it forward to the time of the incremental level 1 of the previous day, and a new incremental level 1 is created, containing all changes since the level 1 incremental backup of the previous day.
