Re: Archiving in OPS
Thanks to all for your answers, I think that the NFS solution is the one. Tks. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 06, 2002 1:18 PM Metalink has a note on best practices on this. The best method of these in my opinion is to have n unqiue archive destinations (one per instance). Then you can NFS cross mount these destinations to the same location from each instance in your environment. RMAN can then backup/recover the entire database from a single server without having to worry about moving files around. Note that if an instance fails, any of the surviving instances can and will archive logs on behalf of the failed instance to the local instances archive destination. Bill --- Ramon E. Estevez [EMAIL PROTECTED] wrote: Hi list, Scenario OPS 2 nodes, Oracle 8.1.7, AIX. (New dealing with OPS) What is the best solution for implementing archiving in OPS. As far as I understand the 2 instances will be generating archives. If one of the instance goes down, what happen with the destination of those archives ? I will use RMAN with Legato for the backup strategy. I have been gathering tips from the list in those days, but any special recomendations, documentation or scripts about it will be very highly apreciated. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass 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: Ramon E. Estevez 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).
Re: Archiving in OPS
Metalink has a note on best practices on this. The best method of these in my opinion is to have n unqiue archive destinations (one per instance). Then you can NFS cross mount these destinations to the same location from each instance in your environment. RMAN can then backup/recover the entire database from a single server without having to worry about moving files around. Note that if an instance fails, any of the surviving instances can and will archive logs on behalf of the failed instance to the local instances archive destination. Bill --- Ramon E. Estevez [EMAIL PROTECTED] wrote: Hi list, Scenario OPS 2 nodes, Oracle 8.1.7, AIX. (New dealing with OPS) What is the best solution for implementing archiving in OPS. As far as I understand the 2 instances will be generating archives. If one of the instance goes down, what happen with the destination of those archives ? I will use RMAN with Legato for the backup strategy. I have been gathering tips from the list in those days, but any special recomendations, documentation or scripts about it will be very highly apreciated. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass 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).
Archiving in OPS
Hi list, Scenario OPS, 2 nodes, 8.1.7, AIX using raw devices, EMC box. I am new in OPS and have to implement archiving in an OPS environment and configure RMAN to use with LEGATO. My question is how to organize the archives. What will happen if one of the nodes goes down ? I think that the2 nodes have to see each other and write archive files to the same place, for instance I assume that the archive files have to be in the EMC box . I have been gathering very helpful information from the list in the past week about RMAN, but if you have some scripts, some documentation, links about it will be very appreciated. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
RE: Archiving in OPS
Hi, You can not setup your archive logs in EMC storage (RAW). Currently I am working on this project. Oracle recommends that the following setup: SYSTEM / DATA / INDEX / TEMP / OTHER TBLS / REDOLOGS - RAW (EMC storage) ARCHIVE LOGS / ROLLBACK (UNDO) - LOCAL (on each instance) You can use FAILOVER to move archive location. For example: Instance1 Instance2 PROD1PROD2 /d01/arch1 /d02/arch2 If Instance1 goes down, using FAILOVER method, /d01/arch1 will be automatically mounted on Instance2. Check with your UNIX Administrator about FAILOVER mechanism. Muqthar Ahmed DBA -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 12:59 PMTo: Multiple recipients of list ORACLE-LSubject: Archiving in OPS Hi list, Scenario OPS, 2 nodes, 8.1.7, AIX using raw devices, EMC box. I am new in OPS and have to implement archiving in an OPS environment and configure RMAN to use with LEGATO. My question is how to organize the archives. What will happen if one of the nodes goes down ? I think that the2 nodes have to see each other and write archive files to the same place, for instance I assume that the archive files have to be in the EMC box . I have been gathering very helpful information from the list in the past week about RMAN, but if you have some scripts, some documentation, links about it will be very appreciated. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Re: Archiving in OPS
If I understand you correctly, you are referring to "RAW" EMC storage as the shared storage array accessible from all nodes in the cluster, while "local" is local storage that is only accessible from the node to which it is directly attached? If so, then putting the tablespaces on that "local" storage will never work. Likewise, if the rollback tablespaces were also not in "raw" devices; it would never work (unless you are using a clustered file-system such as available on Tru64). In both cases, OPS/RAC would fail to startup... - Original Message - From: Muqthar Ahmed To: Multiple recipients of list ORACLE-L Sent: Thursday, June 06, 2002 1:48 PM Subject: RE: Archiving in OPS Hi, You can not setup your archive logs in EMC storage (RAW). Currently I am working on this project. Oracle recommends that the following setup: SYSTEM / DATA / INDEX / TEMP / OTHER TBLS / REDOLOGS - RAW (EMC storage) ARCHIVE LOGS / ROLLBACK (UNDO) - LOCAL (on each instance) You can use FAILOVER to move archive location. For example: Instance1 Instance2 PROD1PROD2 /d01/arch1 /d02/arch2 If Instance1 goes down, using FAILOVER method, /d01/arch1 will be automatically mounted on Instance2. Check with your UNIX Administrator about FAILOVER mechanism. Muqthar Ahmed DBA -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 12:59 PMTo: Multiple recipients of list ORACLE-LSubject: Archiving in OPS Hi list, Scenario OPS, 2 nodes, 8.1.7, AIX using raw devices, EMC box. I am new in OPS and have to implement archiving in an OPS environment and configure RMAN to use with LEGATO. My question is how to organize the archives. What will happen if one of the nodes goes down ? I think that the2 nodes have to see each other and write archive files to the same place, for instance I assume that the archive files have to be in the EMC box . I have been gathering very helpful information from the list in the past week about RMAN, but if you have some scripts, some documentation, links about it will be very appreciated. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
RE: Archiving in OPS
Hi, Yes you are correct.I am using Oracle9i RAC (Real Application Cluster). Muqthar Ahmed DBA -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 4:44 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Archiving in OPS If I understand you correctly, you are referring to "RAW" EMC storage as the shared storage array accessible from all nodes in the cluster, while "local" is local storage that is only accessible from the node to which it is directly attached? If so, then putting the tablespaces on that "local" storage will never work. Likewise, if the rollback tablespaces were also not in "raw" devices; it would never work (unless you are using a clustered file-system such as available on Tru64). In both cases, OPS/RAC would fail to startup... - Original Message - From: Muqthar Ahmed To: Multiple recipients of list ORACLE-L Sent: Thursday, June 06, 2002 1:48 PM Subject: RE: Archiving in OPS Hi, You can not setup your archive logs in EMC storage (RAW). Currently I am working on this project. Oracle recommends that the following setup: SYSTEM / DATA / INDEX / TEMP / OTHER TBLS / REDOLOGS - RAW (EMC storage) ARCHIVE LOGS / ROLLBACK (UNDO) - LOCAL (on each instance) You can use FAILOVER to move archive location. For example: Instance1 Instance2 PROD1PROD2 /d01/arch1 /d02/arch2 If Instance1 goes down, using FAILOVER method, /d01/arch1 will be automatically mounted on Instance2. Check with your UNIX Administrator about FAILOVER mechanism. Muqthar Ahmed DBA -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 12:59 PMTo: Multiple recipients of list ORACLE-LSubject: Archiving in OPS Hi list, Scenario OPS, 2 nodes, 8.1.7, AIX using raw devices, EMC box. I am new in OPS and have to implement archiving in an OPS environment and configure RMAN to use with LEGATO. My question is how to organize the archives. What will happen if one of the nodes goes down ? I think that the2 nodes have to see each other and write archive files to the same place, for instance I assume that the archive files have to be in the EMC box . I have been gathering very helpful information from the list in the past week about RMAN, but if you have some scripts, some documentation, links about it will be very appreciated. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121