Oracle - Crosscheck_rman.sql ran during RMAN backup thru NB
NB6.0MP7
Oracle RHEL4
Oracle 10g (5 node) RAC.
Hot backup
So our dba has a cronjob that runs <DB_Name>/scripts/crosscheck_rman.sql
My concern is that this cron has been running during the backup windows. I have not been able to verify if this has been an issue because my logs dont go back far enough to get enough information about it.
So my question is, do you think that if crosscheck runs during an rman backup will it cause problems? More of an oracle question i guess but i thought i would start here :).
The problem im seeing (I've honestly only been able to get in 1 test run since the issue started) is that once the backup job gets finished with the Archive logs it looks like the entire backup script starts all over again! The script output file even overwrites itself and starts over. And because it takes about 2-3 hours to backup and the DBAs are very busy with this environment i havent been able to let that "second run" complete...very odd.
Thanks,
Matt
Comments
you can change the schedule of your backups and see if is been affected or not by the script. by the way, you can share the script to see what is doing and confirm if in some way affects the backup jobs.
regards
Omar A Villa
Netbackup Expert
These are my personal views and not those of the company I work for
Ya I realize I can just modify the schedule, was just curious if anyone actually knew if it would or wouldn't interfere.
Here is the script:
yes your backups can be affected because your archiving your logs at the same time that your DB backups are running, only if you are running a log backups.
Omar A Villa
Netbackup Expert
These are my personal views and not those of the company I work for
Would you like to reply?
Login or Register to post your comment.