Comments for Oracle Rant http://www.oraclerant.com Blog about anything and everything Oracle. Fri, 03 Sep 2010 23:48:44 +0000 hourly 1 http://wordpress.org/?v=3.0 Comment on Restoring a Database from Veritas NetBackup by Thomas Roach http://www.oraclerant.com/?p=29&cpage=1#comment-491 Thomas Roach Fri, 03 Sep 2010 23:48:44 +0000 http://www.oraclerant.com/?p=29#comment-491 Actually this is a better post. http://oracleprof.blogspot.com/2010/02/rman-and-sbttape-backup-pieces-how-to.html Actually this is a better post.

http://oracleprof.blogspot.com/2010/02/rman-and-sbttape-backup-pieces-how-to.html

]]> Comment on Restoring a Database from Veritas NetBackup by Thomas Roach http://www.oraclerant.com/?p=29&cpage=1#comment-490 Thomas Roach Fri, 03 Sep 2010 23:47:49 +0000 http://www.oraclerant.com/?p=29#comment-490 Jocelyn, it is an Oracle type. I thought you could do this but apparently you can't. Here is some more information on Oracle-L where I asked a question just like yours and got great responses! http://www.freelists.org/post/oracle-l/Catalog-RMAN-backups-on-Tape and here http://erpondb.blogspot.com/2008/09/catalog-rman-backuppieces.html In the first link, if you look through the list, you can find out how to list the pieces and then catalog them in RMAN so they can be pulled (see the 2nd link). Jocelyn, it is an Oracle type. I thought you could do this but apparently you can’t. Here is some more information on Oracle-L where I asked a question just like yours and got great responses!

http://www.freelists.org/post/oracle-l/Catalog-RMAN-backups-on-Tape

and here

http://erpondb.blogspot.com/2008/09/catalog-rman-backuppieces.html

In the first link, if you look through the list, you can find out how to list the pieces and then catalog them in RMAN so they can be pulled (see the 2nd link).

]]> Comment on Restoring a Database from Veritas NetBackup by Thomas Roach http://www.oraclerant.com/?p=29&cpage=1#comment-489 Thomas Roach Fri, 03 Sep 2010 23:36:30 +0000 http://www.oraclerant.com/?p=29#comment-489 Dennis, actually you do need to set that parameter. it is called a redirected restore. You can find more here. http://seer.entsupport.symantec.com/docs/278894.htm I got it confused with policy. My bad. Dennis, actually you do need to set that parameter. it is called a redirected restore. You can find more here.

http://seer.entsupport.symantec.com/docs/278894.htm

I got it confused with policy. My bad.

]]> Comment on RMAN – Veritas NetBackup Integration by Thomas Roach http://www.oraclerant.com/?p=7&cpage=2#comment-488 Thomas Roach Fri, 03 Sep 2010 23:33:56 +0000 http://www.oraclerant.com/?p=7#comment-488 I will reply to all the new comments soon. Been very busy at work and I have about 1 million posts I could do and should do, time permitting. As to restoring the RMAN/Veritas NetBackup to a totally new set of servers, research a "redirected" restore so that Veritas lets new hostnames access the tapes. Something you could also do is set the parameters so they match what production had. Specifically NB_ORA_SERV=master_server, NB_ORA_CLIENT=oracle_hostname, NB_ORA_POLICY=ORACLE_PRODUCTION. For more details on a redirected restore, look here http://seer.entsupport.symantec.com/docs/278894.htm I will reply to all the new comments soon. Been very busy at work and I have about 1 million posts I could do and should do, time permitting.

As to restoring the RMAN/Veritas NetBackup to a totally new set of servers, research a “redirected” restore so that Veritas lets new hostnames access the tapes. Something you could also do is set the parameters so they match what production had.

