Oracle RAC Backup
Master and SAN Media servers -NetBackup 7.0 Master - Windows Media servers - RedHat Linux (SAN Media Servers) I have a RAC of 4 nodes . All the nodes are SAN Media servers . I dont have any cluster software like VCS or RedHat Cluster . Now i need to configure the backups such a way that all the nodes should send the backup to same Storage Unit . Is it possible to create a app cluster for NetBackup Media server without any clustering software . If we dont have cluster how do we configure the backups such a way that even one node of the RAC is down , the backup should happen on another node without any manual intervention ? Thanks, SKOracle Backup Issue | NBU ver 6.5
Hi Guru's Recently had issue with an oracle backup, Sorry if the information given is insufficient but will try my best. As per what the structure is currently (Provided with the backup selection list in bracket): 1st DB Backup Runs (/usr/local/nb/scripts/oracle_rman_hot.uaedb1) 2nd RMAN Logs (Backup selection list is empty) 3rd DB Files ( / ) 4th OS Files ( / ) ========================= When a Oracle backup is triggered, the others gets triggered automaticly until it completes. And all these are in a different policy: e.g 1.DB Backup = (DB_ORA_UAE) 2.RMAN Logs = (UAE_RMAN_LOGS_DW) 3.DB Files = (DB_Files) 4.OS Files = (FS_UAE_UNIX_1) ========================== My concern is, how to make the rman log, db files and os files jobs to run automated upon triggering the DB backup? is it by script? On another note, DBA team informed me that all the backups in order, but i cant seem to see that in netbackup. Thank You Guru's
Media selection for SAP, Oracle (or possibly just window related?)
Netb 6.5.4,Solaris with SAP and ORA agents. Problem: for scheduled backups, there appear to be some issues related to media selection or 'why did my job stop'. Let me explain. With SAP backups I see this: policy starts, single stream, picks a tape,brbackup writes to it (SAP with Oracle btw). Then the backup enters a second phase, ie a separate job is spawned. This is to do the redo phase,ie we run brarchive. It drops the first tape and selects another ,writes to it.This repeats for the remaining phases of the job, so theres 2 tapes written alternately. Each spends (wastes?) time dismounting and remounting a new tape,A,B,A,B,A. Not knowing SAP for I'm not a SAP admin, is theres a good reason for doing this ie not putting all the data on a single media? I ask since on an unloaded system its not that important but when on a heavily used system this causes an issue: some other job jumps in and grabs the drive...backups that should take no time to complete to do arch redos or utl files (backup runs 5 phases,5 changes of media) are stretched out over hours. Similarly wth Oracle...the tpl runs, I write out the bulk of my data and then the next phase runs (archivelogs) and it needs a different media.Something else jumps in as if the job hasnt started and my Ora backup hangs around. This gets worse..the next phase (when there is a drive free) is then regarded as being out of the window of opportunity...its done the bulk data and now its been canned because the window has closed. Surely it would make sense to say if the initial job started in the window then all other spawned jobs are therefore deemed to have started within the window? Is there a way to do this? Simlarly if the job has begun then tape drive alloc should be reserved for that job if the job or subjob is still running? Thanks in advance,jim.
Netbackup Oracle intelligent policy - Oracle user privileges
Hi all, I am doing some tests on Oracle smart policies. I did not catch perfectly what should be the minimum set of privileges which configured oracle user must have to complete successfully the backup/restore operation. Do you have an idea about? Thank You Regards Mauro