Re: Dbms scheduler

On 5/22/23 13:17, Douglas Dunyan wrote:
> And while there are many tools to actually schedule, RMAN Recovery
> Catalog is a 'central database' to record the metadata of your backups
> and their status' regardless of the control or initiator...
>
> The important components are 1)  monitoring those backups for
> failures, and 2)  monitoring your Recovery Catalog for database
> backups that have not been executed at all.
>
> D
>
> On Mon, May 22, 2023 at 9:57 AM Mladen Gogala
> <gogala.mladen_at_gmail.com> wrote:
>
> Sometimes backup utility itself has a better GUI than OEM. That's
> the case with Avamar, Druva and Commvault. They all incude scheduler.
>
> Mladen Gogala
>

Well, all the backup suites listed above can utilize and connect to RMAN catalog and produce reports from the catalog. Those suites all utilize RMAN to do backup and allocate SBT_TAPE channels, utilizing libobk.so (or libobk.dll). There are things that those backup suites can do and RMAN cannot because it doesn't have storage snapshot interface. Using crontab and RMAN channels on device type disk is so 20th century, something like the leaded gas. Essentially, RMAN has come full circle, back to EBU. It was once touted as standalone solution for all the backup problems and now it's better to utilize it with a 3rd party GUI. EBU was a version 8i backup which required either Legato Systems, TSM or HP Guardian. The problem was with the "backup mode", when the database was writing far more archive log information than without the backup mode, which tended to fill LOG_ARCHIVE_DEST (there was only one in the version 8i) with rather unpleasant consequences for the database performance. Even worse than that, backups were running over night, so that ORA-00257 would be thrown at wee hours of the night and I couldn't get my very necessary beauty sleep. That is what rman has solved and now I am beautiful again.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l