Re: Re[2]: About parallel server
Dick, Just curious, I can see putting the control file on a file system but I failed to see how can you put online redo logs on file system in OPS. Unless you are using distributed file system? How does one node do instance recovery for the failed node? Richard Ji [EMAIL PROTECTED] 05/31/01 01:10AM Brian, I was looking at parallel server for an application we were developing last year. In 8.1.6 at least the control and on-line redo (not rollback segment) files no longer had to be on raw devices. And I stand corrected, there is one and only one standard unix command that does work, dd. It's just such a pile of alphabet soup. That's why we hired a couple of top notch Unix admins. They handle it. Dick Goulet -- Reply Separator -- Author: Brian MacLean [EMAIL PROTECTED] Date: 5/30/01 3:50 PM Your point 1: Unless things have changed redo and controlfiles must be raw. When I took the OPS course several years ago and worked with OPS we needed the redo/controlfiles to be on raw so that one instance could recover when another instance failed. Your point 5: The Unix command dd will do raw. -Original Message- Sent: Wednesday, May 30, 2001 3:48 PM To: Multiple recipients of list ORACLE-L Fernando, Replies included in your original mail, but in addition: Parallel server is a separately priced option from Oracle and it is pricey. Second you may need specific software from you OS vendor to coordinate the file sharing between the servers, again an additional expense. Dick Goulet Reply Separator Author: Fernando Papa [EMAIL PROTECTED] Date: 5/30/2001 2:07 PM Hi everybody! I have some questions about parallel server. Now we have only one instance stand-alone (no parallel), but we are thinking to switch to parallel server because we have a couple of sparc 3500 and nobody are using it, and we think it's good for increase our processing power. The problem is I didn't work with parallel server and I have a lot of questions about it: 1) Is mandatory to use raw devices for control files, redo logs data files? -- Data files yes, redo and control files can be on cooked file system. 2) How we transfer our cooked data files to raw devices data files? import/export? or exist another better (fast) method? -- To the best of my knowledge your going to have to rebuild the database from scratch so imp/exp is your only option. 3) If I start with only one node, performance will be the same of one single instance (no parallel)? -- Yes and NO, raw devices run a little faster than cooked files since the OS's buffer cache is not in the middle. 4) Somebody know how to work with raw devices under solaris? any link? I try to found someting in metalink but there's no samples... -- Working with raw devices is very different from cooked file systems. If you don't have an experienced Unix admin you could be in serious trouble. 5) What about backup? I can't put tablespaces in backup mode and copy with cp... maybe it's time to use rman? -- Rman can handle the backups, but a file system level backup is different. CP does not work anymore, nor does fbackup, or tar. You'll need specialized software for the purpose. Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Re[2]: About parallel server
Dick, I am not sure which platform you where using for OPS, but you have to use raw device's. Unless you are using OpenVMS or Compaq TRU64 v5.1 you have to use raw devices for datafiles, controlfiles and online redo logs. Archive logs have to go to a file system. Now there are some unsupported things you can do to get Oracle datafiles on filesystems in an OPS environment but the key word here is unsupported. Scott Brian, I was looking at parallel server for an application we were developing last year. In 8.1.6 at least the control and on-line redo (not rollback segment) files no longer had to be on raw devices. And I stand corrected, there is one and only one standard unix command that does work, dd. It's just such a pile of alphabet soup. That's why we hired a couple of top notch Unix admins. They handle it. Dick Goulet -- Reply Separator -- Author: Brian MacLean [EMAIL PROTECTED] Date: 5/30/01 3:50 PM Your point 1: Unless things have changed redo and controlfiles must be raw. When I took the OPS course several years ago and worked with OPS we needed the redo/controlfiles to be on raw so that one instance could recover when another instance failed. Your point 5: The Unix command dd will do raw. -Original Message- Sent: Wednesday, May 30, 2001 3:48 PM To: Multiple recipients of list ORACLE-L Fernando, Replies included in your original mail, but in addition: Parallel server is a separately priced option from Oracle and it is pricey. Second you may need specific software from you OS vendor to coordinate the file sharing between the servers, again an additional expense. Dick Goulet Reply Separator Author: Fernando Papa [EMAIL PROTECTED] Date: 5/30/2001 2:07 PM Hi everybody! I have some questions about parallel server. Now we have only one instance stand-alone (no parallel), but we are thinking to switch to parallel server because we have a couple of sparc 3500 and nobody are using it, and we think it's good for increase our processing power. The problem is I didn't work with parallel server and I have a lot of questions about it: 1) Is mandatory to use raw devices for control files, redo logs data files? -- Data files yes, redo and control files can be on cooked file system. 2) How we transfer our cooked data files to raw devices data files? import/export? or exist another better (fast) method? -- To the best of my knowledge your going to have to rebuild the database from scratch so imp/exp is your only option. 3) If I start with only one node, performance will be the same of one single instance (no parallel)? -- Yes and NO, raw devices run a little faster than cooked files since the OS's buffer cache is not in the middle. 4) Somebody know how to work with raw devices under solaris? any link? I try to found someting in metalink but there's no samples... -- Working with raw devices is very different from cooked file systems. If you don't have an experienced Unix admin you could be in serious trouble. 5) What about backup? I can't put tablespaces in backup mode and copy with cp... maybe it's time to use rman? -- Rman can handle the backups, but a file system level backup is different. CP does not work anymore, nor does fbackup, or tar. You'll need specialized software for the purpose. Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Re[2]: About parallel server
Brian, I was looking at parallel server for an application we were developing last year. In 8.1.6 at least the control and on-line redo (not rollback segment) files no longer had to be on raw devices. And I stand corrected, there is one and only one standard unix command that does work, dd. It's just such a pile of alphabet soup. That's why we hired a couple of top notch Unix admins. They handle it. Dick Goulet -- Reply Separator -- Author: Brian MacLean [EMAIL PROTECTED] Date: 5/30/01 3:50 PM Your point 1: Unless things have changed redo and controlfiles must be raw. When I took the OPS course several years ago and worked with OPS we needed the redo/controlfiles to be on raw so that one instance could recover when another instance failed. Your point 5: The Unix command dd will do raw. -Original Message- Sent: Wednesday, May 30, 2001 3:48 PM To: Multiple recipients of list ORACLE-L Fernando, Replies included in your original mail, but in addition: Parallel server is a separately priced option from Oracle and it is pricey. Second you may need specific software from you OS vendor to coordinate the file sharing between the servers, again an additional expense. Dick Goulet Reply Separator Author: Fernando Papa [EMAIL PROTECTED] Date: 5/30/2001 2:07 PM Hi everybody! I have some questions about parallel server. Now we have only one instance stand-alone (no parallel), but we are thinking to switch to parallel server because we have a couple of sparc 3500 and nobody are using it, and we think it's good for increase our processing power. The problem is I didn't work with parallel server and I have a lot of questions about it: 1) Is mandatory to use raw devices for control files, redo logs data files? -- Data files yes, redo and control files can be on cooked file system. 2) How we transfer our cooked data files to raw devices data files? import/export? or exist another better (fast) method? -- To the best of my knowledge your going to have to rebuild the database from scratch so imp/exp is your only option. 3) If I start with only one node, performance will be the same of one single instance (no parallel)? -- Yes and NO, raw devices run a little faster than cooked files since the OS's buffer cache is not in the middle. 4) Somebody know how to work with raw devices under solaris? any link? I try to found someting in metalink but there's no samples... -- Working with raw devices is very different from cooked file systems. If you don't have an experienced Unix admin you could be in serious trouble. 5) What about backup? I can't put tablespaces in backup mode and copy with cp... maybe it's time to use rman? -- Rman can handle the backups, but a file system level backup is different. CP does not work anymore, nor does fbackup, or tar. You'll need specialized software for the purpose. Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Text Item
