RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Jeremiah, No, we don't use suspend since these split/hot backup scripts have been in use since V8.0 and I saw no advantage to using suspend. As you say, taking production out of action for no good reason. With regards to using a split controlfile, do you believe there is a difference between this and using a controlfile after a hard system crash? In both cases, consistency will depend on wheather a write to disk was ongoing or completed. I'll have to check with the guru to see if the split code would interrupt a write in progress. In the 4-5 years that we have been creating a reporting instance this way (on a daily basis), nearly all failures could be attributed to bad disks, and this instance is not critical. On the other hand production backups use the same method. I checked my scripts and while the comments say I backup the controlfile, the code does not. I will definitely correct this. Thanks for emphasizing the need for a binary controlfile as part of a complete hot backup. Mike Hand Polaroid Corp. -Original Message- Sent: Wednesday, March 26, 2003 7:24 PM To: Multiple recipients of list ORACLE-L Michael, Your split is no different from a very fast hot backup. So, it does not matter that the split is not atomic. Just use hot backup mode, and generate a binary controlfile using backup controlfile to 'file' and copy it to your destination. A the destination just recover the one or two logs generated while you did the split. Forget about suspend, it serves no purpose and is just decreasing your system's availability. BTW, your current hot-live copies of controlfiles are potentially invalid and totally unsupported. All that expensive equipment and you're suspending! Don't take the thing out of service unnecessarily! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hand, Michael T wrote: > Jeremiah, > The only reason I could forsee is if the split is not atomic. This is the > case > in our (Non-SAN) environment. The split takes several minutes and the > control > files have been mis-matched when the DB copy was started on the reporting > server. > My solution under V8.0 was to use only one of the control files for > reporting > database. > > My $0.02 > Mike Hand -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Mike, I, too, was thinking that the Snapshot or split operation was not atomic and requires a suspension of I/O. However, [see my other posting to Oracle-L], I now believe that Jeremiah is right and that a SUSPEND should not be necessary for the datafiles. Reading postings on MetaLink and reading "between the lines" in the Oracle documentation, it may be the case that some implementations of splitting-mirrors may not work unless I/O is really suspended and that is why Oracle offers the SUSPEND option. EMC and Hitachi do not seem to require a SUSPEND. As for the controlfile, since an ALTER TABLESPACE BEGIN BACKUP doesn't really stop updates to the controlfile, and an OS copy of the controlfile might be "inconsistent" to Oracle, a binary backup would become necessary. The datafile backup by the OS is "inconsistent" but not fuzzy as the ALTER TABLESPACE BEGIN BACKUP command has been issued so Oracle decides to apply archive logs. Hemant At 10:39 AM 26-03-03 -0800, you wrote: Jeremiah, The only reason I could forsee is if the split is not atomic. This is the case in our (Non-SAN) environment. The split takes several minutes and the control files have been mis-matched when the DB copy was started on the reporting server. My solution under V8.0 was to use only one of the control files for reporting database. My $0.02 Mike Hand -Original Message- Sent: Wednesday, March 26, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Why do you have to suspend? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hemant K Chitale wrote: > > We want true server-less backups. I know that RMAN's overhead is [much] lower > than that of the ALTER TABLESPACE BEGIN/END BACKUP but the > Snapshot method in a SAN [akin to splitting and resilivering a mirror, in > some ways] > should be much faster. The database is in BACKUP mode only for the time it > takes the SAN to create the Snapshot which, I've been told, is seconds or > minutes, > irrespective of the size of the database. [Of course, there will be some > time lag > between the first ALTER TABLESPACE BEGIN BACKUP and the > ALTER SYSTEM SUSPEND command when the database will be doing a > Checkpoint at each Tablespace, and writing more Redo for transactions upto > the ALTER SYSTEM SUSPEND and will the END BACKUPs are still being issued.] > > And I cannot use RMAN with the Snapshot method. I must SUSPEND the database > and RMAN does not support that. > > See > http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osba ckup.htm#4233 > "Making Backups in Suspend Mode" in Chapter 4 "Performing Operating System > Backups" > of the 8i Backup and Recovery Guide. > > Hemant > > At 05:38 AM 26-03-03 -0800, you wrote: > >Hemant - If you've got to rework your backup script anyway (and retest it), > >why not consider switching to RMAN at this time? In my experience, > >negligible interference with production during a hot backup. > > > >Dennis Williams > >DBA, 40%OCP, 100% DBA > >Lifetouch, Inc. > >[EMAIL PROTECTED] > > > > > >-Original Message- > >Sent: Tuesday, March 25, 2003 10:49 PM > >To: Multiple recipients of list ORACLE-L > > > > > > > >Some of my databases will be migrating to a SAN. > >Currently, I run hot backups to disk using the > >ALTER TABLESPACE BEGIN BACKUP ; > >host cp ; > >ALTER TABLESPACE END BACKUP > > > >On a SAN, where the vendor promises server-less backups > >using Snapshots, I guess I would have to issue the > >commands : > >ALTER TABLESPACE BEGIN BACKUP > >.. > >.. > >ALTER TABLESPACE BEGIN BACKUP > > > >ALTER SYSTEM SUSPEND > >> take a "snapshot" > >ALTER SYSTEM RESUME > > > >ALTER TABLESPACE END BACKUP > >.. > >.. > >ALTER TABLESPACE END BACKUP > > > > > >Would that be right ? What are real-world experiences > >[bugs / time required for the SUSPEND/RESUME, actually > >flushing all I/O to the disks] ? > > > >The SAN will be a Hitachi 9970 sold by Sun. > >The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. > > > >Hemant K Chitale > >http://hkchital.tripod.com > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Hemant K Chitale > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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.net > >-- > >Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California
RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Michael, Your split is no different from a very fast hot backup. So, it does not matter that the split is not atomic. Just use hot backup mode, and generate a binary controlfile using backup controlfile to 'file' and copy it to your destination. A the destination just recover the one or two logs generated while you did the split. Forget about suspend, it serves no purpose and is just decreasing your system's availability. BTW, your current hot-live copies of controlfiles are potentially invalid and totally unsupported. All that expensive equipment and you're suspending! Don't take the thing out of service unnecessarily! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hand, Michael T wrote: > Jeremiah, > The only reason I could forsee is if the split is not atomic. This is the > case > in our (Non-SAN) environment. The split takes several minutes and the > control > files have been mis-matched when the DB copy was started on the reporting > server. > My solution under V8.0 was to use only one of the control files for > reporting > database. > > My $0.02 > Mike Hand > > -Original Message- > Sent: Wednesday, March 26, 2003 11:04 AM > To: Multiple recipients of list ORACLE-L > > > Why do you have to suspend? > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Wed, 26 Mar 2003, Hemant K Chitale wrote: > > > > > We want true server-less backups. I know that RMAN's overhead is [much] > lower > > than that of the ALTER TABLESPACE BEGIN/END BACKUP but the > > Snapshot method in a SAN [akin to splitting and resilivering a mirror, in > > some ways] > > should be much faster. The database is in BACKUP mode only for the time > it > > takes the SAN to create the Snapshot which, I've been told, is seconds or > > minutes, > > irrespective of the size of the database. [Of course, there will be some > > time lag > > between the first ALTER TABLESPACE BEGIN BACKUP and the > > ALTER SYSTEM SUSPEND command when the database will be doing a > > Checkpoint at each Tablespace, and writing more Redo for transactions upto > > the ALTER SYSTEM SUSPEND and will the END BACKUPs are still being issued.] > > > > And I cannot use RMAN with the Snapshot method. I must SUSPEND the > database > > and RMAN does not support that. > > > > See > > > http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osba > ckup.htm#4233 > > "Making Backups in Suspend Mode" in Chapter 4 "Performing Operating > System > > Backups" > > of the 8i Backup and Recovery Guide. > > > > Hemant > > > > At 05:38 AM 26-03-03 -0800, you wrote: > > >Hemant - If you've got to rework your backup script anyway (and retest > it), > > >why not consider switching to RMAN at this time? In my experience, > > >negligible interference with production during a hot backup. > > > > > >Dennis Williams > > >DBA, 40%OCP, 100% DBA > > >Lifetouch, Inc. > > >[EMAIL PROTECTED] > > > > > > > > >-Original Message- > > >Sent: Tuesday, March 25, 2003 10:49 PM > > >To: Multiple recipients of list ORACLE-L > > > > > > > > > > > >Some of my databases will be migrating to a SAN. > > >Currently, I run hot backups to disk using the > > >ALTER TABLESPACE BEGIN BACKUP ; > > >host cp ; > > >ALTER TABLESPACE END BACKUP > > > > > >On a SAN, where the vendor promises server-less backups > > >using Snapshots, I guess I would have to issue the > > >commands : > > >ALTER TABLESPACE BEGIN BACKUP > > >.. > > >.. > > >ALTER TABLESPACE BEGIN BACKUP > > > > > >ALTER SYSTEM SUSPEND > > >> take a "snapshot" > > >ALTER SYSTEM RESUME > > > > > >ALTER TABLESPACE END BACKUP > > >.. > > >.. > > >ALTER TABLESPACE END BACKUP > > > > > > > > >Would that be right ? What are real-world experiences > > >[bugs / time required for the SUSPEND/RESUME, actually > > >flushing all I/O to the disks] ? > > > > > >The SAN will be a Hitachi 9970 sold by Sun. > > >The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. > > > > > >Hemant K Chitale > > >http://hkchital.tripod.com > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > > >-- > > >Author: Hemant K Chitale > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > >San Diego, California-- Mailing list and web hosting services > > >- > > >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.net > > >-- > > >Author: DENNIS WILLIAMS > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > >San D
RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Jeremiah, The only reason I could forsee is if the split is not atomic. This is the case in our (Non-SAN) environment. The split takes several minutes and the control files have been mis-matched when the DB copy was started on the reporting server. My solution under V8.0 was to use only one of the control files for reporting database. My $0.02 Mike Hand -Original Message- Sent: Wednesday, March 26, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Why do you have to suspend? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hemant K Chitale wrote: > > We want true server-less backups. I know that RMAN's overhead is [much] lower > than that of the ALTER TABLESPACE BEGIN/END BACKUP but the > Snapshot method in a SAN [akin to splitting and resilivering a mirror, in > some ways] > should be much faster. The database is in BACKUP mode only for the time it > takes the SAN to create the Snapshot which, I've been told, is seconds or > minutes, > irrespective of the size of the database. [Of course, there will be some > time lag > between the first ALTER TABLESPACE BEGIN BACKUP and the > ALTER SYSTEM SUSPEND command when the database will be doing a > Checkpoint at each Tablespace, and writing more Redo for transactions upto > the ALTER SYSTEM SUSPEND and will the END BACKUPs are still being issued.] > > And I cannot use RMAN with the Snapshot method. I must SUSPEND the database > and RMAN does not support that. > > See > http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osba ckup.htm#4233 > "Making Backups in Suspend Mode" in Chapter 4 "Performing Operating System > Backups" > of the 8i Backup and Recovery Guide. > > Hemant > > At 05:38 AM 26-03-03 -0800, you wrote: > >Hemant - If you've got to rework your backup script anyway (and retest it), > >why not consider switching to RMAN at this time? In my experience, > >negligible interference with production during a hot backup. > > > >Dennis Williams > >DBA, 40%OCP, 100% DBA > >Lifetouch, Inc. > >[EMAIL PROTECTED] > > > > > >-Original Message- > >Sent: Tuesday, March 25, 2003 10:49 PM > >To: Multiple recipients of list ORACLE-L > > > > > > > >Some of my databases will be migrating to a SAN. > >Currently, I run hot backups to disk using the > >ALTER TABLESPACE BEGIN BACKUP ; > >host cp ; > >ALTER TABLESPACE END BACKUP > > > >On a SAN, where the vendor promises server-less backups > >using Snapshots, I guess I would have to issue the > >commands : > >ALTER TABLESPACE BEGIN BACKUP > >.. > >.. > >ALTER TABLESPACE BEGIN BACKUP > > > >ALTER SYSTEM SUSPEND > >> take a "snapshot" > >ALTER SYSTEM RESUME > > > >ALTER TABLESPACE END BACKUP > >.. > >.. > >ALTER TABLESPACE END BACKUP > > > > > >Would that be right ? What are real-world experiences > >[bugs / time required for the SUSPEND/RESUME, actually > >flushing all I/O to the disks] ? > > > >The SAN will be a Hitachi 9970 sold by Sun. > >The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. > > > >Hemant K Chitale > >http://hkchital.tripod.com > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Hemant K Chitale > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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.net > >-- > >Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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). > > Hemant K Chitale > My personal web site is : http://hkchital.tripod.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTE
RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Why do you have to suspend? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hemant K Chitale wrote: > > We want true server-less backups. I know that RMAN's overhead is [much] lower > than that of the ALTER TABLESPACE BEGIN/END BACKUP but the > Snapshot method in a SAN [akin to splitting and resilivering a mirror, in > some ways] > should be much faster. The database is in BACKUP mode only for the time it > takes the SAN to create the Snapshot which, I've been told, is seconds or > minutes, > irrespective of the size of the database. [Of course, there will be some > time lag > between the first ALTER TABLESPACE BEGIN BACKUP and the > ALTER SYSTEM SUSPEND command when the database will be doing a > Checkpoint at each Tablespace, and writing more Redo for transactions upto > the ALTER SYSTEM SUSPEND and will the END BACKUPs are still being issued.] > > And I cannot use RMAN with the Snapshot method. I must SUSPEND the database > and RMAN does not support that. > > See > http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osbackup.htm#4233 > "Making Backups in Suspend Mode" in Chapter 4 "Performing Operating System > Backups" > of the 8i Backup and Recovery Guide. > > Hemant > > At 05:38 AM 26-03-03 -0800, you wrote: > >Hemant - If you've got to rework your backup script anyway (and retest it), > >why not consider switching to RMAN at this time? In my experience, > >negligible interference with production during a hot backup. > > > >Dennis Williams > >DBA, 40%OCP, 100% DBA > >Lifetouch, Inc. > >[EMAIL PROTECTED] > > > > > >-Original Message- > >Sent: Tuesday, March 25, 2003 10:49 PM > >To: Multiple recipients of list ORACLE-L > > > > > > > >Some of my databases will be migrating to a SAN. > >Currently, I run hot backups to disk using the > >ALTER TABLESPACE BEGIN BACKUP ; > >host cp ; > >ALTER TABLESPACE END BACKUP > > > >On a SAN, where the vendor promises server-less backups > >using Snapshots, I guess I would have to issue the > >commands : > >ALTER TABLESPACE BEGIN BACKUP > >.. > >.. > >ALTER TABLESPACE BEGIN BACKUP > > > >ALTER SYSTEM SUSPEND > >> take a "snapshot" > >ALTER SYSTEM RESUME > > > >ALTER TABLESPACE END BACKUP > >.. > >.. > >ALTER TABLESPACE END BACKUP > > > > > >Would that be right ? What are real-world experiences > >[bugs / time required for the SUSPEND/RESUME, actually > >flushing all I/O to the disks] ? > > > >The SAN will be a Hitachi 9970 sold by Sun. > >The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. > > > >Hemant K Chitale > >http://hkchital.tripod.com > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Hemant K Chitale > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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.net > >-- > >Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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). > > Hemant K Chitale > My personal web site is : http://hkchital.tripod.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
We want true server-less backups. I know that RMAN's overhead is [much] lower than that of the ALTER TABLESPACE BEGIN/END BACKUP but the Snapshot method in a SAN [akin to splitting and resilivering a mirror, in some ways] should be much faster. The database is in BACKUP mode only for the time it takes the SAN to create the Snapshot which, I've been told, is seconds or minutes, irrespective of the size of the database. [Of course, there will be some time lag between the first ALTER TABLESPACE BEGIN BACKUP and the ALTER SYSTEM SUSPEND command when the database will be doing a Checkpoint at each Tablespace, and writing more Redo for transactions upto the ALTER SYSTEM SUSPEND and will the END BACKUPs are still being issued.] And I cannot use RMAN with the Snapshot method. I must SUSPEND the database and RMAN does not support that. See http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osbackup.htm#4233 "Making Backups in Suspend Mode" in Chapter 4 "Performing Operating System Backups" of the 8i Backup and Recovery Guide. Hemant At 05:38 AM 26-03-03 -0800, you wrote: Hemant - If you've got to rework your backup script anyway (and retest it), why not consider switching to RMAN at this time? In my experience, negligible interference with production during a hot backup. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 25, 2003 10:49 PM To: Multiple recipients of list ORACLE-L Some of my databases will be migrating to a SAN. Currently, I run hot backups to disk using the ALTER TABLESPACE BEGIN BACKUP ; host cp ; ALTER TABLESPACE END BACKUP On a SAN, where the vendor promises server-less backups using Snapshots, I guess I would have to issue the commands : ALTER TABLESPACE BEGIN BACKUP .. .. ALTER TABLESPACE BEGIN BACKUP ALTER SYSTEM SUSPEND > take a "snapshot" ALTER SYSTEM RESUME ALTER TABLESPACE END BACKUP .. .. ALTER TABLESPACE END BACKUP Would that be right ? What are real-world experiences [bugs / time required for the SUSPEND/RESUME, actually flushing all I/O to the disks] ? The SAN will be a Hitachi 9970 sold by Sun. The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Hemant - If you've got to rework your backup script anyway (and retest it), why not consider switching to RMAN at this time? In my experience, negligible interference with production during a hot backup. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 25, 2003 10:49 PM To: Multiple recipients of list ORACLE-L Some of my databases will be migrating to a SAN. Currently, I run hot backups to disk using the ALTER TABLESPACE BEGIN BACKUP ; host cp ; ALTER TABLESPACE END BACKUP On a SAN, where the vendor promises server-less backups using Snapshots, I guess I would have to issue the commands : ALTER TABLESPACE BEGIN BACKUP .. .. ALTER TABLESPACE BEGIN BACKUP ALTER SYSTEM SUSPEND > take a "snapshot" ALTER SYSTEM RESUME ALTER TABLESPACE END BACKUP .. .. ALTER TABLESPACE END BACKUP Would that be right ? What are real-world experiences [bugs / time required for the SUSPEND/RESUME, actually flushing all I/O to the disks] ? The SAN will be a Hitachi 9970 sold by Sun. The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
