RMAN – Veritas NetBackup Integration
I just recently got RMAN working with NetBackup. I have been asked to document this at work 
. Coincidently it makes for a great blog post!
#1. It is very important that you document things and how they are done so that other people can learn how to do them, know how it is done, and you can have a standard based off of this. It also gives you a baseline to improve upon. If you don’t believe me, read the book “The Goal”.
First, let me explain why we used RMAN and then why we linked it with Veritas. RMAN gives you so much flexibility and control of your backups. It might seem mundane at first, but once you get into the thick of it, you realize how powerful it is. There is an interface to RMAN through database control / grid control but I think Oracle still could improve greatly upon it. They leave many options out, but if the goal is simplicity and to get someone to do it, it is very powerful in that regard. I guess something is better than nothing, but really it’s pretty good but could be much better. How’s that?
RMAN also checks for corrupted blocks and can assist you with recovering them. It can keep track of block changes through a tracking file. This way it does not have to scan every block to see if it has changed. Even more powerful, if you have not compressed your backups, you can merge your level 1 and your level 0 to create a new level 0 backup. This can greatly speed up recovery times. I could go on and on but RMAN is a very powerful utility. I will blog more about it later.
Second, why did we want to link it with Veritas Netbackup? Well Veritas Netbackup is the corporate standard. You could just as well link it with EMC Networker and Tivoli Storage manager and any other backup vendor that makes a library to link RMAN with the MML. Before, we would have to have the backup person pull our Oracle backups off disk or we would execute a script after they went to disk. The problem is when the system crashes and we have to wake our backup person in the middle of the night to restore our files. If we find out it is the wrong one, we wake him up again. Recoveries take longer and the company loses money. By integrating RMAN with the Veritas Backup Agent we can now restore without having to wakeup our Backup Admin. Why? Because RMAN talks directly with Veritas when it backs up so that it is able to tell Veritas what it needs when it is time to recover.
Now keep in mind this combination is very powerful. My simple example does not do it justice : ).
First, you have to have NetBackup and the Oracle Agent installed on your server. You also need to have your Backup Admin enter the key into the Master Server so it will allow you to do this sort of backup. He will also have to configure the bp.conf file located in the default install directory for Netbackup which is /usr/openv/netbackup. He will also need to configure a backup policy that is of the Oracle type and assign it to the client.
Once this is done, you will want to check connectivity from the server by issuing /usr/openv/netbackup/bin/bpclntcmd -pn
Next, verify the version /usr/openv/netbackup/bin/bplntcmd -sv
Next, check to make sure the NetBackup communication daemons are running or it won’t work:
netstat -a | grep bpcd
netstat -a | grep vnetd
After that is done, shutdown your Oracle instance then as the Oracle user run /usr/openv/netbackup/bin/oracle_link to automatically link the ORACLE_HOME/lib/libobk.so to the proper libraries in the NetBackup directory.
Once that is done startup your instance and set your ORACLE_HOME and ORACLE_SID if it is not set and issue the following commands:
rman target /
RMAN> run
2> {
3> allocate channel t1 type 'SBT_TAPE';
4> backup database;
5> }
allocated channel: t1
channel t1: sid=138 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle – Release 5.1 (2006030220) Starting backup at 24-MAY-07
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00005 name=/ora01/app/oracle/oradata/testdb/mgmt.dbf
input datafile fno=00001 name=/ora01/app/oracle/oradata/testdb/system01.dbf
input datafile fno=00003 name=/ora01/app/oracle/oradata/testdb/sysaux01.dbf
input datafile fno=00002 name=/ora01/app/oracle/oradata/testdb/undotbs01.dbf
input datafile fno=00006 name=/ora01/app/oracle/oradata/testdb/mgmt_ecm_depot1.dbf
input datafile fno=00007 name=/ora01/app/oracle/oradata/testdb/rman_data_01.dbf
input datafile fno=00004 name=/ora01/app/oracle/oradata/testdb/users01.dbf
channel t1: starting piece 1 at 24-MAY-07
channel t1: finished piece 1 at 24-MAY-07
piece handle=03iihe1l_1_1 tag=TAG20070524T134629 comment=API Version 2.0,MMS Version 5.0.0.0
channel t1: backup set complete, elapsed time: 00:07:05
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel t1: starting piece 1 at 24-MAY-07
channel t1: finished piece 1 at 24-MAY-07
piece handle=04iiheeu_1_1 tag=TAG20070524T134629 comment=API Version 2.0,MMS Version 5.0.0.0
channel t1: backup set complete, elapsed time: 00:03:25
Finished backup at 24-MAY-07
released channel: t1
And folks that is about it. If you want to run in parallel, then just allocate more channels like this.
RMAN> run
2> {
3> allocate channel t1 type 'SBT_TAPE';
4> allocate channel t2 type 'SBT_TAPE';
5> backup database;
6> }
If you want to set this up by default then issue a show all command.
RMAN> show all
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128′; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/ora01/app/oracle/product/10.2.0/db_1/dbs/snapcf_gctest.f’; # default
Now issue
CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE;
Now all your backups will go to tape by default. Just start up RMAN and issue backup database; The other thing I did not show but you should do is backup plus your archive logs: backup database plus archivelog;
I hope this might be helpful to someone. Also, an excellent book is Robert Freeman and Matt Hart’s 10g RMAN guide from Oracle Press. Definitely a 5 star book!
kiran kumar said,
November 6, 2007 @ 12:24 am
Excellect explanation has provided. Thank you very much.
admin said,
November 6, 2007 @ 3:22 am
Hey, You’re my first post! Just based on that, I need to get back to blogging. I have a bunch of stuff to add.
Thanks for the motivation!
Nathan said,
November 6, 2007 @ 2:15 pm
Any chance you can shed some light on adding a Flash Recovery Area to this? We are going to have our backups going to Flash Recovery Area and then use NBU to backup the FRA to tape. However, I do not know if it’s possible to schedule the RMAN backups to FRA via Netbackup.
Thanks for the post. I was wondering if it really was that easy. Great to have someone with experience validate the proper config.
admin said,
November 6, 2007 @ 2:27 pm
Hi,
Actually, that is how we back it up now. I will try to do a new post sometime today with our backup script. We perform a backup to the flash recovery area and then from there we back it up to tape.
I’ll even try to simulate a recovery using this method. When I get time, I will build a test database and go from there.
admin said,
November 6, 2007 @ 5:10 pm
Nathan,
The more I think about it, the easier I think it is.
If you don’t specify a backup directory and you allocate a channel of disk or you use a default backup of disk, then it will backup to your flash_recovery_area. So will all of your archive logs if you don’t specify and archive log destination. Just think of it as the default.
So if you backup to Disk with nothing setup, it will go to your flash recovery area. Just make sure you have enough flash recovery area. That you have db_recovery_file_dest set somewhere and you have db_recovery_file_dest_size setup with how big your flash recovery area can be. It can be ASM if you want it to be.
Once that is backed up, try this.
RMAN> run
2> {
3> allocate channel t1 type ‘SBT_TAPE’;
4> 5> backup db_recovery_file_dest ;
6> }
I just tested it and it works. We actually backup out backup set to the flash recovery area then move that backup set to tape.
Backup Recovery Area also works.
Raghava said,
November 14, 2007 @ 9:59 am
Excellent explaination about RMAN with NetBackup – would be great if you can share restore process as well.
Zohar said,
November 20, 2007 @ 2:27 am
We have to build a backup solution for a 30 TB DWH database.
The first backup is a storage clone (EMC), and we intend to backup the replication to tapes, using Netbackup. The replicated DB can be opened in Read Only Mode only.
1. Is RMAN capable of incremental backup from the replicated Database as well ?
2. What are the possible performance implications to Netbackup working via the MML interface to RMAN, rather than working against DBF ?
I would suspect that the backup rate ( MB/seconds) when Netbackup is working in conjunction with RMAN is much slower. Am I wrong ?
Thanks for the excellent review.
jack said,
December 13, 2007 @ 9:06 pm
Hello All,
I am having 4 years of experience in Oracle 9i DBA. I am looking for RAC dba job although I do not have real time experience. I have gathered so many things. Fundamental ideas pretty clear. Can somebody give me real time problems could be occur in real time environment. I would be great full if anybody shares there problem faced in production environment. Let me know configuration of Backup policy used for RAC using RMAN.
Thanks,
~ JACK
admin said,
January 22, 2008 @ 9:06 am
Zohar,
It depends on your interface via the MML. If you are using disk staging, it can be quite fast. Veritas then transparently offloads to tape in the background. Also, if you do a Data Guard physical standby, you can do an RMAN backup from it. If you want to restore production, you need a fast way of getting your tape down here while preserving the library in Veritas. It will need to be labeled the same and shown as available from wherever you are within Veritas. You should also use an RMAN repository when doing this. The Robert Freeman RMAN book shows you exactly how to do this.
I will be adding a post showing how to use RMAN to backup at a DR site and restore something in production… i.e. Tablespace, datafile, database etc…
Raza said,
January 23, 2008 @ 6:01 pm
Hi,
You mentioned about having NetBackup and Oracle Agent installed on the server. I wanted some confirmation here:
1) In an Oracle RAC config where we have two DB servers (Active-Standby) and a NAS server, will we require this installation on all three servers or just one of the two DB servers.
2) I have heard of a standard Agent provided by Veritas which costs about $300 and a DB Agent which costs aroung $2500 per license. Are you referring to the DB Agent in your blog.
3) We have a DR site with a standby server which is being replicated by Data Guard Broker (hence looking forward to your blog). In the mean time, it would help to know if it is better to buy a single DB agent and place it on the DB server in the DR site with RMAN configured.
Your comments and advice will be very much appreciated.
admin said,
January 23, 2008 @ 6:30 pm
When you say RAC I only know of it as Active / Active? Maybe you are talking about the services? Active – Standby means you might be running Data Guard too. I will assume you are on a RAC primary with a DG standby.
Either way, I will explain several ways you can do it. We have done it both ways.
You can install the MML on both RAC nodes. Then, when you connect to RMAN, you do it using the TNS entry or the @servicename. For example, connect rman/password@racservicename. It will then use both nodes. You will then need to allocate channels of SBT_TAPE in your run statement or have the multiple channels setup as your default. However you want to do it, it works both ways. This way you can take advantage of both nodes and both machines in trying to achive your backups faster. You can also run your RMAN command from another node so if a server goes down, you can still run your backups.
If you want to install on one server, you can do that and then just connect to rman like “rman target / or rman target rman/somepassword@tnsentryforthatnode-sidonly”. The tape backups will just run from that one node.
Also, $2500 is the pricing but there might be room for negotiation. We get it for a lot less than that because we have an enterprise agreement. I am referring to the Oracle agent.
Now, if you want to run your backup from your DR site, you can as long as it is a Physical Standby. This means, it is a block for block copy. This will also free up your production server from having to backups. The drawback is how quickly can you restore your production DB using your backup media? For example, if my tapes are in Chicago, I would have to fly them into my production city and mount them in the Veritas library for me to restore them. Of course, we use an RMAN repository so mounting the channel and then telling RMAN to restore that DB is easy since it connects to Veritas and says I need these files which are on these tapes. It’s all transparent which is nice.
So, if you wanted to backup the DR using RMAN and tape, it will be something like this and you will want to use a Recovery Catalog since it greatly simplifies this.
Connect to your standby DB and your recovery catalog.
rman rcvcat rmanuser/password@rmancat target sys/pwd@stbyThen backup the DB.
RMAN> backup database;Remember, this is the block for block copy that matches production. Now connect to your primary and resync the catalog. RMAN “KNOWS” from the controlfiles and the recovery catalog that your primary and standby are a physical standby configuration and therefore a block for block copy. So let’s resync.
rman rcvcat rmanuser/password@rmancat target sys/pwd@primaryRMAN> resync catalog
Now RMAN is updated.
Now, as long as that tape is available or those files where RMAN has them recorded at on the stby is in the same path on the primary (means restoring them here first), then you can restore simply by issuing a restore command. If you pick a different path, then you will need additional commands to rename those on the fly.
I will detail how this works in a further blog post. I have so much material and I just need time to clean it up and post it.
Caushiph Unvar said,
January 30, 2008 @ 5:00 am
Great Explanation of the backup/RMAN workings.
Lance said,
February 20, 2008 @ 7:43 am
Could you provide a working RMAN script for restore your backup from tape?
ERP_ADMIN said,
February 26, 2008 @ 4:36 am
Hi all
mmm, I’m proceeding with new task to install Veritas Netbackup utility in Linux RH (250 GB SAN storage, 4GB Ram)
our DB will be 24/7 operational
my question is
can any one provide me the steps to install Ver. NBU in this Server and configure RMAN on to take daily IMAGE (IMAGE Copy ) to tapes
Appreciating your support.
Thanks
CJ said,
March 4, 2008 @ 8:17 am
Hello Thomas,
RE: The first blog – I just recently got RMAN working with NetBackup. I have been asked to document this at work
. Coincidently it makes for a great blog post!
I am using Oracle Standard Edition 11g R1 RAC installed on RHEL 5, my datafiles and RMAN backups are on ASM diskgroups. I am not prepared to upgrade to Enterprise Edition at this time for licensing reasons ($$).
What version of Oracle did you use when you created in this blog?
Do you think Vertias NetBackup will work with Oracle Standard Edition?
I am concerned about that NBU being able to get to the Oracle Achive redo log and and the control files via the ASM Oracle structure whch gets created with install of Oracle STANDARD11g, R1. Do you know of any isues?
I look forward to your feedback – Thanks CJ
Kwanyoung said,
April 13, 2008 @ 7:35 am
Hello,
Could you please explain a bit more for the confuguration of the netbackup with the rman?
For example,
I think we have to install netbackup agent in the oracle target database to be backed up.
What about the rman repository server?
Do we need to install the netbackup software or agent in the rman repository server?
Thanks
Thomas Roach said,
April 19, 2008 @ 7:55 am
It does not need to be on the RMAN repository unless you want to back up your RMAN respository to tape. It just needs to be on the servers that you want to back up the databases from. RMAN will run from the database server and connect to the RMAN respository to register where in NetBackup the backup sets are located. That way, when you need to restore/recover, RMAN can talk to NetBackup and tell it exactly what it needs and Veritas will provide it.
Thomas Roach said,
April 19, 2008 @ 7:56 am
CJ,
I believe NetBackup will work with Oracle Standard Edition. I don’t see any reason why it would not work.
Thomas Roach said,
April 19, 2008 @ 7:58 am
Lance,
It’s like a standard restore. You should allocate a channel to ‘SBT_TAPE’. You then issue the restore command like you would with Disk and it will get the backups and archivelogs from tape and restore your database. You can allocate multiple channels just like you did with a backup.
Piyush said,
May 6, 2008 @ 2:59 am
Nice post..My Lead had just asked me to setup RMAN with veritas backup..I had no clue on doing it..But I guess I know what to do
Cheers
rahul said,
May 27, 2008 @ 7:56 am
wel ,here is a bit of query ,how to integrate rman with veritas netbackup on oracle 9i rac ,plz can u give the recommendations as wel as the configuration steps
Ab said,
May 28, 2008 @ 11:19 am
Thanks for your posting. Can you tell us how we can do RMAN restore/recover from tape?
Thomas Roach said,
May 28, 2008 @ 11:43 am
With 9i, it’s the same as if it were to disk, instead it is to device type ‘SBT_TAPE’.
As to recovering from tape, I will add it, but it is pretty simple. You just allocate a tape channel and do the recovery.
Joe Franco said,
June 2, 2008 @ 10:31 pm
Hi there, I need some help here please.
We current have lots of oracle databases. The backup is done via RMAN and the backup files are put into a normal Unix directory like /u10/oracle/backup/dbname. That is the end of RMAN participation.
Then the Veritas NetBackup copies the FRA files from disk and put them on tape.
My problem is that I want to set up a database using ASM for everything (including the Flash Recovery Area (FRA)). Our Veritas “guru” says that the NetBackup cannot backup ASM files, or Disk Groups for that matter. I just don’t believe him. Is there anyone that has the NetBackup putting an ASM Disk Group to tape? Please note that we want NetBackup to read the Dir or Disk Group with no intervention of RMAN
I appreciate very much your input on this.
Thanks
Jeegar said,
June 6, 2008 @ 12:09 am
Hi Gurus,
My db daily hotbackups goes directly on tapes.
RMAN catalog is not on seperate server , instead its on same server ,as seperate schema , which is being backedup.
Now if in worst case, I lost db as well as catalog , how should i proceed to restore & reover on new server which is built up with same disk layout & same sid & dbid.
Jeegar said,
June 6, 2008 @ 12:27 am
Hi,
I think simply i have to install netbackup client & MML config , and then
Note: forgot to metion that my archivelogs also gets backuped & deleted ,during daily backup. Bakcup happens once in a day 11 pm(backup + arch logs )
RMAN> connect target /
RMAN> set dbid 1507972899 (old dbid)
RMAN> startup nomount pfile=
RMAN> restore controlfile from autobackup;
RMAN> shutdown
RMAN> exit
$ rman target /
RMAN> startup mount;
RMAN> show all;
$ sqlplus /nolog
SQL> connect / as sysdba
Connected.
SQL> select name from v$datafile;
SQL> select member from v$logfile;
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open resetlogs;
Now for example , backup time was 11:00 pm, and my server got crashed next day 2 pm. New server is ready with same disk layout.
Can I perform incomplete recovery until 1:30 PM on other day ?
Archives also lost which are genered from last backup to next day crash time.
Plz provide me the solution.
Zach said,
June 6, 2008 @ 1:12 am
Hi,
Very good blog; I realy appreciate the effert behind this great mission.
Now I am facing a problem. I have to restore a database backup from production to Integration environment. In Production, it is RAC db and RMAN and Veritas Net backup taking the backups.
In Integration Environment also we have the same setup.
So the steps I have done so far is:
1.Have the export of RMAN catalog schema from production and imported in RMAN server in Integration Environment.#
2. UNIX admins put and mounts the TAPE in tape library.
3. Set the environment for new db in oratab file.
4. connected to target and RMAN.
5. startup nomount from RMAN.
6.executed the following commands
RMAN> run {
2> allocate channel t1 type sbt;
3> validate backupset 2805233;
4> }
released channel: ORA_DISK_1
allocated channel: t1
channel t1: sid=317 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle – Release 6.0 (2005090703)
channel t1: starting validation of datafile backupset
channel t1: reading from backup piece db_11192_1_651890513
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of validate command on t1 channel at 06/05/2008 12:23:51
ORA-19870: error reading backup piece db_11192_1_651890513
ORA-19507: failed to retrieve sequential file, handle=”db_11192_1_651890513″, parms=”"
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
RMAN>
I’ve got the backupset key from RMAN catalog, but it is failing to validate the backup set.
And also all the subsequent attempts to restore spfile/controlfile/database are failing.
Now, I have been advised by Oracle that this is the problem with Media Manager and I have to contact them, unfortunately I dont have support service from Veritas.
Could any of you guys please advise, do we need to do any other configrations in net back to Identify the tapes from foreigen envirnment/ do we need to pass any more paramters from RMAN to see the newly mounted TAPS?
Your help will be highly appreciated.
Thanks and Regards,
Zach
Daniel Gomez said,
June 10, 2008 @ 4:55 pm
You can show the content of bp.conf file?
Thanks !.
Thomas Roach said,
June 10, 2008 @ 7:07 pm
cat bp.conf
SERVER = master_server
SERVER = master_server_#2
MEDIA_SERVER = media_server
CLIENT_NAME = oracle_hostname
CLIENT_READ_TIMEOUT = 4800
LIST_FILES_TIMEOUT = 4800
SERVER_SENDS_MAIL = YES
Have them assign you just one Oracle policy of “oracle” type. If you have more policies then you need to specify the policy with the ENV environment when you allocate your device type ’sbt_tape’ channel.
Example:
RMAN> allocate channel DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NB_ORA_SERV=master_server, NB_ORA_CLIENT=oracle_hostname, NB_ORA_POLICY=ORACLE_PRODUCTION, SBT_LIBRARY=/u01/app/oracle/product/10.2.0/db_1/lib/libobk.so)’;
Note: You do not need to supply all the Oracle parameters. Basically it works like this. If you allocate the channel and explicitly specify everything, it will use that. For things that aren’t specificed, it will look at the bp.conf file. For things in the bp.conf file, it will look to the master server, for example, the Oracle policy assigned to your server. If you have 2 policies and don’t specify which oracle policy, it will bomb.
Johnny said,
July 23, 2008 @ 12:57 am
Hi Thomas… great article. I read the Hart and Freeman book article before i saw this post and i just wanted to say that its great when you find someone else who has done a similar set up to you.
I recently upgraded a 9i db to 10g and didn’t realise i had to relink the netbackup libraries, and i can’t shut the db down to perfom this yet. Will be backing up to disk until i can sort this out.
Also – get back to blogging! Your posts are very informative and a great read!
Cheers
Johnny
Oracle Rant » Restoring a Database from Veritas NetBackup said,
July 27, 2008 @ 10:12 am
[...] wrote previously about integrating RMAN with Veritas NetBackup. The reason for doing so was so that I could easily verify that the backup went to tape and for [...]
Thomas Roach said,
July 27, 2008 @ 7:43 pm
Zach,
Sorry I did not answer you sooner. You need to verify that you have NetBackup configured correctly on your other server. Once you do that, verify that you have a NetBackup policy assigned to it. Then you should be able to validate it.
Geo said,
July 28, 2008 @ 5:42 pm
Hi Thomas,
Can anyone please help me with this error. Our system was working fine until last Friday suddently started to fail with the following error. There was no changes to the oracle setup. Any help is appreciated.
ORA-19506: failed to create sequential file, name=”RTYU_bk_u0njmkfo6_s23_p1_t661274374″, parms=”"
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: Communication with the server has not been iniatated or the server status has not been retrieved from the serve
Thomas Roach said,
July 29, 2008 @ 5:57 am
Geo,
Make sure you Master NetBackup Server can resolve your Oracle host’s NetBackup hostname. Something the NetBackup guys need to fix and / or it could be a Network issue.
Log Buffer #108: A Carnival of the Vanities for DBAs said,
August 1, 2008 @ 9:06 am
[...] On Oracle Rant, Thomas Roach has a thorough howto on restoring a database from Veritas NetBackup, a follow-up to his popular piece from May on RMAN and Veritas NetBackup integration. [...]
Mike Davis said,
August 6, 2008 @ 1:44 pm
Great article Thomas,
I have a question on restoring datafiles to a seperate location. I’ve contacted both Veritas and Oracle and they are pointing the finger at each other. I am running Oracle 9i and NetBackup v5.1 Maintenance Pack6.
I am told that there is a rman script that needs to be run but no-one seems to have the answer. Do you by chance know how the script should read?
Thank you and keep up the good work.
Mike
Thomas Roach said,
August 6, 2008 @ 1:53 pm
I have this post which talks about restoring.
http://www.oraclerant.com/?p=29
Do you want to restore to a different server?
VIshal Doshi said,
August 14, 2008 @ 9:39 am
I am trying to backup my physical standby databases via RMAN and Netbackup 6.0. We only have a Netbackup Media Server on the standby location and I was told to use that to backup the database.The Netbackup Master Server is at the primary location.When I try to test the backup via Grid Control, I am getting the following error
Starting backup at 14-AUG-08
channel oem_sbt_backup: starting compressed full datafile backupset
channel oem_sbt_backup: specifying datafile(s) in backupset
including current control file in backupset
channel oem_sbt_backup: starting piece 1 at 14-AUG-08
released channel: oem_sbt_backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on oem_sbt_backup channel at 08/14/2008 17:35:03
ORA-19506: failed to create sequential file, name=”05jo1i0f_1_1″, parms=”"
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status: cannot connect on socket
I looked into the Veritas Troubleshooting Guide which says that this is Netbackup Status Code:25 and pointed to http://support.veritas.com/nbucode/25
This guide states that process bprd and bpdbm must be running but I am not sure whether this processes need to be running on the Master Server or the Media Server. I see them running on the Master Server but not on the Media Server. Can anyone tell me what the problem is..Really appreciate it.
Thanks
Vishal
Thomas Roach said,
August 14, 2008 @ 9:51 am
We had this error initially. What we did was used ping to make sure that we could resolve all the hostnames.
Look in your bp.conf file for these lines.
SERVER = master_server
SERVER = master_server_#2
MEDIA_SERVER = media_server
CLIENT_NAME = oracle_hostname
Can you ping all of them from your db server? If not, add it to /etc/hosts or DNS or make sure you didn’t make a typo.
Now ping the CLIENT_NAME from your media servers. This will make sure you get name resolution.
Next, do this on your db server:
/usr/openv/netbackup/bin/bpclntcmd -pn
/usr/openv/netbackup/bin/bplntcmd -sv
netstat -a | grep bpcd
netstat -a | grep vnetd
Are the processes running?
If you still cannot get it to work, I would contact Veritas for support. We contacted them and that’s what it was. The Master/Media server could not resolve the hostname of the DB server. We added it to /etc/hosts and bingo, we were good!
VIshal Doshi said,
August 14, 2008 @ 11:31 am
So I tried all of that and it all looks good yet I am having the same issue…I am talking to Veritas Support to see if they can help.
Thomas Roach said,
August 14, 2008 @ 11:34 am
Good luck. Please post back and let us know what fixed it. I’m curious.
VIshal Doshi said,
August 14, 2008 @ 12:13 pm
It is fixed now..It was the firewall between the db server and the master server… ans also the fact that I mitakenly was putting in the media server name for NB_ORA_SERV..Thx for your help.
Tech Ops said,
October 17, 2008 @ 8:31 am
Great post. However, I wonder if you might also be able to shed some light on my deliemma, while planning to do the same. We need to protect to SYS/SYSDBA account and therefore, do not wish to provide the master keys to the Database to the Backup Operator. Can the RMAN password required by VERITAS be something separate from the SYS/SYSDBA Passwords? Currently, BackupExec (SQL>) connects to sys as sysdba. Now that we’re planning to implement RMAN, we’d like to close this informational gap. Thanks.
Oracle Rant » Looks like someone is stealing blogposts out there… said,
February 13, 2009 @ 8:08 am
[...] Looks like someone is stealing blogposts out there… [...]
Thomas Roach said,
February 13, 2009 @ 10:33 am
Tech OPS, As far as I know, you need sysdba privs in order to backup the DB. What you can do is create an RMAN user and grant him sysdba privs which would be a separate password if you wanted it to be from your SYS user.
OCP said,
February 19, 2009 @ 1:11 pm
Can you tell me what the two para are for Oracle Enterprise Manager 10g
Tape Settings – Tape Drives =
Media Management Settings – Media Management Vendor Library Parameters =
I want to send my backups to tape using Net VER 6.5 through OEM 10G.
Thanks
Salman said,
February 25, 2009 @ 1:14 am
Hi,
I am happy to find out this discussion because i have just joined a new company and first time i have to work with RMAN Veritas backups and i don’t know very much about veritas backup using RMAN. Previous DBAs didn’t prepare any document which i could use to learn about the environment. I have following questions
1) From net backups console GUI, i am not able to see the backups taken by RMAN. Is it a usual behaviour? I mean do i need to use only RMAN to restoer the backups from the tape of can i also see my backup pieces in GUI and can restoer them?
2) I am able to resotre a contrfol file from the backup (for testing purposes). I am not using any RMAN catalog, in case i loose all my database then what would be the steps to restore my whole database from the net backups and recover it. REmember that i also need to restore spfile from the backup which is on the tape.
Thanks
Salman
Thomas Roach said,
February 25, 2009 @ 8:56 am
OCP, you could just put all those things in your bp.conf file. If you want to send them manually, then you could just send for Library parameters ‘SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1, ENV=(NB_ORA_POLICY=, NB_ORA_SERV=)’; In face, you probably only need to seend ‘ENV=(NB_ORA_POLICY=, NB_ORA_SERV=)’; or ‘ENV=(NB_ORA_POLICY=‘. Other tape libraries have different requirements. For Veritas, if you have your bp.conf setup and you have only one Oracle policy, then you should not have to set anything.
As to the tape drives, I think that has to do with parallelism. If you have 4 drives, then set it to 4 and 4 processes will backup your DB.
Thomas Roach said,
February 25, 2009 @ 8:58 am
Salman, you would need to backup your control file as an image. If it goes into a backup set, then you will have to use the DBMS_BACKUP_RESTORE procedure. I would strongly recommend that you snag the control file as is, after all of your backups. I would highly recommend you do a recovery catalog though.
As to seeing your backups, you should see them. Are you querying them correctly? You should see oracle type backups if there are some. I see them on my GUI.
Salman said,
February 25, 2009 @ 5:01 pm
Hi,
Thanks Thomas for your reply. I have actually control file auto backup so i think i dont neet to worry.
On question, I have created a new database on the server where veritas backups are working for first database. How can i generate the scripts from veritas for my new database so that i could schedule its RMAN backups on netbackup.
Thanks
Salman
Rakesh Pawar said,
May 8, 2009 @ 12:19 am
great doc
Rakesh Pawar said,
May 8, 2009 @ 12:36 am
Hi All,
I have SUN Solaris 10 master server & clients on sun solaris oracle with oracle 10 G
I am getting the same error when i try to take backup using RMAN
channel oem_sbt_backup: starting compressed full datafile backupset
channel oem_sbt_backup: specifying datafile(s) in backupset
including current control file in backupset
channel oem_sbt_backup: starting piece 1 at 14-AUG-08
released channel: oem_sbt_backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on oem_sbt_backup channel at 08/14/2008 17:35:03
ORA-19506: failed to create sequential file, name=”05jo1i0f_1_1″, parms=””
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status: cannot connect on socket
But the file level backup is running with out any error. please help to resolve this issue
Amit said,
May 27, 2009 @ 10:01 pm
Hi All,
I have a question regarding RMAN backup and recovery.
Can you restore RMAN backup on unix machine which is taken on Windows machine.
Thanks
Amit
Thomas Roach said,
May 28, 2009 @ 4:11 am
Amit,
I believe this only works on 10gR2 is the DB’s use the same endianness. In 11g, it might be possible, but look at the documentation, but I do not believe it is.
Here is the 10gR2 doc http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm
Thomas Roach said,
May 28, 2009 @ 4:12 am
Rakesh, it sounds like a networking error. Verify connectivity from all nodes using the respective hostnames. Sounds like a firewall issue or the fact that something cannot be resolved.
Rinky said,
June 11, 2009 @ 5:10 pm
Thomas,
I am very impressed by this article & the discussion. I am struggling with a netbackup error since 2 months. I would really appreciate if you can look at it and provide me some suggestion. Just to give you an overview.
I am successfully in setting up RMAN tape (using netbackup) on many oracle dbs but for some I am getting below errors. I dont know what the cause is. I have tried all the commands above & ip address & all entries are fine in /etc/hosts & bp.conf. The only difference betwen the ones successful & ones unsuccessful is : the unsuccessful ones have more than one instances using same oracle home. now the error is
RMAN> run {
2> allocate channel t5 type ’sbt_tape’
3> PARMS ‘ENV=(NB_ORA_SERV=fly.agarin.com,
4> NB_ORA_POLICY=ORA_devbi_DB_RMAN,
5> NB_ORA_CLIENT=becan.agarin.com)’;
6> backup current controlfile;
7> }
allocated channel: t5
channel t5: sid=488 devtype=SBT_TAPE
channel t5: Veritas NetBackup for Oracle – Release 6.5 (2008052301)
Starting backup at 11-JUN-09
channel t5: starting full datafile backupset
channel t5: specifying datafile(s) in backupset
including current control file in backupset
channel t5: starting piece 1 at 11-JUN-09
released channel: t5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t5 channel at 06/11/2009 16:23:18
ORA-19506: failed to create sequential file, name=”51khasvl_1_1″, parms=”"
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status: socket read failed
Ashok said,
September 22, 2009 @ 1:28 pm
Hello All
Can we restore RMAN backup’s using NetBackup bprestore command on the oracle client
appreciate your help
Thanks in advance
Mohan said,
October 13, 2009 @ 2:19 am
Hi All,
I have configured the Netbackup oracle backup & also I can able to restore the entire full backup to different server. Now my question is today i am taking the incremental backup, tomorrow I have issue in the DB how to restore the incremental backup in the same server.
Thanks in Advance
Periklis said,
October 15, 2009 @ 10:52 pm
Hello All,
Did anybody tried taking encrypted backups through RMAN directly to tapes using NetBackup?
Is it supported?
Thanks in Advance