Need Suggestion for RMAN

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)

Re: Data Auditing

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

Backup Strategy

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

Re: Client install from hell

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,

RE: Backup Strategy

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

RE: Find out export from remote locations

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

Re: Droping System User

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

quick q re: column default

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

Problems with Intermedia

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

RE: Find out export from remote locations

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

RE: Find out export from remote locations

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

Transportable tablesapce export on remote server

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:

RE: Need Suggestion for RMAN

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

RE: Droping System User

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

Re: Client install from hell

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

RE: quick q re: column default

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:

Re: Client install from hell

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

RE: Droping System User

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

RE: Client install from hell

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

Re: Backup Strategy

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

Export Hanging

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 -

full db export/import

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

RE: Need Suggestion for RMAN

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

HELP NEEDED: Datafile header info

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

PL/SQL

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]

Re: when user changed password?

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

RE: Export Hanging

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]]

RE: PL/SQL

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

Re: RE: Export Hanging

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

RE: PL/SQL

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

RE: providing 24*7 database ---

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

RE: Bind Variables

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

RE: Droping System User

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

RE: Problems with Intermedia

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

{9i New Feature: Query Flashback }: This one is long

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).

Re: Replacing the pesky '

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

RE: Export Hanging

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

Replacing the pesky '

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

RE: full db export/import

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

RE: Droping System User

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

Re: Replacing the pesky '

[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

Oracle Vs SQL Server

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

RE: Replacing the pesky '

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

Re: Replacing the pesky '

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.

switchover with standby database

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

RE: Replacing the pesky '

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,

RE: Droping System User

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

RE: Oracle Vs SQL Server

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

RE: Backup Strategy

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

Re: Need Suggestion for RMAN

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

Re: RE: Export Hanging

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,

RE: Droping System User

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

RE: switchover with standby database

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

RE: Find out export from remote locations

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,

RE: Backup Strategy

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 ?

SET LINESIZE in SQL*PLUS Worksheet

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.

Re: Export Hanging

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

RE: Replacing the pesky '

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

RE: Droping System User

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 )

RE: Droping System User

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

RE: Backup Strategy

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

RE: switchover with standby database

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

RE: Backup Strategy

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

Re: Re: Export Hanging

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

RE: Backup Strategy

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

RE: SET LINESIZE in SQL*PLUS Worksheet

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

RE: SET LINESIZE in SQL*PLUS Worksheet

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 )

RE: switchover with standby database

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

Re: Re: Export Hanging

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

Statspack Question

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%)

RE: switchover with standby database

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

Re: Statspack Question

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

Implementing os_roles

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

Re:RE: Tools

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

Re: event= to capture deadlock debug info

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

RE: Rebuilding Indexes Question

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

RE: Rebuilding Indexes Question

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

Re: Rebuilding Indexes Question

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

Re: event= to capture deadlock debug info

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

Re: Rebuilding Indexes Question

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

RE: {9i New Feature: Query Flashback }: This one is long

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

RE: Rebuilding Indexes Question

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

import problem

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