Re: backup Oracle on Sun Cluster 2.2 ???
For a cold backup, simply shut down all Oracle instances accessing the database to be backed up. There is no need to shut down any Sun or Veritos cluster services. -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 22, 2001 8:10 PM > Hi all, > > I want to perform Oracle cold backup, > > Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered > partitions are not mounted. > > How can I shutdown my database while my cluster is working (How to shutdown > my Oracle with mounted partitions) > > > > Best Regards > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy > 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: Don Granaman 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: backup Oracle on Sun Cluster 2.2 ???
Hi Don Granaman, If I shutdown Oracle, My cluster daemon will startup it back automatically. Regards, sinardy -Original Message- Granaman Sent: Monday, 23 July 2001 1:00 PM To: Multiple recipients of list ORACLE-L For a cold backup, simply shut down all Oracle instances accessing the database to be backed up. There is no need to shut down any Sun or Veritos cluster services. -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 22, 2001 8:10 PM > Hi all, > > I want to perform Oracle cold backup, > > Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered > partitions are not mounted. > > How can I shutdown my database while my cluster is working (How to shutdown > my Oracle with mounted partitions) > > > > Best Regards > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy > 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: Don Granaman 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: Sinardy 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: backup Oracle on Sun Cluster 2.2 ???
I don't see any problem in stopping Oracle Database and keep the cluster running. Stop the database from svrmgr prompt on all nodes using just shutdown normal/immediate and don't execute anything related to cluster. This way u will have access to all shared storage (raw / filesystems) and your database is down for cold backup. Now, if u are using raw shared device, then the backup cab be taken through 'dd' and if u are using filesystems, then u can use anything u want. DESHMUKH SAMBHAJI S "Let's Document it and Call it a Future !" "Sinardy" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: backup Oracle on Sun Cluster 2.2 ??? com 07/22/01 09:10 PM Please respond to ORACLE-L Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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).
RE: backup Oracle on Sun Cluster 2.2 ???
Hi, If I shutdown my database, sun cluster will automatically startup it within a second. Regrads, Sinardy -Original Message- [EMAIL PROTECTED] Sent: Monday, 23 July 2001 2:05 PM To: Multiple recipients of list ORACLE-L I don't see any problem in stopping Oracle Database and keep the cluster running. Stop the database from svrmgr prompt on all nodes using just shutdown normal/immediate and don't execute anything related to cluster. This way u will have access to all shared storage (raw / filesystems) and your database is down for cold backup. Now, if u are using raw shared device, then the backup cab be taken through 'dd' and if u are using filesystems, then u can use anything u want. DESHMUKH SAMBHAJI S "Let's Document it and Call it a Future !" "Sinardy" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: backup Oracle on Sun Cluster 2.2 ??? com 07/22/01 09:10 PM Please respond to ORACLE-L Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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: Sinardy 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: backup Oracle on Sun Cluster 2.2 ???
This should be the case with DLM. Usually DLM goes down and comes up along with the cluster. To make this happen u have to execute following command scadmin clustername ?U filename i.e. clustername.ora_cdb Once u execute above command, they say DLM is registered with the cluster and the DLM goes down and comes up with the cluster automatically. But I don't know what happens when u stop DLM using some DLM command, whether cluster automatically senses it and brings it up within a second or so. I think something similar is configured for db_startup scripts on your cluster. I don't know how it is done for db_startup. Please check in /etc/opt/SUNWconf/conf/cluster_name.ora_cdb and /etc/opt/SUNWconf/conf/cluster_name.cdb U may find something related to this in these configuration files. Read the commented part also. DESHMUKH SAMBHAJI S "Let's Document it and Call it a Future !" "Sinardy" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity. Subject: RE: backup Oracle on Sun Cluster 2.2 com ??? 07/23/01 03:00 AM Please respond to ORACLE-L Hi, If I shutdown my database, sun cluster will automatically startup it within a second. Regrads, Sinardy -Original Message- [EMAIL PROTECTED] Sent: Monday, 23 July 2001 2:05 PM To: Multiple recipients of list ORACLE-L I don't see any problem in stopping Oracle Database and keep the cluster running. Stop the database from svrmgr prompt on all nodes using just shutdown normal/immediate and don't execute anything related to cluster. This way u will have access to all shared storage (raw / filesystems) and your database is down for cold backup. Now, if u are using raw shared device, then the backup cab be taken through 'dd' and if u are using filesystems, then u can use anything u want. DESHMUKH SAMBHAJI S "Let's Document it and Call it a Future !" "Sinardy" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: backup Oracle on Sun Cluster 2.2 ??? com 07/22/01 09:10 PM Please respond to ORACLE-L Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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 O
RE: backup Oracle on Sun Cluster 2.2 ???
Don't know if this will work with Sun but with HP we would stop the database and the cluster (single script), then mount the filesystem locally. Hope it helps. "Sinardy" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity. Subject: RE: backup Oracle on Sun Cluster 2.2 com ??? 07/23/2001 01:45 AM Please respond to ORACLE-L Hi Don Granaman, If I shutdown Oracle, My cluster daemon will startup it back automatically. Regards, sinardy -Original Message- Granaman Sent: Monday, 23 July 2001 1:00 PM To: Multiple recipients of list ORACLE-L For a cold backup, simply shut down all Oracle instances accessing the database to be backed up. There is no need to shut down any Sun or Veritos cluster services. -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 22, 2001 8:10 PM > Hi all, > > I want to perform Oracle cold backup, > > Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered > partitions are not mounted. > > How can I shutdown my database while my cluster is working (How to shutdown > my Oracle with mounted partitions) > > > > Best Regards > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy > 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: Don Granaman 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: Sinardy 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 'Li
RE: backup Oracle on Sun Cluster 2.2 ???
The whole point of clustering is that if your database crashes it is to automatically fail over to the other side, therefore making it impossible to shutdown your database. Something I just thought of though is that I some times edit my startup/shutdown scripts so that maintenance is performed on failover. You could try the same I would guess in Sun. -Original Message- Sent: Sunday, July 22, 2001 10:00 PM To: Multiple recipients of list ORACLE-L For a cold backup, simply shut down all Oracle instances accessing the database to be backed up. There is no need to shut down any Sun or Veritos cluster services. -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 22, 2001 8:10 PM > Hi all, > > I want to perform Oracle cold backup, > > Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered > partitions are not mounted. > > How can I shutdown my database while my cluster is working (How to shutdown > my Oracle with mounted partitions) > > > > Best Regards > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy > 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: Don Granaman 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: Kimberly Smith 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: backup Oracle on Sun Cluster 2.2 ???
The way I would do any maintence on my databases running on HP ServiceGuard is to temporarily take them out of monitoring so that they can't fail over. In HP you can bring each component up separately. However, this is not a task I would undertake just for cold backups. I am more then happy with just hot backups. I can recover from them just as easily as a cold. -Original Message- Sent: Sunday, July 22, 2001 6:10 PM To: Multiple recipients of list ORACLE-L Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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: Kimberly Smith 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: backup Oracle on Sun Cluster 2.2 ???
I believe under the version we use, it's simply haoracle stop to stop the Oracle monitoring. Then you can run your cold backup, and restart the monitoring afterwards with haoracle start Of course, I think we're a major rev behind, and all the "ha*" commands were moving to the scadmin format. This is probably enough to get you pointed the right way? Steve -Original Message- Sent: Sunday, July 22, 2001 8:10 PM To: Multiple recipients of list ORACLE-L Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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: Austin, Steve S 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: backup Oracle on Sun Cluster 2.2 ???
Sorry, I was thinking of Sun PDB Cluster 2.2 for OPS, not the HA cluster. No experience there... -Don Granaman [ceritfiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 23, 2001 11:51 AM > The whole point of clustering is that if your database crashes it is to > automatically fail over to the other side, therefore making it impossible to > shutdown your database. > > Something I just thought of though is that I some times edit my > startup/shutdown scripts so that > maintenance is performed on failover. You could try the same I would guess > in Sun. > > -Original Message- > Sent: Sunday, July 22, 2001 10:00 PM > To: Multiple recipients of list ORACLE-L > > > For a cold backup, simply shut down all Oracle instances accessing the > database to be backed up. There is no need to shut down any Sun or Veritos > cluster services. > > -Don Granaman > [certifiable OraSaurus] ). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).