Jared
The O/S was upgraded to Win2000. It was not reinstalled, I mean disk
was not formatted, this was done a fly from WinNT TO Win2k. Please
tell me more about the problem with upgrading this as I don't know
much about O/S issues. It's only one application out of 5 that is
having this problem.
Title: Setting profile limits?
Dear
Denham Eva,
Can
explain more detail about the profile limit ?
Because, based on my experiance The profile limit on
oracle is wworking properly.
Everything you have to create one profile first using
command line or you can create the profile using DBA
I had a cron job scheduled to do this...
okay, I hate plugging books on this list (if they are mine I mean), and
I will happily provide the script for free, but it IS documented, with
the script on the CD in the book SQL PL/SQL Annotated Archives.
If you want the script to generate the sql to
Title: Message
Hello All,
I have been relying on RMAN as the primary backup solution in a relatively
large corporate environment for the past three years. We have been running it on
our Unix platforms for versions 8.1.6, 8.1.7, and now 9.2.0.
I frequently provide advice on RMAN to local
check
out note 199416.1 - talks about export corruption on certain
releases. [EMAIL PROTECTED] 1/8/03 2:44:15 PM
Tracy Rahmlow wrote: We attempted to reorg a
table and data corruption resulted. We have isolated the issue and
currently have a tar open with Oracle. But basically, when we
The
difference between loyalty and competence might come in there... hiring
based mostly job interviews and "first impressions" are poor predictors of a
proper fit (read: ensuring competency in a position) within
organisations.
When
there is a crisis, what would a competent manager with
Title: Message
Ron,
I am
using Rman on NT and it works just fine. We are using it with EDM media
manager, writing to external tape units. Everything works as
expected. Kinda slow at times, but my gut feeling is that this is
network/tape unit contention.
Backup, restore and validations are
If re-installing Win2K is not an option, then you have to start with the
assumption that since the other apps are running, there is a problem with
the one app that is not running.
In my opinion it would have been better to rebuild the server from scratch
as a Windows2000 server, instead of
Title: RE: Create Mat View uses DEFAULT TABLESPACE for temp segments?
sigh It's always fun to come out looking a bit dumb in front of
such a prestigious group.
Thanks Jared.
My problem turned out to be the placement of the BUILD clause.
Yes, BUILD IMMEDIATE is the default, but my
Depending on the interdependencies among the modules, youMAY have
to run the creator scriptand the created script several times before all
the objects become 'VALID'.
I
think it would be better to write a PL/SQL scriptwhich repeats the two
steps (1. Find Invalid 2. Compile Invalid) until
Errata..
steps (1. Find Invalid 2. Compile
Invalid)
until all the packages are invalid.
It
should have been...
until
all the objects become valid.
Regards,
Charu
-Original Message-From: Charu Joshi
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003 1:55
PMTo:
Title: Message
My
Oracle Press book, Oracle9i RMAN Backup and Recovery
was written using RMAN on NT and RMAN on UNIX.
I had
no problems using RMAN on NT at all. Of course, there are a number of MML
vendors out there and I only used
one,
so I can't speak for the effectiveness of the others.
Doesn't the same apply to database repository, when it's lost?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 4:14 PM
And how does one go about restoring a database when all
Title: Message
Hi
Ron,
I've
been using RMAN on Windows 2000. I do my backups to disk so I don't have
to deal with third party tape software. Each time I have tested a recovery
it seems to work fine. I am 8.1.7.2, W2K sp2
Lisa Koivu
OracleDork
Administrator Fairfield Resorts, Inc.
Jesse,
Why not log a TAR with Oracle to mention that their tech note pages don't
appear to be working, you can't read them in your LINUX browser...
Yesterday I logged a TAR with them to mention that the OTN iAS security doc
link for 1.0.2.2 is a dead link, and that we can't provide feedback to
Thanks, I'm aware of how to limit the size of backup set pieces by channel
and I was verifying that this was the behavior. Earlier I just said that I
am not sure if that is the case on NT. I tested this last night and this is
not the behavior that NT experiences. On NT the file is not initially
Title: Message
The
public education is so pathetic... I took the mannual produced by US scientists
I guess commissioned by the Senate
(or
something like that) and used it to teach my daughter to read grade 3 level a 4
years old in 4 months spending only
20
minutes a day with here.. very
9i Offers automated recovery of the control file. All you need to know is
where you are making your
control file backups to (tape or disk), and the DBID of the database you
wish to recover the control
file of. If you forget the DBID, not to worry because it's stored in the
file name of the backup
On Thu, 9 Jan 2003, Boivin, Patrice J wrote:
People gravitate toward comfort first and foremost. Why hire someone who
knows more than you and keeps telling you management is incompetent? Think
about it. You will have to work with these new hires on a daily basis, life
is hard enough as
James, try to get a copy of Artists, Craftsmen and Technocrats. Out of
print but you can perhaps a used copy through Amazon.
Regards,
Pat.
-Original Message-
Sent: Wednesday, January 08, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
-Original Message-
To: Multiple
Newbie question time:
We have 8.1.7 running on Win 2000 with about 50 users. The system has
just slowed down dramatically for about 5 minutes, with lots of user
complaints. I suspect one of the developers was loading data or doing
some DML. But how do I find who it is? I found a small piece of
You all do topgrading, don't you, Alex?
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
-Original Message-
Sent: Thursday, January 09, 2003 8:50 AM
To: Multiple recipients of list ORACLE-L
On Thu, 9 Jan 2003,
Igor - Hopefully you won't lose your repository at the same time you lose
all your production database controlfiles. However, if that is happens,
hopefully you were outside the computer room at that moment. ;-)
So, you should be able to recover your repository and/or take a fresh
backup.
Hi List,
I have the below query:
select F1.AMTLICHESKENNZEICHEN AMTLICHESKENNZEICHEN
, F1.OID
, F1.VERKAUFSBEZEICHNUNG
, B1.FAHRZEUGARTTEXT
, B1.FAHRZEUGHERSTELLERTEXT
, B1.FAHRZEUGTYPTEXT
, B1.FIN
, B1.VERKAUFSBEZEICHNUNG
, H1.AUFTRAGSPOSITIONSNR
, H1.DATUMSTR
,
In 9i Oracle can handle control file recoveries just fine without a
repository if configured correctly.
In 8i, you can actually recover the control file even without a repository
but you have to use the dbms_backup_restore package to do so.
I have not heard anything about the repository going
Interesting thread, since I am just embarking on using RMAN. If the
repository is to go away then why bother learning the intricacies of it.
Has anyone else heard the RMAN repository was going away? It appears much
simpler to setup w/out the repository. Besides reporting advantages, what
Title: RE: Oracle DBA Profession hard?
Hard? Ha! Before getting into computers, I was an aircraft mechanic for 24 years. Nothing like changing 250 pound wheel and tire assemblies (12 was my record) on midnight shift outside in the cold and rain for LESS money than I got in my first job in
I have been getting requests on how do I subscribe to the oracle-l-ot
list. In order to help keep off topic posts OFF this list, if you wish
to subscribe to the OT list, please send an email to
[EMAIL PROTECTED]
my apologies to the list and to Jared for this admittedly off-topic
post
Rachel
Title: RE: Query optimization
Have you tried NO_EXPAND?
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Krishnaswamy, Ranganath
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January
Title: RE: Which session is killing performance?
HI Craig, try these scripts
set linesize 200
column username format a15
column idle format a10
column machine format a22
column terminal format a15
column program format a15
select sid,
serial#,
username,
-- process,
ROTFL And it keeps getting funnier every time I read it! :D
Rich
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Orawomen
I prefer it to be Mary showing me
Gene - Which Oracle version(s)? How many instances will you be backing up?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 09, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
Interesting thread, since I am just
One question, don't you have to have the database in no mount state to
recover the controlfile in 8i? You do in 8.0.x.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 10:24 AM
9i Offers automated recovery of the
Title: Message
"manual"?? Details?
-Original Message-From:
Spears, Brian [mailto:[EMAIL PROTECTED]]Sent: Thursday,
January 09, 2003 9:04 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Orawomen
The
public education is so pathetic... I took the mannual produced by US
Title: Message
Keep in mind that our public school education system exists
for the purpose of training (with some education) brainless jocks. They
are trained to bounce a ball up and down or run around on a field of
grass.This exists so that colleges, TV networks, professional sports
teams
Title: RE: RE : RMAN Repository
If you aren't using a repository all you have to do is make sure control file backups are part of the routine. There are 2 ways to backup the backup metadata: 1) the RMAN repository database; 2) backup controlfiles.
Functionally and operationally they're
Gene, i consider it a good redundancy method for recovery.
put the repository on a 24x7 machine, that way if you lose all of the
controlfiles you can still easily restore/recover.
my 2 cents worth.
joe
This is a MIME message. If you are reading this text, you may want to
consider changing
Title: Message
Robert, I am scanning through your book now for the tape write error code
and I don't see it.I look at the documentation
and I cant
tell which will arisedue to the bad tape error.I am on the
tail end of implementing RMAN on HP and
trying to
write some tolerance into the
Robert.. Using controlfile only recoveries...(not using catalog)
We have people spouting that we should only use controlfile
recoveries with RMAN because an Oracle instructor said so and
said this is the future direction...
I would love to do it..but what if
I hadnt heard that the repository
was going away.
I did hear, however, at the IOUG meeting last
year, that the reporting mechanisms were going to be significantly enhanced, putting
it on par with the repository-based reporting. That came directly from
one of the Oracle RMAN
I actually find the repository of little
use. If I have an enterprise with many databases then I will use it for
reporting but that's about it.
It just seems to complicate the overall
administrative costs and thus, the burden/benefit ratio is not all that
good.
RF
Robert G.
Thanks Robert. I just checked your Oracle9i RMAN book and yes you do provide
the steps to recover the control file from the RMAN backup. I can see the
step I missed when I previously tried it myself. Thanks for mentioning that.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
Title: RE: RE : RMAN Repository
I find it useful for organizing and keeping track of my backups so that during recovery it is as simple as running pre-scripted queries to see what I have available - geez am I the only one who likes RMAN and doesn't think it makes things that difficult -
Here
is a quote from my Damager when I send him the link to this marvelous
product:
"
Where do I signup. At a buck and three quarters
an hour I'll replace all of you slackards."
And
told him he will probably get what he paid for :)
-
Kirti
-Original Message-From: Fink,
One simple, and often helpful, option is to
query v$sess_io
Structure:
sid,
block_gets,
consistent_gets,
physical_reads,
block_changes,
consistent_changes
Look for any big numbers - if they are in
physical_reads, the user may have been
hammering the filesystem, the other
Title: RE: RE : RMAN Repository
The only things you can't do with
controlfile RMAN/database metadata is:
1) use previous "incarnations" of the
database for recovery;
Actually, you can, it's just a manual process. This is
documented in the RMAN book. Also, in 9i you can do automated
Actually for recovery of the control file, you have to be in nomount mode.
RMAN will connect to a database as long as the instance is up. So, to
recover
from square one you need to get the instance runninng. In 9i, it's generally
possible to start an instance without even a parameter file, which
Dennis - I am now running 8.1.6 8.1.7 w/out RMAN, soon to upgrade to
9.2 then implement RMAN. I have 25 db instances. I am thinking of
using RMAN w/out a repository unless there aregreat reasons not to
:)
Gene [EMAIL PROTECTED] 01/09/03 11:24AM
Gene - Which Oracle version(s)? How many
The overhead of the repository database is more. With the initial
releases of RMAN (EBU) Oracle was rightly
criticized for the fact that you had to backup the database that holds
information about the database you want to backup.
Getting rid of this silliness seems reasonable to me.
Why
I asked nicely once.
Please limit this to the OT list.
Jared
Boivin, Patrice J [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/09/2003 04:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
Thanks, no problem. :)
Rachel Carmichael [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/09/2003 07:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:to subscribe to the ot list
I have been
* Leftover DLL's that can cause problems
* The directory structure is not Win2k
* I don't know what else, I trust my SA's judgement. :)
Jared
Jackson Dumas [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/09/2003 12:03 AM
Please respond to ORACLE-L
To: Multiple recipients
The first time I read this it did not make sense, but now the light bulb has
finally come on. I'll just add these folks to the s%$list.
Dick Goulet
Reply Separator
Sent: Wednesday, January 08, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L
Tim,
Title: RE: RE : RMAN Repository
Yeah but do you have to pay for another Veritas NetBackup license and server to backup the catalog? If just have one database server and one database license why should I have to buy another license and install another 1-2GB of Oracle software on another
If I loose all my control files can I restore them
by using create control file dump from a similer database .
Title: Message
Glad
someone is interested. My sister also did it for her kids with amazing
results..
http://images.amazon.com/images/P/0671631985.01.LZZZ.gif
Teach Your Child
to Read in 100 easy lessons.
Book : Teach your child to read in 100 easy
lessons.
If you
train a 4 year
Title: RE: RE : RMAN Repository
If I need a database to backup a database then do I need
another database to backup the database that backed up the original database?
Exactly my thoughts.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Orr, Steve
For those not familiar with American Slang, saying You don't know dick.
means You don't know anything.
It was a pun I just could not resist...
-Original Message-
Sent: Thursday, January 09, 2003 11:06 AM
To: Multiple recipients of list ORACLE-L
The first time I read this it did not
If you have good enough information about all your database
files.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 09, 2003 1:18
PM
Subject: lost control files
Paula, i like it and the respository, cause its just my anal-
retentiveness coming out about having 2 places to easily be able to
recover(the repository and control file).
joe
This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message
The earlly versions of rman suggested that you put a 2nd recovery catalog
in one of the databases you are using the real recovery catalog for. Then
you use this to record the backups of the recovery catalog database. I
never headed this advice, altho I do use a recovery catalog for all
I thought that was Jack. Maybe you don't know Jack.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 1:44 PM
For those not familiar with American Slang, saying You don't know dick.
means You don't know anything.
It
Since you are on Weenie-doze:
go to task manager (3 finger salute [alt+ctrl+delete]), and order by CPU
descending, then look at the PID, make a note of it, and run this script,
entering the PID:
column log_tim format a18
col username format a12
col osuser for a12
set linesize 132
set verify off
BigP wrote:
If I loose all my control files can I restore them by using create
control file dump from a similer database .
IMHO it is safer to do a manual 'create control file'. Similarity is
always just up to a point and gives you a false sense of security. And
BTW if you lose
But if u look at the control file dump script . It
doesn't say anything about creation date or scn or anything . All it has
is list of datafiles , logfiles .. etc. If my other db on another server is
layed out exactly same . wny can't I use that control file , just change db name
.
-Bp
OID is the *ONLY* LDAP solution certified for use by Oracle software.
However, they do seem to support some sort of replication between OID and
other LDAPs. For example, if you want to use SunOne for Oracle names
resolution (as opposed to TNSNAMES.ORA or ONAMES) you will still need to
have OID in
Hi:
My objective is to see if there is anything that I can change on db setting
to increase the performance, without modifying application code (BTW, we
already looked at all application code at least 5 times and would like to
see if our db setting is good).
Guang
-Original Message-
No. It would be like getting amnesia and just using
the memories of someone that looks like you.
The data stored in the control files is unique to
that database. It contains location of files, database name, recovery info etc.
David L Phillips
Database Consultant (8i OCP)
Digital
I like using a repository because I hate to document. Every is there for
the asking.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 1:49 PM
Paula, i like it and the respository, cause its just my anal-
Steve - My theory is that if your site is sufficiently large to be worth
considering an RMAN catalog configuration, then you can easily find a
location for it. For us, that was easily solved. If Oracle had created a
non-database solution, then that would have become a development project all
its
Ference,
Oracle on Windows runs as one multithreaded process, so you wouldn't get
specific session id sorting list of processes by CPU.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 09,
Robert - Thank you! I will go with the KISS principle anytime.
Gene [EMAIL PROTECTED] 01/09/03 11:45AM
I actually find the repository of little
use. If I have an enterprise with many databases then I will use it for
reporting but that's about it.
It just seems to complicate the overall
Gene - I would think your site would be just what the repository was
designed for. You could use a single repository for all 25 databases. Then
each day you could execute a simple query and receive an exception report
that tells you any backup vulnerabilities for any of the 25 systems. Without
the
Then you should look into statspack and get a copy of Oracle Performance
Tuning 101.
-Original Message-
Sent: Thursday, January 09, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
Hi:
My objective is to see if there is anything that I can change on db setting
to increase the
HTH
===
If someone ever says You don't know Jack Shit, here is the perfect
response. Who is Jack Schitt?
The lineage is finally revealed. Many people are at a loss for a
response when someone says You don't know Jack Schitt. Now you can
Guang - If you're not familiar with it, go to http://www.hotsos.com/ and get
Mogens Norgaard's paper, Introducing the V$ Wait Interface. Where is the
database spending it's time? What's the bottleneck?
-Original Message-
Sent: Thursday, January 09, 2003 1:05 PM
To: Multiple recipients
Hi All,
V$LICENSE will show max # of concurrent users since instance startup. Is
there another view or something to determine max # of concurrent sessions
for
each schema?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat
Wrong...I _think_ :)
If he rebuilds them using the correct file placements then
it will work. The only problem is that he will have to open
RESETLOGS and incomplete recovery will be impossible. But
if he has all of his datafiles and is only missing control
files then he can startup nomount and
You can make up a universal script that logs into each an gets the
appropriate info. Just takes a little thinking -its a little more
time but can be done.
Brian
-Original Message-
Sent: Thursday, January 09, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L
Gene - I would think
Umm I'll have to apologize for thinking too quick and letting my inner child
do the typing.
I haven't had to do a manual create of a control file yet (and hope not to).
My paranoia would not allow me to not have a backup control file and
init.ora file etc around.
If you have multiple instances of
I do a cold backup of my repository daily.
Replication of it is not a bad idea, as Arup mentioned,
though I haven't tried it myself.
Speaking of backing up the RMAN repository, does anyone
back them up hot?
Seems to me that would not be a good idea.
Jared
Ruth Gramolini [EMAIL
Ruth,
That's Jack Sh^.
Dick Goulet
Reply Separator
Author: Ruth Gramolini [EMAIL PROTECTED]
Date: 1/9/2003 11:19 AM
I thought that was Jack. Maybe you don't know Jack.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L
Title: Message
OK,
everything I've read so far on using Direct I/O with an Oracle database says
it's a bad idea. Either performance problems or block corruption may
occur. The notes on metalink (132391.1)refer to Tru64 5.0A and 5.1
but not 5.1A (to which we've recently upgraded). So is
Is it an old fashioned backup (non-rman)? I export our rman repository and ftp the
.dmp file to another server.
Jay
[EMAIL PROTECTED] 01/09/03 03:30PM
I do a cold backup of my repository daily.
Replication of it is not a bad idea, as Arup mentioned,
though I haven't tried it myself.
Brian - Not disputing that at all. I even enjoy it when I had some spare
time to sit down and do just that. But why create and maintain something
when Oracle offers it built-in. I can even envision a manager saying I paid
you for WHAT?? We'll consider that time as counting against your vacation.
[EMAIL PROTECTED] wrote:
Hi All,
V$LICENSE will show max # of concurrent users since instance startup. Is
there another view or something to determine max # of concurrent sessions
for
each schema?
Thanks
Rick
AUDIT on connections, and good ol' SQL ...
--
Regards,
Stephane
I believe you can if you use performance monitor and chart by thread.
Rick
Igor Neyman
Not having used RMAN since it's inception, I'm a little confused. Why
couldn't you backup the DB hot, provided it wasn't using RMAN or at least
that repository?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International,
Rick,
There is no such view, but can be very simply obtained by turning on
auditing and placing auditing for connects for user. Later you can aanalyze
the connects and disconnects in a given time period to get max concurrent
access.
HTH.
Arup Nanda
- Original Message -
To: Multiple
1/2. Not necessarily. You only need to
suspend database if your hardware won't let you split the mirror
without
suspending IO. I worked on EMC which
doesn't require that. So all you need to do is put tablespaces
into
backup mode, split the mirror and end
backup mode.
3. Application
Mike,
Compaq SAN and Tru64 and direct I/O have been nothing but trouble in my
recent experience. I put in over 35 hours over Christmas and last
weekend working on recoveries of system crashes. Our problem appears to
have been relating to the fact that several machines had mount points on
disks
Hot backup of the repository is fine as long as you can be
assured that all files needed for a complete recovery are
going to be available.
Recover a hot backup of an RMAN repository to another
server using imcomplete recovery, ( your RMAN server
burned to a crisp, drives and all ), and you
when are you going to put tablespaces back in
normal mode .
I think you should split the mirror and the put the
tablespaces in normal mode . Its not required to to suspend the db prior to
split .
disclaimer : Just thoughts no real
experience
- Original Message -
From:
Jeff,
You are right. It's still possible to create the controlfile by hand using
the CREATE CONTROLFILE command. You can do, in fact you *have* to do
incomplete recovery recover database using backup controlfile until cancel
However, a BIG however, here; you MUST know all the file names
Title: RE: RE : RMAN Repository
You can have a very large site and still do just fine without an RMAN
repository. RE the non-database solution, Oracle has already done that,
it's called the controlfile. I tend to agree with Robert F. who wrote the
book on RMAN where, in another post he wrote,
when I try to create recovery catalog I am getting following error , I have
100M datafile for rman tablespace . what should be problem ?
ORACLE error from recovery catalog database: ORA-01658: unable to create
INITIAL extent for segment in tablespace RMAN
Bp
--
Please see the official
Hi ,
Some precisions :
If you have ONLY LOST the controlfiles after a clean shutdown
(normal or immediate) you can just :
1) startup nomount
2) recreate the controfiles (CREATE CONTROLFILE command)
3) open the database in NORESETLOGS mode.
If you have ONLY LOST the controlfiles after a
Title: RE: RE : RMAN Repository
Hey
Brian,
I only
talk about the way it SHOULD be... not what I actually do.
:-)
I
confess to presently using the suppository,er a repositorybut
anticipate just using control files
after we upgrade to 9i with its enhanced RMAN features. I have a shell
Hello all...
I'm running 9iRAC 9.2.0.2 on Linux 2.4.20 kernel. This is based on the
Oracle Linux+Firewire project:
http://otn.oracle.com/tech/linux/open_source.html
I'm getting the ORA-29702 during database create.
Any ideas?
Sean
-- sqlplus, create database --
SQL onnect / as sysdba;
Guang,
Earlier I posted a response to check java pool and large pool parameters.
Any progress on that?
Arup.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 3:15 PM
Then you should look into statspack and get a copy of
1 - 100 of 123 matches
Mail list logo