RE: may not be necessary -- was RE: Oracle DB Backups on SAN
Chris, What I plan to do is to issue the series of ALTER TABLESPACE BEGIN BACKUP commands, to cover all the tablespaces, _before_ the Snaphshot is created and then issue the ALTER TABLESPACE END BACKUP commands, without using the ALTER SYSTEM SUSPEND. I will be referring to http://www.hds.com/pdf/ods.pdf for the outline of the backup procedure. I wonder if you could send me the Hitachi SAN and Oracle DB scripts in use at your site, or any notes on them ? Hemant At 10:03 AM 28-03-03 -0800, you wrote: We use the 'shadow mirror' process on a Hitachi SAN (with Oracle 8.1.7 on Solaris 8 and Veritas VxFS) successfully to refresh our development db without a suspend, or even hot backup mode. After the hair that I didn't pull out turned gray (though I am not willing to detail the incompetence on a semi-public list), we got the hardware/file system set up correctly and we have done this several times with no trouble. One issue I had with Hitachi support was that they insisted I had to suspend the database at the time of the split when we were seeing data corruption that was clearly unrelated to Oracle behavior. It turned out to be low level misconfiguration, I believe at the Veritas file system level. I never got a satisfactory explanation. Here is my current (possibly inaccurate) understanding of the process. I would be more than happy to be corrected on any of the details. The shadow mirror process is 'atomic' in the sense that there is some kind of journaling so that when the mirror is split, it is done so that the shadow is a copy of the disk at a particular time, so it looks like the disk would look after a crash or a shutdown abort. Oracle crash recovery has worked as advertised, which is sufficient for our development db needs. If we do get a bad mirror, we would be able to resync and resplit quickly. But as I said, we've done this without incident at least 8 or 9 times. The only times we've had to resync and resplit were due to human error. If you are using Shadow mirror, and this is for backup purposes, you may want the extra security of hot backup. But the mirror split should not cause split blocks, so I'm not sure that it would actually do much for you. To be honest, I haven't thought through all the ramifications of using this as a backup method. If you're not using Shadow mirror, but some other mirror method, the above may not apply. Hope this helps. -Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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).
Archive of all our postings at BlackSheepNetworks
Guys, Are you aware of the archives of all our postings to ORACLE-L at http://www.blacksheepnetworks.com/security/resources/oracle-mailinglist/author.html 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: optimal set up of tablespaces on disks??
Thank you Jared!! Mine is OLTP, I need to more room for Data/indexes. I had that book, May be I need to refer again to understand more. Thanks again. From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: optimal set up of tablespaces on disks?? Date: Fri, 28 Mar 2003 19:23:37 -0800 It depends: for maximum IO on redo, with mirrored redo logs: 4 2 x 36 RAID 1 for redo 1 2 x 36 for archive logs 1 2 x 36 for executables 2 8 x 36 RAID 10 for data/indexes ( about 250 gig usable ) If you choose not to let oracle mirror the redo logs, you could take four of those drives and add: 1 4 x 36 RAID 10. It really depends on your requirements. Do you need more room for data? Is this OLTP, DW, Hybrid? Anyway, this is a starting point. You would be wise to purchase and study 'Oracle Performance Tuning 101', available at an Amazon.com near you. Jared On Friday 28 March 2003 15:43, Peter R wrote: Hi Friends, Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX 5L, Would you guys suggest best way of arranging tablespaces across disks!! I have tablespaces like rbs,temp,tools,index,data etc. expecting with RAID 2 x 36.4 gb RAID-I 26 x 36.4 gb RAID -I + 0 Any ideas will greately appreciated. peter. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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: Archive of all our postings at BlackSheepNetworks
Hemant K Chitale wrote: Guys, Are you aware of the archives of all our postings to ORACLE-L at http://www.blacksheepnetworks.com/security/resources/oracle-mailinglist/author.html Great resource for spammers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: Archive of all our postings at BlackSheepNetworks
Archives of this list are and have been posted at several places. Not much you can do about it. Jared On Saturday 29 March 2003 08:48, Hemant K Chitale wrote: Guys, Are you aware of the archives of all our postings to ORACLE-L at http://www.blacksheepnetworks.com/security/resources/oracle-mailinglist/aut hor.html Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
Where's my trace file?
Tired of wading through the long list of trace files to find yours? Here is a quick script to find your sessions process id, which is part of the trace file name. select s.sid, s.serial#, s.username, s.osuser, p.spid from v$session s, v$process p where s.sid = (select sid from v$mystat where rownum = 1) and p.addr = s.paddr; SIDSERIAL# USERNAME OSUSER SPID -- -- -- -- 9 72 BCAdwfink 2628 Now, go out to 'user_dump_dest' and you can find the file with '2628' in the name and there is your trace file. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink 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).
