Yes, but I think less capable than RMAN.
Just do a google search for it. Owned by BMC I believe.
Jared
On Monday 13 January 2003 14:34, VIVEK_SHARMA wrote:
Is SQL BackTrack a product like RMAN (from Oracle Corp. or 3rd party )?
-Original Message-
Sent: Tuesday, January 14, 2003
Some of our data is stored in Oracle databases dedicated to Peoplesoft. We have other
databases which require a subset of this information. These other databases are not
all on the same machine. They are either directly tied to physics experiments or they
are subject to certification
SQL BackTrack is a BMC product.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
-Original Message-
Sent: Monday, January 13, 2003 4:35 PM
To:
Listers,
How can one use parallelism when fast refreshing a *single* table?
Pulling my hair out on this one. We want to use parallelism when replicating
updates/inserts from a single partitioned table between DB's -- partitioned
on both DB's. Both are 8.1.7.4 Solaris 8 64 bit. Using fast refresh
Something here doesn't compute. If you tried to use time-based measurements
and didn't find out where the time went - well, bad for you. If you then
stumbled on something, say the database startup/database shutdown ratio (would
normally be fairly close to 1, but could vary) or the log file
Time to check what? If it goes down it could be because your statement(s)
were optimized to use less resources (as documented so well). If it goes
up it could be because your statements became more or less efficient. And
you'd have to check if it was because of an index, a table, a sql
I think Dick is on the right track...
If you have a list of accounts which require an update, load that list into
the database - if it isn't already in the database (please don't tell me
you are creating the script from within Oracle - please don't tell me
that). You could load this list either
And/or get Bjorn Engsigs article (I think it's on MiracleAS.dk under
Technical Information - called cursor.pdf) about some interesting
results regarding cursor sharing.
Mogens
Cary Millsap wrote:
CURSOR_SHARING won't reduce the parse count (total) count; only
eliminating parse calls from your
Thank you all for your help.
I will have to review the metalink data as you suggested.
We have asked that they Bind their SQL Statement but where given no patch
date so it looks like we are out in the cold for awhile.
Once again thanks for all your help.
Jay
- Original Message -
To:
Title: RE: RE : RMAN Repository
I do
have one scenario where you really have to use a recovery catalog... When
attempting to backup a VLDB that usesread only tablespaces and extremely
infrequent backups for most of the data (i.e. a large datawarehouse), a recovery
catalog is very
Title: Internet file system
Oracle
started posting items with the 9.0.3. number, does this imply they plan to
release a 9i Release 3?
regards,
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des systèmes Technology
Services | Services
I think SQLBackTrack can get the table data back from the backup file without the need
to create a partial database on another server and then export the table from it.
I remember seeing a demo where a dropped table was recovered by the BMC rep.
- Kirti
-Original Message-
Sent:
Ethan,
Here is one my 'dist' scripts.
This sends files from HP Server to Sun Servers.
Check that last couple of lines.
HTH,
- Kirti
#
# File Name: dist_all_to_SUN.rdist
#
# This is the distfile for 'rdist' to
SQLBackTrack does not have 'block' recovery, something I think is in the latest RMAN
version (?).
I don't use either of these, but just remember a few things from demos, written
material.
- Kirti
-Original Message-
Sent: Monday, January 13, 2003 6:00 PM
To: Multiple recipients of
Here is my suggestion:
1.
Use file= and filesize= option (8i Rel 2?) to create multiple disk files, copy them
to tape. Reload when importing.
2a.
Export should not be considered a database backup. (IMHO). In future releases,
full=y may not be available.
2b.
Depends. If export starts
Morgens is very correct in saying tha all sorts of measurements have their
place. Actually, the length-of-skirt measurement works very well for me.
Here is the algorithm:
Heat-by-day in inversely proportional to length of skirt which again is
inversely proportional to my desire to have lunch
Yes, well, I've heard that claim too.
It may actually work now, but a very capable DBA ( 2 actually )
spent quite a bit of time testing this with no good results.
And then there was the SQL BT glitch that left one of my former
coworkers without a certain TBS in the DW for 6 weeks.
Yes, 6
doubtful, they've said that release 2 is the final release for 9i
--- Boivin, Patrice J [EMAIL PROTECTED] wrote:
Oracle started posting items with the 9.0.3. number, does this imply
they
plan to release a 9i Release 3?
regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Since 9iR2 is 9.2.0, I don't think that 9.0.3 will be Release 3.
Jared
On Monday 13 January 2003 18:23, Boivin, Patrice J wrote:
Oracle started posting items with the 9.0.3. number, does this imply they
plan to release a 9i Release 3?
regards,
Patrice Boivin
Systems Analyst (Oracle
Gee Dave, I know of a book that has scripts that
already do this. ;)
Here's an untested bit of code to demonstrate.
my $dbh;
eval {
local $SIG{ALRM} = sub {
die connection timeout\n;
};
alarm 60;
$dbh = DBI-connect(
'dbi:Oracle:' . $db,
BTW rajesh, where can I find 'ORA_ENCRYPT_LOGIN variable and
DBLINK_ENCRYPT_LOGIN parameter (for retried attempts across database
link)' ? Pls respond ...
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 10:02 PM
To:
Were you analyzing while rebuilding Indexes ?
If that is the case.. there are chances of possible corruption.
Try to give
select count(*) from table_name;
and
select * from table_name;
Hope this may provide you with some answer.
HTH
- Original Message -
To: Multiple recipients of
Title: RE: Database/system Crashing
Sorry
for getting back to you late on this. In our case, the server crashes each
time with CPU panic message
in
/var/adm/messages. We used adb to analyze the core dump and saw in each
instance of the crash, NFS
lead
to it. It was trying to free memory
101 - 123 of 123 matches
Mail list logo