11-21-2015 09:24 PM
what is the difference between
1. If DBA dump there database on one server and we take backup of that database as flat file
2. we take oracle database backup with RMAN.
What is the difference between point 1 and 2.
If there is no difference then why we purchase RMAN license why we dont go with 1st point everytime.
What is archive backup and advantage of it?
11-24-2015 09:19 PM
Archive backup - this is a "User archive schedule" in NetBackup and it will backup the data and delete the same data from the source location upon getting successful backup. this can be done by administrator of client where they can select the files/folders and run the command bparchive in cmd with the required files/folder needs to be archived.
Note: Account should have write permission to delete the files/folders after successful completion of backup.
11-24-2015 10:30 PM
11-25-2015 11:18 AM
Thanks for your update. i am referring rman archive logs.
11-25-2015 11:46 AM
This is something you need to discuss with your dba.
If dumped to disk in the same way as option 1 above, then NBU backup and restore will be the same as in my reply above.
If using NBU agent - discuss frequency with dba.
Some databases generate archive logs at such a rate that hourly log backups with truncate is necessary.
Other database logs are fine to backup and truncate once a day after daily rman backup as part of the same backup script.
11-28-2015 08:37 PM
Adding few terms which you may be already aware. But make sure you know this
1. By backing up flat files of the DB data files, you are just backing up the files. NetBackup is not at all aware about the L0, L1.. or archival's. DBA will have to struggle to figure out the required files to bring back the Oracle DB in desired state. Here NetBackup Admin's (mostly else DBA) will restore the flat file backups and DBA will have search from the restore files to get the desired DB files.
2. With NetBackup & RMAN - Both RMAN and NetBackup are in sync with respect to the L0 or L1 or archival files. DBA just need to know the handles (DB files) and create the script. RMAN recovery will connnect with NetBackup and Netbackup will restore the desired files to bring the DB up & running.