I run sar 10 3600 /var/sun/cpuusage.log to monitor the performance
between peak hours ,,, I have 16 Windows 2000 APPLICATION servers running
citrix and some seem to be giving poorer performance than others: If I can
monitor CPU and Memory and pipe it to a batch file, as I do in UNIX, it
will be
I want to alternate host my database to 6 months ago: The media manager
only keeps 2 months of data online and when i recover until etc.. the job
hangs and then finally gives up, obviously as the tape is not inside:
My question is how does Netbackup know which tape to load, or how do I know
which
Recall our Netbackup server holds only 2 months tapes and Im trying to
recover on an alternate host to the beginning of the year. I issue
following :
run {
allocate channel ch1 type 'sbt_tape';
restore controlfile;
alter database mount;
}
then once the current control files are back I issue
I am trying to alternate host to a point in time of 01-01-2002.
I restore current controlfile then run
run {
set until time to_date('01-JAN-2002 03:00:01','DD-MON- HH24:MI:SS');
allocate channel ch1 type 'sbt_tape';restore database;
recover database;
}
The netbackup log asks for a cold
Thanks for reply:
I tried to restore the archivelogs on their own and it still asks for a
backup piece thats on a tape that has been scratched.
I looked at rc_backup_redolog and see lots of entries for the particular
archive log.The last entry (in date order) points to a backup_set that is
on the
I'm on 8.1.6 and the other day I was trying to use a hint on the
GL_INTERFACE table from Oracle Financials (i know OF is rule based)that I
had copied to another database instance and I couldnt get a hint to work.
And i know that Hint is not SQL supported and therefore the syntax has to
be 100%
Thanks to respondee's:
The problem was a host name in etc/system on the netbackup server:
I'm sure the funs not over yet.
Sam
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
You can create a LOGON Trigger to stop users using anything i.e. SQLPLUS
,MSACCESS etc...
I have applied one at our site and works good. I even log people who try to
log in and get them to explain to management their motives. That is a good
deterrent.
The trigger can be written so that only
Hi Tom
Raise an error :
Here is an example
CREATE OR REPLACE TRIGGER SAMLOG
after LOGON ON DATABASE
DECLARE
v_error EXCEPTION;
PRAGMA EXCEPTION_INIT( v_error, -1031 );
T_SESSIONID VARCHAR2(30);
T_USERNAME VARCHAR2(20);
T_OSUSERVARCHAR2(20);
T_PROGRAM VARCHAR2(48);
BEGIN
SELECT
Why do you bother being on this List: The list is here to help fellow
DBA'S. Have you never said to one of your collegues , what is the format of
this command, or how can I do that, when you simply cant be bothered to
look it up in the manual (either your busy or just down right lazy):
Sometimes
Compile it in SQLPLUS
--
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
we are all touchy after the RTFM episode:
I was actually refering to the fact that I received the same question 5
times - it was a joke !:
Regarding the RTFM, I publicly apologize for jumping in when I did not know
the facts. I had not been reading all posts:
Incidentally I sent out 'off line'
In a UNIX system it is better to have more small size datafiles than a few
or one large datafile: The reason is that UNIX aquires an exclusive file
write lock and therefore if you use multiple files you will avoid a
situation where multiple simultaneous writes to data files become
serialized and
Fair Point,
but isn't Async I/O limited to Raw Devices only: If not using raw, many
companies don't, you can still face contention issues.
Also enabling more dbwr processes gives the overhead of more background
processes: I feel that multiple files per tablespace is a workable
compromise.
--
I use this technique only as a failover routine, if the production machine
were to crash: Cloning I would use standards methods as it is much faster:
But once u restored the database you can rename it.
But the steps that I take are
1.Install executables on other machine as same owner and group
I use this technique only as a failover routine, if the production machine
were to crash: Cloning I would use standards methods as it is much faster:
But once u restored the database you can rename it.
But the steps that I take are
1.Install executables on other machine as same owner and group
Im doing an upgrade from 8.1.6. to 8.1.7.4.
Is there any benfit of doing the upgrade from 8.1.6 to 8.1.7, using
ODMA then patching to 8.1.7.4
or
installing 8.1.7, patch it to 8.1.7.4, then ODMA the database from
8.1.6.
any other comments on this upgrade path are welcomed
thanks
Sam
--
We had same problems at 2 sites here. I dont allow access in
Production, I can usually scare management enough to keep them
out and I apply a LOGON trigger to stop any connection from
access (and SQLPLUS etc for that matter, unless its a user that I
allow). I do create a copy of PROD every day
We are upgrading to 8.1.7.4. There are many databases and my
DBA college who is in charge of the RMAN Database that is
currently 8.1.6. tells me that it is no problem that RMAN (Seperate
database by the way) is in 8.1.6 and the Target is in 8.1.7.4.
As RMAN is hot topic right now and before I
As I suspected, now I have to break the news , without breaking the
person
thanks jared
- Original Message -
Date: Tuesday, February 18, 2003 8:43 am
You can't register and 8.1.7 database in an 8.1.6 catalog.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
I have just upgraded my database at the Weekend and I have
noticed that PROGRAM field in V$SESSION no longer displays the
program all the time i.e. SQLPLUS and Microsoft Access in
particular. I use this fields in capturing illegal log ons etc.. Anybody
have an idea before I try Support.
We are concerned on licensing especially as we are setting up a
Disaster Recovery Site. During our Investigation it seems that
TERM licensing can come out cheaper. Anyone have any idea on
this or any disadvantages of leasing the software as opposed to
owning it,
thanks
Sam
--
Please see
I recently upgraded a test server and found out today that it was
hanging. SQLPLUS etc...
I checked alert log and found following errors
WARNING: aiowait timed out 1 times
WARNING: aiowait timed out 2 times
I shutdown and restarted and since then Ive noticed that only
certain queries hang and
Sorry guys I was rushing as I was leaving.
The OS is Solaris 8 and Database Oracle 8.1.7.4
I came in this morning and everything is okay now: But I will now try
and find what happened and if it starts again I will inform - thanks for
replies and any more ideas please dont hesitate
thanks
By the way it was an Application upgrade not O/S or database - I
should have been more clear.
- Original Message -
Date: Monday, June 23, 2003 10:29 pm
Sam,
Can you check if PQ is enabled (via PARALLEL_* ) and you have
PDML/PQ in use
because of DB objects or queries? If so, the
It seems that the new version of Workflow that we implemented had
a massive query running in the background, compound that with we
run 9 companies (multi schema) in one database, that was 9
massive queries running in the background. The thing that I didnt
notice it at first was that because
Unix Solaris 8 and Oracle 8.1.7.4
As part of an upgrade to the Maximo application I run a join on 2
tables:
select count(*) from sys.syskeys s, maxsysindexes m where
s.ixname=m.name;
sys.syskeys is 705 rows and maxsysindexes is 443 rows.
when I trace the statement I find it doing a hash join
This view is part of the upgrade script provided by the Vendor
(duh):
I've been DBA'ing for 7 years in DB2 and Oracle and messing
around with a SYS view is obviously not done- .
I was looking for some proper advise as Ive never seen anything
like it before.
Sam
- Original Message
I havent got original Subject e-mail as it is on my home PC.
Firstly let me just say how I like to use this list. As I am completely
different time zone to you guys i.e. I am Brit living in Middle East,
also our weekends are thu/fri - by the time I read posted questions
they are usually well
29 matches
Mail list logo