Dear List,
I need some suggestions for RMAN. For a quite sometime I have seen numerous mails
regarding RMAN.
We have 2 Production Databases located at different sites. We use RMAN to backup the
databases. Daily incremental backups(Archivelogs, ControlFiles,parameter files,
password file)
I do it with triggers for each table .
I capture the old and new values and construct the sql , user,
sysdate,table_name and rowid and insert them to a table . if you want i can
send you one example .
bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Dear all,
I want your suggestions regarding our firm's backup strategy...
Our business starts from 7.00 AM and ends at 2.00 PM ..We can not afford
down times during our business period
Normally , we are doing a cold backup every day using scheduled cold backup
scripts .Is this backup
Farnsworth, Dave [EMAIL PROTECTED] on 10/19/2001 07:15:24 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Simon Anderson/SSplc)
I think I've seen this before, it certainly sounds familiar...
I've no idea what causes it,
Hi,
It will depend on how much data you can afford to lose (in terms of time)?
may be you can do
exp at 8, 9, 10, 11, 12, 13
Cold backup at 14
or perhaps you want to consider RMAN
Sinardy
-Original Message-
Gholam Hussain
Sent: Monday, 22 October 2001 6:00 PM
To: Multiple
If you're using a 8.1.7 version of the database with a 8.0.5 version of the
Client, it's normal. You've to apply the patch.
-Message d'origine-
De : Tatireddy, Shrinivas (MED, Keane)
[mailto:[EMAIL PROTECTED]]
Envoyé : lundi 22 octobre 2001 12:20
À : Multiple recipients of list ORACLE-L
sure dont drop system user.
joe
Ahmed Gholam Hussain wrote:
Hi all ,
I am unable to drop SYSTEM user in the first place ..I am getting this error
while trying to drop it :
SQL drop user system cascade;
drop user system cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive
how do i remove a column's default value?
thanks.
--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maria Aurora VT de la Vega
INET: [EMAIL PROTECTED]
Fat City Network Services
Hi there !!
Hi there,
An application running the Intermedia process ctxhx is seen to b consuming
an unusually high CPU
time thus preventing other applications from running.
Being very new to Intermedia I do not why this is happening. Can somebody
help me on how to
diagnose the problem of high
But the client database is 8.1.5 and the server is 8.1.7
srinivas
-Original Message-
Sent: Monday, October 22, 2001 7:55 AM
To: Multiple recipients of list ORACLE-L
If you're using a 8.1.7 version of the database with a 8.0.5 version of
the
Client, it's normal. You've to apply the
In V$session I am able to find only the session that is connected. But
it is not showing anything in program column.
Can I find the program, that is being executed(here it is export) from
any table?
srinivas
-Original Message-
Sent: Monday, October 22, 2001 6:31 AM
To: Multiple
Hi lists
can anybody shed light on this:
I have a situation, doing mirroring the schemas from one server to
another server.
both databases on the servers are same version 8.1.7
I need to perform export (of server2) from server1 using transportable
tablespace
I am issuing the flwng command:
Oracle and I would advise using the rman catalog database. The 8.1.6 manual
will detail for you the limitations of using the control file approach. One
issue that stands out is... if you lose the control file (all copies), then
you also lose all of the backup info stored in it... this could
Hi Joe,
I am doing that on a test DB .Some guys were able to drop SYSTEM user
without any probem ...But I am facing some problem while droping it ..
Regards ..
-Original Message-
From: Joe Testa [SMTP:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:15 PM
To: Multiple
Dave,
I suspect this is bug 1291239 OUI DISAPPEARS WHILE
INSTALLING OLE DB COMPONENTS that is not yet fixed.
The workaround is to do as Simon said and install in
multiple passes.
1- Choose the custom install type. Select for
installation only the problem component (e.g. Oracle
Provider for
Title: RE: quick q re: column default
alter table tablename modify column default null;
rgds
amar
-Original Message-
From: Maria Aurora VT de la Vega [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject: quick q re:
We have had the same problem for a long time. Work-around was to do a
custom install and pick a few products at a time. Then one day decided to
install Oracle workflow client and did not have a "custom" option. Oracle solved
problem by granting full control to system/everyone on the drive
So - why bother? Your having problems doing it - it SHOULDN'T be done! Why
test something, and if it doesn't work try to get to the bottom of it - when
you should NEVER put it in to practice anyway?
Your wasting precious time that could be spent reading about
tuning/backup/recovery/new features
I do not have any Novell stuff installed. I will try to install as you
suggested. Thanks for the info. I'll let the list know if this worked.
Dave
-Original Message-
Sent: Monday, October 22, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L
Dave,
I suspect this is bug 1291239
We'd need a little more information before we can give any advice
(okay, this group gives advice on no information but..)
Some questions:
1) during the business hours, do you add critical data that you can't
afford to lose to your database? If so, you should be in archivelog
mode. The cold
Hi All,
Oracle 8.1.6.1 NT 4 SP5
I'm facing a problem with all exports hanging on our production database. Tried it
several times, but the export seems to get stuck at different points each time. The
strange part is that at this point v$session_event shows absolutely nothing happening
-
Title: full db export/import
hi list,
i wonder wat actually full db export has benefits over user level export,
cuz full db export also makes the objects of user sys and system as part of the dump file
(if i am right) , but the target database in which we are gonna import that dump file
I agree with you, if you loose controlfile you loose all information
about your backup. Besides that, using recovery catalog you can use stored
scripts to make your backups.
It is a wise decision to have one.
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
809-565-3121
Background:
We have 2 databases (7.3.4.5) on aix 4.3.3. When executing the strings command
(strings system.dbf | pg) on one of the database's datafiles it returns the
database and the
oracle_home location. For example:
prdr:/optc/oracle/rdbms/7.3.4
The other database does not display this
Hi List
suppose i declare a variable as long in pl/sql then can i assign character
strings of length greater than 2k to it?then can i execute it using execute
immediate ??
TIA
Srini
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VeniVas
INET: [EMAIL PROTECTED]
Hi,
I am using Oracle EE 8.1.6.3.0.
I can implement what you suggested in the future.
Thanks a lot,
Sharon
--
From: Deshpande, Kirti [EMAIL PROTECTED]
Date: Sat, 20 Oct 2001 19:41:55 -0500
Subject: RE: when user changed
Title: RE: Export Hanging
Mandar, did you have enough disk available for the export file? You don't say anything about checking your filesystem.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Mandar Shete [SMTP:[EMAIL PROTECTED]]
No,
you have to declare that variable as varchar2, btw it can support a SQL up
to 32K-1 bytes. Do you suppose your SQL will be larger than that size?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
You're right Lisa, forgot to mention that. But we do have more than enough disk space
available. Everything else seems to be ok as well with the OS - logged in as
administrator, so no privilege issues either.
Mandar.
Koivu, Lisa wrote:
Mandar, did you have enough disk available for
Even if it is larger than that, you can probably concatenate multiple 32k-1
strings using the execute immediate command.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, October 22, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
No,
you have to
Title: RE: providing 24*7 database ---
We use a modified version of your duplicate schema idea. But we don't have the objects in different schemas. We use partitioned objects so that we can exchange the partitions with the production tables at a scheduled time. The voodoo is that we use a
What percentage are you estimating? Have you played with that?
-Original Message-
Sent: Saturday, October 20, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L
I have always used the CBO and statistics are generated fairly regularly. I
use the analyze table estimate statistics
Um, I have to disagree, although I must admit I will not try it. Its
a good way for people to get used to backup and recover. And that is
never a bad thing.
-Original Message-
Sent: Monday, October 22, 2001 5:11 AM
To: Multiple recipients of list ORACLE-L
So - why bother? Your
Samir,
interMedia Text, Audio, Image, Video? What version of Oracle? What
platform? We need more info.
We use interMedia Text heavily (Oracle 8.1.6 on Win2k) and I've never seen
the ctxhx process.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP
Query Flashback
This is part 3 of a what will seem to be a never-ending series on new 9i
features. :)
This topic follows up on last weeks on Automated Undo Management(which is a
requirement for Query Flashback).
Could be worse - could be raining,
Replacing those awkward characters comes down to distinguishing between them
used as quotes and used to search for that character.
The sql functions ASCII() and chr() both help here:
SQL select ascii() from dual;
ASCII()
---
39
Mandar - Have you checked you alert log to see if Oracle is writing anything
useful there? Maybe you have, I just didn't see where you mentioned it.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, October 22, 2001 8:50 AM
To: Multiple recipients of
Gotta love Mondays,
We've been through this before, and I usually don't have a problem, but
today my brain must think it's the weekend.
Hey, I've got a bunch of names like O'Brien and O'Reilley where I need to
replace the ' symbol. I've tried every type of combination of single
quotes and
Arslan - I can't think that a full db export has any particular advantages
over the user level export. In theory you have copies of system objects, but
you probably would never want to re-import these. The results could be
pretty bad. And if you lose a system table, you are probably close to
i'm with you kimberly, but i some things, i guess just aint worth digging
too deep into. Kinda like altering user$ to change a username instead of
exp/imp.
joe
[EMAIL PROTECTED] 10/22/01 12:15PM
Um, I have to disagree, although I must admit I will not try
it. Itsa good way for people to
[EMAIL PROTECTED] wrote:
Gotta love Mondays,
We've been through this before, and I usually don't have a problem, but
today my brain must think it's the weekend.
Hey, I've got a bunch of names like O'Brien and O'Reilley where I need to
replace the ' symbol. I've tried every type of
I know this has been addressed before, but now I am the target of upper management to
provide the differences.
Other than OSes that can run either, can anyone point me to white papers or web sites
with a pretty comprehensive comparison between the two?
They are looking for an indepth view of
David,
Try :
select replace('O'||||'brian',,'') from dual;
REPLACE
---
Obrian
Remeber - four single quotes gets you one. The above replaces O'Brian with
OBrian.
In your example:
select replace(lastname,,' ') from adst where lastname like 'O%'
(replacing a single quote with
Hmm, .
select replace(lastname,,'_') from adst where lastname like 'O%';
you will get O_Brien etc.
JP
On Mon 22. October 2001 18:35, you wrote:
Gotta love Mondays,
We've been through this before, and I usually don't have a problem, but
today my brain must think it's the weekend.
Dear gurus !
I'm about to implement Oracle standby database using oracle 8.0.5 .
I need automatic switchover in case of primary site failure , i.e. i need
the standby (secondary) database to get opened automatically should the
primary site fail.
Is there a way to achieve this ?
I know that there
When you need to do single quotes in Oracle, the best way to do it is that
the number of quotes required is twice the number of quotes you want plus
two (2x+2).
So,
SQL select from dual;
'
-
'
SQL select '' from dual;
''
--
''
SQL select '' from dual;
HTH,
Hi,
your error more resembles a media failure than
anything else. Check the status column from
v$datafile. since this is the system datafile u seem
to have lost,you would need a closed full db recovery
.. i.e. is you care to recover your test db :)
Deepak
PS: did you delete the system datafile
Dave,
Here is a site that will give you some of the info you are looking for.
http://searchdatabase.techtarget.com/home/0,,sid13,00.html
Also, there are too many Dave's in the world.
Dave
-Original Message-
Sent: Monday, October 22, 2001 12:21 PM
To: Multiple recipients of list
Hi Rachel ,
Thanks a lot for your response ...Here are some details :
(1)ost of our systems are of kind OLTP.There are some heavy hours of data
processing transactions during the business hours ( Between 2 hours)
(2) The issue is that our Dump files are some how too big and we have
venkat, if you run in nocatalog mode, there are many
things that you cannot do as compared to catalog mode.
refer to the initial lists of the Oracle RMAN USer's
Guide .. and it explicitly lists *all* the things that
you cannot do if you are running rman in nocatalog
mode
so basically, you run in
Thanks Denis - I should have mentioned it - nothing in the alert log either.
Mandar.
[EMAIL PROTECTED] wrote:
Mandar - Have you checked you alert log to see if Oracle is writing anything
useful there? Maybe you have, I just didn't see where you mentioned it.
Dennis Williams
DBA
Lifetouch,
Title: RE: Droping System User
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
I took risk in my test DB by dropping the user 'SYSTEM'. As you tested, the same steps i repeated in mine, all are fine, until before.
Now i shutdown my database and
Keep a couple things in mind when you talk about automating a standby
process:
1. You need to make sure your logs are completely up to date.
2. When you do change from live to the standby, you need to change your
listeners.
3. You would need to automate the open of the standby as well.
4. You
Title: RE: Find out export from remote locations
-Original Message-
From: Tatireddy, Shrinivas (MED, Keane)
[mailto:[EMAIL PROTECTED]]
In V$session I am able to find only the session that is connected. But
it is not showing anything in program column.
Can I find the program,
Hi Kimberly ,
Thanks a lot for your response .
Due to some resource limitation , we can not afford running our database
on archive log always ...
What we are doing now is daily cold backups with weekend based exports ...
Most of our systems are OLTP .. Are we on good track ?
Hello:
Does any one know where to modify SQLPLUS Worksheet
linesize permanently, so it won't wrap text!
This is on Oracle 817 installation. After previous
Oracle install, the worksheet used to view perfectly
and will see everything in one line. But now,
everything is wraped and hard to read.
Hi Mandar,
We had similar problem when we did full db export. What we found was,
export process was hanging when it was reading one of the system table (in
our case, it is SYS.EXU8REFIC). When we saw the execution plan, it is using
ALL_ROWS (there are no stats on sys objects but still it is
Title: RE: Replacing the pesky '
-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
try replace(lastname, ' '' ')
In the same way, if you want to create an object (e.g. table or username) with double quotes in the name, you have to use two double quotes.
SQL
Hi JOE,
The reason I posted this question in the list some time back was that
this was one of tricky questions during one of my interviews( I do not know
what was the senior DBA's goal asking this type of question )
I was amazed when I came to know that it can be droped ( I mean user SYSTEM
)
Title: RE: Droping System User
-Original Message-
From: Ahmed Gholam Hussain [mailto:[EMAIL PROTECTED]]
I am unable to drop SYSTEM user in the first place ..I am
getting this error
while trying to drop it :
SQL drop user system cascade;
drop user system cascade
*
ERROR
If you don't need to do a point-in-time recover then your ok. However,
if you have data that changes in between backups or exports you will lose
data. You are running a risky setup without archive logs. I would fight
like cats and dogs to get the recourses you need or make sure your SLA
does
Thanks a lot Kevin !
I thought of it , hope everything will work , i have no choice actually.
Regarding bullet #3 - this is exactly what i'm asking - how can i automate
the open of the standby ?
Thanks a lot !
-Original Message-
Sent: Monday, October 22, 2001 8:25 PM
To: Multiple
Anmed - I would encourage you to carefully research the exact reason you
can't run in archivelog mode. Besides providing up-to-the-minute recovery,
it can minimize downtime under many other failure modes.
Also, you need to discuss this with your users until everyone is
satisfied what the
Thanks Prasad. I have looked in Metalink but could not find anything that relates
exactly to my situation - as I mentioned before, I can't see any non-idle wait in
either v$session_wait or v$session_event. But I'll try tracing the session to see if
that helps (though I still can't figure out
I realize you have a problem with resource utilization, but what will
cost more: buying disks so you can keep the backups and archived logs
or losing the data because you only have a cold backup from a week ago?
Again, if you can deal with losing a day's worth of data, your cold
backups are
Title: RE: SET LINESIZE in SQL*PLUS Worksheet
In SQL*Plus or in SQL*Worksheet?
IN SQL*Plus, modify your glogin.sql to have SET LINESIZE number you want
in it.
Lisa Koivu
Garbage Man ( and DBA )
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Wendy Y [SMTP:[EMAIL
Yes, that's for SQL*PLUS.
How about SQLPlus Worksheet? Can it be modified also?
Thanks
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
In SQL*Plus or in SQL*Worksheet?
IN SQL*Plus, modify your glogin.sql to have SET
LINESIZE number you want
in it.
Lisa Koivu
Garbage Man ( and DBA )
A broad process overview:
Process:
1. Notification comes in of a down production. -- This needs to be very
reliable.
2. Make sure production is completely down. -- Look for pmon and smon
processes and see if connections are possible.
3. Bring any remaining logs over to the standby -- Use your
I did find it in SQLab (It is by Quest). There was sql running for hours
on this table. Then, I did whatever I mentioned in my earlier mail.
Just to let you know, the table that we had problem wasn't the same table
other people reported in metalink.
Hope this helps.
Prasad
Howdy,
I must not know what I'm doing here. I ran a Statspack report for 2
different periods of time, each an hour long. In the first case, my instance
efficiency percentages look pretty bad. They look like this:
Instance Efficiency Percentages (Target 100%)
Title: RE: switchover with standby database
I would simplify step #7 by adding a second ADDRESS entry in the tnsnames.ora file. Below is a snippet of one of our tnsnames.ora file that could be used for automating the re-pointing of the users. Actually, it's more of a silent redirection than
Hi Bill,
Cache-hit ratios are probably one of the most
irrelevant and misleading metrics that one has to deal
with in the Oracle performance tuning space. You have
real proof in your hands in the form of 2 statspack
reports. Yes you are comparing apples to oranges, as
the performance health of
Using ORACLE 8.1.6 on AIX 4.3, I want to implement ORACLE role security using
os_roles. ORACLE doc says to create UNIX groups with a name in the format
'ora_orasid_rolename_d'.
Even this sample group name is 21 characters long. My UNIX sysadmin says that
I cannot create a UNIX group with more
Thanks Doug,
I haven't had the chance to dowload the file yet, but I will! I appreciate
your response.
Eric.
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 19 Oct 2001 11:38:58 -0800
Eric,
MANY years ago, before the advent of
Hi Deepak,
Thanks for the info. The situation may not be a deadlock. I checked the alert log, no
entries when the lock occured. Also no trace file was generated. On Friday we were
unable to simulate the lock condition (proved the database was pretty indestructable).
At this point I'm not sure
Title: RE: Rebuilding Indexes Question
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
What are the advantages/disadvantages to doing a alter index rebuild
(Oracle 8.0.X) versus dropping and recreating the index.
My personal opinion - if your database is
Jacques
i think oracle puts exclusive locks on the table on
which you are trying to create an index. that reason
should be good enough to use the rebuild online
option instead of create/drop especially for systems
that require to be available all the time
Deepak
--- Jacques Kilchoer [EMAIL
From 1st hand experience, folks need to be warned that
the last time I did this during normal working hours on an
index on a production table, the order entry department
could no longer commit new orders. They were hung
until the index rebuild completed. So use with caution.
Deepak Thapliyal
Hi James,
as per steve's earlier reply to this thread.. you
might be facing hang like situations .. for which
steve suggested taking 2 systemstate dumps from 2 diff
sessions. And you are right that these might not
always throw out ora-600 or trace files
Thx
Deepak
PS: and steve also suggested
and in 9i, almost everything is done online, w/journaling and no
locking.
but thats another week in the future. ;)
joe
Charlie Mengler wrote:
From 1st hand experience, folks need to be warned that
the last time I did this during normal working hours on an
index on a production table, the
As always Joe, we appreciate these updates. And if it is never ending,
that's fine by me. The way you have taken care to write up the features,
issues, and caveats makes me think this series is destined for a
presentation?
Technet also has a series going on regarding 9i features. It is fairly
Title: RE: Rebuilding Indexes Question
re-building online was carried out for one of our huge indexes. It took lots of resouces and slowed down the system performance. The operation had to be cancelled. Though users can still carry out transactions against the concerned table, Oracle uses
hi list,
I have a problem when I try to do import, sometimes
the tables that have p.k. using index are created only with the index and
not with the p.k.
Do you have any suggestion?
thanks in advance
Alon
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alon Ben-Zvi
83 matches
Mail list logo