Setting Cursor Sharing = Force in 8.1.7.3
We are looking into setting up cursor_sharing parameter to FORCE. Has anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any real bad effects of setting it..? I was thinking of going back to my developers and make them use bind variables in their code. If I set the above parameter, they may continue to develop their code the way it is now. Let me know what you all think about it.. Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: Best method to move Filesystems to RAW Devices.
Denis,
Sorry I missed your main question last time. Each datafile in our database
will represent a separate raw device. so question of overwriting files will
never come. If I have 30 datafiles in 5 files systems, I will be creating
30 raw devices with properly sized devices to match my datafile size. As of
now I have created a spreadsheet which is mapping each of datafile to new
raw device. I have taken current size of my datafile + added a buffer size +
growth for next 2 months. Hope this works without any problem. Let me know
what you think about this.
Thanks,
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 3:43 PM
Nat - I think your process looks fine, bearing in mind that I haven't used
raw devices in years. Others on the list use raw on a daily basis, so may
offer some suggestions.
My question was much simpler. Suppose I have a 80-gig. device, and a
20-gig. datafile. Okay, my recollection is that I can use dd to copy that
datafile onto that device. But that leaves 60-gig. (give or take a few megs)
unused. If I copy another datafile to that device, since this isn't a file
system, it will simply overwrite the first file. So I have 60-gig of wasted
space, unless I issue an Oracle command to expand the datafile to use the
rest of the device. You are right, that copying datafiles is MUCH faster
than moving data within Oracle, I'm just curious how you plan to deal with
size mismatches.
Am I missing something here?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-Original Message-
Sent: Friday, September 20, 2002 2:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
We are thinking of doing following steps for our RAW conversions.
Let me know whether it makes sense,
1. Shutdown Database.
2. Take Full Backup
3. Setup all our raw devices ( properly corresponding to our original
filesystem datafiles.)
4. Bring up the database in restricted mode.
4. Bring tablespace offline
5. Use the dd command to move the datafiles to the raw device.
6. Rename the moved datafile
7. Bring the tablespace online
8. repeat this process till you move all you datafiles.
We feel creating table as select * or export /import is not feasible as our
database is big
(around 400 Gigs ) with very large tables.
Thanks,
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 12:18 PM
Nat - I haven't worked with raw for a few years, but from my dim
recollection, since you are managing what is on the device, first the system
administrator had to tell me how many blocks I could write to. I also dimly
recall the AIX issue, but certainly couldn't recall the answer. Anyway, this
means that you have only a single file on the device. Based on that, my
assumption was that you would want to use the entire disk and it would be
unlikely that your file system file would coincidentally the same size as
your raw device, so you would want to precreate a new tablespace with a
datafile of just the right size. That means that you would need to move the
data itself, not just the datafile. Am I missing something here, or just
brain-dead on Friday?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-Original Message-
Sent: Friday, September 20, 2002 9:33 AM
To: Multiple recipients of list ORACLE-L
Mark,
Thanks for the reply. We are on AIX 4.3.
We are not changing hardware when we move on to RAW devices. Our entire
hardware is going to remain same.
We feel dd is the fastest method of copying the files. But we need to figure
out how many blocks
we should skip in raw devices.(point 2 in NOTES below).
We still do not know how to do that. Metalink says if we use RMAN we do not
need to
do any header calculation . Below is the article from metalink..
Thanks again for your suggestions.
goal: How to convert datafile from raw device to file system
a.. fact: Oracle Server - Enterprise Edition
a.. fix:
Use RMAN to move datafiles from raw devices to file system.
1. Connect to the database:
$ sqlplus system/manager@orcl
2. Put the tablespace with the datafile, which should be converted, offline:
SQL> alter tablespace test_ts offline;
3. Start rman and connect it to the database:
$ rman nocatalog target rman/rman@orcl
4. Move the datafile to file system:
RMAN> run {
2> allocate channel c1 type disk;
3> copy datafile '/dev/raw1' to '/u01/oradata/orcl/test_ts.dbf';
4> }
5. Rename the moved datafile:
SQL> alter database rename file '/dev/raw1' to '/u01/oradata/orcl/test_ts.
dbf';
6. Put the tablespace back online:
SQL> alter tablespace test_ts online;
Notes:
==
1. If you are using RMAN as the backup tool then a backup after the
performed
steps is recommended
Re: Best method to move Filesystems to RAW Devices.
Dennis,
We are thinking of doing following steps for our RAW conversions.
Let me know whether it makes sense,
1. Shutdown Database.
2. Take Full Backup
3. Setup all our raw devices ( properly corresponding to our original
filesystem datafiles.)
4. Bring up the database in restricted mode.
4. Bring tablespace offline
5. Use the dd command to move the datafiles to the raw device.
6. Rename the moved datafile
7. Bring the tablespace online
8. repeat this process till you move all you datafiles.
We feel creating table as select * or export /import is not feasible as our
database is big
(around 400 Gigs ) with very large tables.
Thanks,
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 12:18 PM
Nat - I haven't worked with raw for a few years, but from my dim
recollection, since you are managing what is on the device, first the system
administrator had to tell me how many blocks I could write to. I also dimly
recall the AIX issue, but certainly couldn't recall the answer. Anyway, this
means that you have only a single file on the device. Based on that, my
assumption was that you would want to use the entire disk and it would be
unlikely that your file system file would coincidentally the same size as
your raw device, so you would want to precreate a new tablespace with a
datafile of just the right size. That means that you would need to move the
data itself, not just the datafile. Am I missing something here, or just
brain-dead on Friday?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-Original Message-
Sent: Friday, September 20, 2002 9:33 AM
To: Multiple recipients of list ORACLE-L
Mark,
Thanks for the reply. We are on AIX 4.3.
We are not changing hardware when we move on to RAW devices. Our entire
hardware is going to remain same.
We feel dd is the fastest method of copying the files. But we need to figure
out how many blocks
we should skip in raw devices.(point 2 in NOTES below).
We still do not know how to do that. Metalink says if we use RMAN we do not
need to
do any header calculation . Below is the article from metalink..
Thanks again for your suggestions.
goal: How to convert datafile from raw device to file system
a.. fact: Oracle Server - Enterprise Edition
a.. fix:
Use RMAN to move datafiles from raw devices to file system.
1. Connect to the database:
$ sqlplus system/manager@orcl
2. Put the tablespace with the datafile, which should be converted, offline:
SQL> alter tablespace test_ts offline;
3. Start rman and connect it to the database:
$ rman nocatalog target rman/rman@orcl
4. Move the datafile to file system:
RMAN> run {
2> allocate channel c1 type disk;
3> copy datafile '/dev/raw1' to '/u01/oradata/orcl/test_ts.dbf';
4> }
5. Rename the moved datafile:
SQL> alter database rename file '/dev/raw1' to '/u01/oradata/orcl/test_ts.
dbf';
6. Put the tablespace back online:
SQL> alter tablespace test_ts online;
Notes:
==
1. If you are using RMAN as the backup tool then a backup after the
performed
steps is recommended, because otherwise RMAN treats the copied file as a
backup.
2. Usually Oracle datafiles are moved from filesystem to raw devices using
the dd command. Using dd is the fastest method to accomplish it. However, it
is
necessary to know how many blocks to skip in the raw device (e.g. it is
necessary to skip 64K on Tru64 Unix), so that the information necessary for
the Operating System is not overwritten. The information on how many blocks
to
skip is different on the different platforms. Using RMAN there's no
necessity
to know such platform specific information.
.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 19, 2002 5:28 PM
> Hi Nat,
>
> As long as you are not changing hardware platforms, you can use dd. (Of
> course, I assume you're on some flavor of unix, since you didn't mention
> OS.)
>
> You can just do 'dd if=/path/to/filsystem/datafile
> of=/path/to/raw/volume'.
>
> Of course, your database must be down.
>
> -Mark
>
> On Thu, 2002-09-19 at 14:38, Nat wrote:
> > We are planning to move to raw devices for all our existing file
systems.
> > Our database size is around 400 Gig. What is the recommended method that
you
> > guys feel is best as far as time
> > required to convert and ease of conversion.
> >
> > We feel we cannot use export - import as this may take more time for
> > conversion..
> > I checked many documents to find out the best method, there are few
> > suggestions to use RMAN to convert to raw.
> > seems it is fastest. At this point we have not configured RMAN on our
> > databases so this
Re: Backup Strategy - Informal Survey
No we do trust our hot backups. Our databases are mostly idle during early ours of Sunday between 12 AM - 1 AM. So we thought lets go for a cold backup on weekends. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 12:28 PM > On Fri, 20 Sep 2002, Nat wrote: > > > We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our > > database once a week for half an hour for cold bcv splits. So far it has > > worked very well. > > Just curious, why do you do a cold backup weekly? Do you not trust > your hot backups? > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > > - Original Message - > > > > > I'd like to pose a question to you all and get your response. If you are > > > running a database that is larger than 250GB, what place in your backup > > > strategy does a logical export have? Do you do logical exports at all, and > > > if so with what frequency? Do you feel that logical exports are an > > important > > > part of your backup/recovery strategy? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > 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.com -- Author: Nat 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: Backup Strategy - Informal Survey
Our db size is around 350Gig. We have stopped full logical exports since our database size has grown above 200 Gigs. It is just not feasible for us to do the full exports anymore, time it takes to export is too much. We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our database once a week for half an hour for cold bcv splits. So far it has worked very well. So we do not feel logical exports an important part of our backup/recovery strategy. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 10:13 AM > I'd like to pose a question to you all and get your response. If you are > running a database that is larger than 250GB, what place in your backup > strategy does a logical export have? Do you do logical exports at all, and > if so with what frequency? Do you feel that logical exports are an important > part of your backup/recovery strategy? > > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author of several Oracle books you can find on Amazon.com! > > The avalanche has begun, It is too late for the pebbles to vote. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > 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.com -- Author: Nat 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: Best method to move Filesystems to RAW Devices.
Joe, We are planning to move to RAC. Per Oracle RAW devices is must for RAC. As you said, Yes there is little performance gain just moving to RAC and more work to DBA's/SA's. But this seems to be the main requirement for RAC. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 8:53 AM > the first question is WHY go to raw devices?, OPS/RAC? other than those > 2 reasons(and i'm not sure RAC requires it like OPS did), there is very > little performance gain with the advances in filesystem types. > > just curious. > > joe > > > Nat wrote: > > >We are planning to move to raw devices for all our existing file systems. > >Our database size is around 400 Gig. What is the recommended method that you > >guys feel is best as far as time > >required to convert and ease of conversion. > > > >We feel we cannot use export - import as this may take more time for > >conversion.. > >I checked many documents to find out the best method, there are few > >suggestions to use RMAN to convert to raw. > >seems it is fastest. At this point we have not configured RMAN on our > >databases so this suggestion seems to be of no use for us. > > > >Please let me know, if any of you went through this exercise and any > >suggestions and tips will be more beneficial, > > > >Thanks in advance, > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > 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.com -- Author: Nat 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: Best method to move Filesystems to RAW Devices.
Mark,
Thanks for the reply. We are on AIX 4.3.
We are not changing hardware when we move on to RAW devices. Our entire
hardware is going to remain same.
We feel dd is the fastest method of copying the files. But we need to figure
out how many blocks
we should skip in raw devices.(point 2 in NOTES below).
We still do not know how to do that. Metalink says if we use RMAN we do not
need to
do any header calculation . Below is the article from metalink..
Thanks again for your suggestions.
goal: How to convert datafile from raw device to file system
a.. fact: Oracle Server - Enterprise Edition
a.. fix:
Use RMAN to move datafiles from raw devices to file system.
1. Connect to the database:
$ sqlplus system/manager@orcl
2. Put the tablespace with the datafile, which should be converted, offline:
SQL> alter tablespace test_ts offline;
3. Start rman and connect it to the database:
$ rman nocatalog target rman/rman@orcl
4. Move the datafile to file system:
RMAN> run {
2> allocate channel c1 type disk;
3> copy datafile '/dev/raw1' to '/u01/oradata/orcl/test_ts.dbf';
4> }
5. Rename the moved datafile:
SQL> alter database rename file '/dev/raw1' to '/u01/oradata/orcl/test_ts.
dbf';
6. Put the tablespace back online:
SQL> alter tablespace test_ts online;
Notes:
==
1. If you are using RMAN as the backup tool then a backup after the
performed
steps is recommended, because otherwise RMAN treats the copied file as a
backup.
2. Usually Oracle datafiles are moved from filesystem to raw devices using
the dd command. Using dd is the fastest method to accomplish it. However, it
is
necessary to know how many blocks to skip in the raw device (e.g. it is
necessary to skip 64K on Tru64 Unix), so that the information necessary for
the Operating System is not overwritten. The information on how many blocks
to
skip is different on the different platforms. Using RMAN there's no
necessity
to know such platform specific information.
.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 19, 2002 5:28 PM
> Hi Nat,
>
> As long as you are not changing hardware platforms, you can use dd. (Of
> course, I assume you're on some flavor of unix, since you didn't mention
> OS.)
>
> You can just do 'dd if=/path/to/filsystem/datafile
> of=/path/to/raw/volume'.
>
> Of course, your database must be down.
>
> -Mark
>
> On Thu, 2002-09-19 at 14:38, Nat wrote:
> > We are planning to move to raw devices for all our existing file
systems.
> > Our database size is around 400 Gig. What is the recommended method that
you
> > guys feel is best as far as time
> > required to convert and ease of conversion.
> >
> > We feel we cannot use export - import as this may take more time for
> > conversion..
> > I checked many documents to find out the best method, there are few
> > suggestions to use RMAN to convert to raw.
> > seems it is fastest. At this point we have not configured RMAN on our
> > databases so this suggestion seems to be of no use for us.
> >
> > Please let me know, if any of you went through this exercise and any
> > suggestions and tips will be more beneficial,
> >
> > Thanks in advance,
> --
> --
> Mark J. Bobak
> Oracle DBA
> [EMAIL PROTECTED]
> "It is not enough to have a good mind. The main thing is to use it
> well."
> -- Rene Descartes
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark J. Bobak
> 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.com
--
Author: Nat
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: Best method to move Filesystems to RAW Devices.
Dennis, Thanks for the reply. We have not done any benchmarks to find out if there is any performance gain. The main reason for moving to raw devices is to convert our existing database to function on OPS environment and then eventually to 9i RAC. After we move on to raw (without OPS), may be I will post to the list what is the performance increase/decrease, problems encountered.. etc..etc.. Thanks, - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 5:23 PM Nat - I'm assuming you can connect raw devices to your existing system. Myself, I would create new tablespaces and datafiles on the raw devices. Preferably you will use LMT with uniform extents. Then I would use CREATE TABLE AS SELECT NOLOGGING to move the data. Personally I prefer to first rename the original table to something like table1_sav and then create table1 as select * from table1. Eventually when you've checked everything out (taken a backup, backed up the control files) you will drop the table1_sav. But your applications can immediately use the new table with no changes. Then you'll have to recreate indexes, but I don't know any way around that. What performance increase is your benchmarks telling you that you will experience? Oracle had an interesting white paper on their site. In effect it discussed the question "why do all benchmarks show raw much faster than cooked, but nobody sees that sort of performance in production?". Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Thursday, September 19, 2002 1:39 PM To: Multiple recipients of list ORACLE-L We are planning to move to raw devices for all our existing file systems. Our database size is around 400 Gig. What is the recommended method that you guys feel is best as far as time required to convert and ease of conversion. We feel we cannot use export - import as this may take more time for conversion.. I checked many documents to find out the best method, there are few suggestions to use RMAN to convert to raw. seems it is fastest. At this point we have not configured RMAN on our databases so this suggestion seems to be of no use for us. Please let me know, if any of you went through this exercise and any suggestions and tips will be more beneficial, Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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).
Best method to move Filesystems to RAW Devices.
We are planning to move to raw devices for all our existing file systems. Our database size is around 400 Gig. What is the recommended method that you guys feel is best as far as time required to convert and ease of conversion. We feel we cannot use export - import as this may take more time for conversion.. I checked many documents to find out the best method, there are few suggestions to use RMAN to convert to raw. seems it is fastest. At this point we have not configured RMAN on our databases so this suggestion seems to be of no use for us. Please let me know, if any of you went through this exercise and any suggestions and tips will be more beneficial, Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: Hot Backup using EMC /BCV splits
Yes, BCV is also split for control file and online redo logs. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 11:58 AM > You are right that the BCV split should occur at step 2. > Ask him what's the point for step 1 - 3 if he split BCV at step 4. > > Is he also splitting the BCV for control file and online redo logs? > > Richard > > -Original Message- > Sent: Thursday, August 15, 2002 10:59 AM > To: Multiple recipients of list ORACLE-L > > > Hello, > > We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the > backups for the database in following sequence to do the Hot backup. > > 1. Put all tablespaces in the database in Hot backup mode > 2. Sleep 5 > 3. Put all the tablespaces back into normal mode > 4. Split the BCV's > 5. Mount on another machine and backed up from it. > > What I am concerned is with step 4. Split BCV's should be done at step 2 > instead of step 4. > According to our Unix Admin, EMC takes care of consistency and there is no > need for any concern. As per him the split is instant split and EMC > guarantees consistency. > > What do you all think. What is the recommended procedure. > > TIA, > > Nate > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nat > 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: Ji, Richard > 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: Nat 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: Re:Hot Backup using EMC /BCV splits
Thanks a lot for all your resposes. The arugment our SA has is, the split that we doing is an instant split and he says Hot backup mode is required only if it is a Normal BCV split. All this argument started when we were trying setup a clone of our production database using the split copy. When we tried to recreate the control file with different SID, we got following error in our alert log for all our datafiles and control file creation failed. "WARNING! Recovering data file 1 from a fuzzy file. If not the current file it might be an online backup taken without entering the begin backup command." We again refreshed our split and tried to bring up the database without recreating the controlfile. Database came up without any problems and it is running till now without any problems. So the point now he is making is there is nothing wrong in the process of backup and there is no need to alter the script to move the split before end backup. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 11:23 AM > Nate, > > We are using EMC and BCV's each night to create both backups and a reporting > database. Your SA has it WRONG. > > 1) Put all tablespaces in hot backup mode > 2) sleep 5 > 3) split the bcv > 4) return tablespaces to normal > > The reason that this is important has nothing in the world to do with EMC and > everything to do with Oracle. Since switching the database files into and out > of hot backup causes an immediate write to the file headers locking or unlocking > the SCN. Consequently your backups are inconsistent and consequently worthless. > The reason is that when you enter hotbackup mode all of the file SCN's are > frozen giving Oracle a known starting point for recovery's sake. By switching > back to normal mode the RDBMS has no idea of which transactions are in the files > and which are not. It assumes that it is seeing an instance crash and will only > use the on-line redo. Your DB will come up, but don't expect it to stay that > way, ours crashed with "block corruption" 45 minutes later. Believe me, we > tried it due to a misinformed EMC person(that doesn't happen does it?) & failed. > > Dick Goulet > > Reply Separator > Author: "Nat" <[EMAIL PROTECTED]> > Date: 8/15/2002 6:58 AM > > Hello, > > We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the > backups for the database in following sequence to do the Hot backup. > > 1. Put all tablespaces in the database in Hot backup mode > 2. Sleep 5 > 3. Put all the tablespaces back into normal mode > 4. Split the BCV's > 5. Mount on another machine and backed up from it. > > What I am concerned is with step 4. Split BCV's should be done at step 2 > instead of step 4. > According to our Unix Admin, EMC takes care of consistency and there is no > need for any concern. As per him the split is instant split and EMC > guarantees consistency. > > What do you all think. What is the recommended procedure. > > TIA, > > Nate > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nat > 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: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Hot Backup using EMC /BCV splits
Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount on another machine and backed up from it. What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4. According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency. What do you all think. What is the recommended procedure. TIA, Nate -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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).
Rule Based Hint
My queries are running exceptionally good with a rule based optimizer and the cost based is doing a full table scan for the same. Is it good idea to put the RULE hint..? or is there anything I am missing. All my tables are properly analyzed. I thought I should avoid RULE hint as much as possible. any suggestions/comments on this pls.. Thanks in Advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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).
test
test
