Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Oracle - Crosscheck_rman.sql ran during RMAN backup thru NB

Updated: 23 May 2010 | 3 comments
MattS's picture
0 0 Votes
Login to vote

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

 

discussion Filed Under:

Comments

Omar Villa's picture
27
Feb
2009
0 Votes 0
Login to vote

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

MattS's picture
27
Feb
2009
0 Votes 0
Login to vote

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:

 

 

[*****@***** ~]# cat /home/oracle/product/10.2.0/db_1/admin/*****/scripts/crosscheck_rman.sh
ORACLE_BASE=/home/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
ORACLE_SID=*****
export ORACLE_BASE ORACLE_HOME ORACLE_SID
unset USERNAME

PATH=$PATH:$ORACLE_HOME/bin:/usr/sbin
export PATH

$ORACLE_HOME/bin/rman target *****/******@***** nocatalog @/home/oracle/product/10.2.0/db_1/admin/******/scripts/crosscheck_rman.sql
[*****@******~]# cat /home/oracle/product/10.2.0/db_1/admin/*****/scripts/crosscheck_rman.sql
crosscheck archivelog all;
delete expired archivelog all;
exit

 

 

 

Omar Villa's picture
27
Feb
2009
0 Votes 0
Login to vote

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