Specifically NB_ORA_SERV=master_server, NB_ORA_CLIENT=oracle_hostname, NB_ORA_POLICY=ORACLE_PRODUCTION. For more details on a redirected restore, look here http://seer.entsupport.symantec.com/docs/278894.htm

]]> Comment on Installing Oracle on Windows 7 RC1 by Coleman Leviter http://www.oraclerant.com/?p=77&cpage=2#comment-482 Coleman Leviter Fri, 27 Aug 2010 00:33:07 +0000 http://www.oraclerant.com/?p=77#comment-482 I installed Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production onto a Windows 7 PRO 32 bit platform. So far, my only issue resides with XML "Pretty Print". I doesn't work; that is, when I query a relational table and use XMLSERIALIZE (Document), I get a non indented output (or an output that doesn't display the parent child relationship). It's worked before on XP PRO 32 bit using 10.2.0.1. Any suggestions? I installed Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production onto a Windows 7 PRO 32 bit platform.

So far, my only issue resides with XML “Pretty Print”. I doesn’t work; that is, when I query a relational table and use XMLSERIALIZE (Document), I get a non indented output (or an output that doesn’t display the parent child relationship).

It’s worked before on XP PRO 32 bit using 10.2.0.1.

Any suggestions?

]]> Comment on Installing Oracle on Windows 7 RC1 by Don Slaughter http://www.oraclerant.com/?p=77&cpage=2#comment-468 Don Slaughter Sat, 21 Aug 2010 06:18:23 +0000 http://www.oraclerant.com/?p=77#comment-468 I want to install Oracle 11g R2 Enterprise and Portal 11G on a single server Windows 7 64 bit OS platform. Will these products run on the win 7 64 bit platform ? I want to install Oracle 11g R2 Enterprise and Portal 11G on a single server Windows 7 64 bit OS platform. Will these products run on the win 7 64 bit platform ?

]]> Comment on Installing Oracle on Windows 7 RC1 by Sumit http://www.oraclerant.com/?p=77&cpage=2#comment-465 Sumit Thu, 19 Aug 2010 21:13:14 +0000 http://www.oraclerant.com/?p=77#comment-465 you can run the setup as follows: setup.exe -ignoreSysPrereqs you can run the setup as follows:

setup.exe -ignoreSysPrereqs

]]> Comment on Just released VirtualBox 3.2.8 now supports shared disks (think RAC) by M-A-O-L » Oracle RAC on VirtualBox http://www.oraclerant.com/?p=96&cpage=1#comment-460 M-A-O-L » Oracle RAC on VirtualBox Thu, 12 Aug 2010 06:26:28 +0000 http://www.oraclerant.com/?p=96#comment-460 [...] RAC on VirtualBox is now possible because VirtualBox now supports shared disks. Tim Hall of ORACLE-BASE fame has added a write-up of all the steps required to get 11gR2 RAC on [...] [...] RAC on VirtualBox is now possible because VirtualBox now supports shared disks. Tim Hall of ORACLE-BASE fame has added a write-up of all the steps required to get 11gR2 RAC on [...]

]]> Comment on Just released VirtualBox 3.2.8 now supports shared disks (think RAC) by Stefano http://www.oraclerant.com/?p=96&cpage=1#comment-456 Stefano Tue, 10 Aug 2010 07:07:26 +0000 http://www.oraclerant.com/?p=96#comment-456 That's really interesting. Any experience about RAC or other software needs shared disks using virtualbox? That’s really interesting. Any experience about RAC or other software needs shared disks using virtualbox?

]]> Comment on RMAN – Veritas NetBackup Integration by Tim http://www.oraclerant.com/?p=7&cpage=2#comment-454 Tim Mon, 09 Aug 2010 18:46:24 +0000 http://www.oraclerant.com/?p=7#comment-454 I have recently had a problem where file system backups worked but RMAN backups failed. The problem was permissions on the bp.conf file on the client. bpclntcmd -pn and bpclntcmd -self also failed on the client before the bp.conf permissions were modified. I have recently had a problem where file system backups worked but RMAN backups failed. The problem was permissions on the bp.conf file on the client. bpclntcmd -pn and bpclntcmd -self also failed on the client before the bp.conf permissions were modified.

]]>