Orr, Steve,
Sorry for my late feedback. I went back home and did not receive the
mail.
As i said, i have two node running 9i rac, with the same load from the
middleware(load balancing is done with hardware alton and middle ware tuxedo).
The followi
Good morning everyone,
Thanks for confirming my belief. He was so definite I was starting to doubt
myself (surely a Unix SA must know how the Unix parameters work right?).
And the problem has been tracked down to a bad network switch (so I'm in the
office again today to switch to our standby box
Ora-00205 means that oracle can not find one or more control files.
Check your init.ora parameters.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Sunday, November 24, 2002 1:23 AM
> ver 8i NT4.o
> all services have been set t
Dear gurus!
We are evaluating a "strange" way to "recover" a production DB.
This is a 3.7 TB database, still growing, with LOTS of data inserted every 5
minutes (and several partitions belonging to several tables get dropped each
day - we keep historical data for 90 days back), which we used to bac
Hello Andrey
You can use the DataBee (www.databee.com) to generate scripts for the
creation of the database.
I think that you can create a small database, with the same sid and
directory structure, on another machine and apply all the scripts there.
Then you copy the files to a backup directory o
please help me with this one
the location mentioned in the init.ora for control files does not
have any control file.
since this is a new install, please let me know how to generate or
rather recreate control file(s).
[since there are no control file the system is unable to start]
since instance
If you haven't created the database yet, look at the 'create database'
command. The controlfiles get created when you create the database.
If you already created a database, what happened to your controlfiles?
Anyway, if you lost them, you can always use the 'create controlfile'
command to get them
Hmm, I think the error is right there in a snippet fo the alert log in
the poster's original message. ORA-205 "Error in identifying
controlfile."
The database will not start because Oracle cannot find or access one
or more of the controlfiles.
Are all the postings today about controlfiles?
--
Je
Looks like your database is playing two roles. OLTP for heavily insertion
and keeping historical data as well for 90 days.
I would recommend separate the two functionalities. A small OLTP database
for insertion which only keeps a day or so worth of data. This way you
can recover it quickly. A
>if that SGA + user processes > shmmax the system will start swapping.
That's not true. If your SGA is bigger than shmmax, it just means
the SGA will be fit into multiple shared memory segments. Doesn't
necessary mean the system will start swapping. Is the scan rate
going up?
Richard
-Ori
Yes, the poster clarified that it was a missing controlfile. I have a reply
that catered to the missing controlfile issue.
From: Jeremiah Wilton <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: instance shutdown problem
Someone has just told me you can't do an RMAN backup of a clone because it has
the same database id as the original. Is this true or not? If so, how to get
around it?
Thanks,
Doug
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Doug C
INET: [EMAIL PROTECTED]
Fat
Andrey,
I am not sure I understand "We can now import the large data tables -
partition by partition..And I don't care if THIS step will take 2 weeks.".
Didn't you mention that you couldn't afford 48 hours of recovery?
Import is extremely slow, and I would not recommend exp/imp for backup
recover
Actually, even without the date field, queries will still benefit from the
partition-wise join on the charge_id column. You would see something like this
(partition hash all) in the plan:
SELECT STATEMENT CHOOSE (Cost=178026)
PARTITION HASH ALL 1:4:1
HASH JOIN
PARTITION RANGE ALL
Just check for the Oracle services in Control Panel-> Services.
ur Instance,TNS should be started. if not start these services and try
connecting.
Regards,
Sathyanarayanan
|+--->
|| john |
|| |
||
17 matches
Mail list logo
