Post #210,822
6/10/05 11:01:08 AM
|
anyone with oracle know what these are?
-rw-r----- 1 oracle dba 104857088 Jun 10 09:55 arch_1_0000000140.log
-rw-r----- 1 oracle dba 104857088 Jun 10 09:57 arch_1_0000000141.log
-rw-r----- 1 oracle dba 104857088 Jun 10 09:57 arch_1_0000000142.log
seems to be filling up my disk rather fast
they are in the arch directory in the oradata/tablename/arch
thanx,
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,826
6/10/05 11:07:37 AM
|
You need em.
They are rollback related, the DBA should be taking care of these proper.
If they go away, Oracle might Shit itself.
Usually, you devote a big chunk of disk each to: the DB, the Rollback and the Archive Logs
Only a Hundred MB ea? Either you have a VERY small DB or a TON of these files or Dam, you must not care about problems and restoring from points.
I'd suggest you have a REAL DBA look at the settings for the DB.
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey
[image|http://www.danasoft.com/vipersig.jpg||||]
|
Post #210,831
6/10/05 11:15:18 AM
|
lab box, my care and feeding only
took them out to see what would happen, nothing much so far.
thanx,
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,828
6/10/05 11:09:58 AM
|
If memory serves me correct.
Oracle keeps something like three rotating transaction logs active. These are likely either active transaction logs or ones that have been saved off at a previous point in time.
Of course, you could just delete 'em and find out if they're necessary. :-)
|
Post #210,842
6/10/05 12:27:23 PM
|
ICLRPD (new thread)
Created as new thread #210841 titled [link|/forums/render/content/show?contentid=210841|ICLRPD]
===
Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
|
Post #210,854
6/10/05 2:53:53 PM
|
well I guess I know what Ill be doing the rest of the day
yup Oracle needs them and the control file that lives in that directory, no all I have to do is figure out the sysdba password for this system and rebuild the control files. blech
thanx
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,855
6/10/05 2:58:10 PM
|
Live and learn.
Don't blame me - my smiley was my disclaimer. :-)
|
Post #210,857
6/10/05 3:00:28 PM
|
no problem, I needed to knock it down any way
at least my disks are not filling up. I wouldnt do that in a test or prod box but this one is mine.
thanx,
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,856
6/10/05 2:59:51 PM
|
My rule on unknown files
rename first
delete later
Darrell Spice, Jr. [link|http://spiceware.org/gallery/ArtisticOverpass|Artistic Overpass]\n[link|http://www.spiceware.org/|SpiceWare] - We don't do Windows, it's too much of a chore
|
Post #210,858
6/10/05 3:01:25 PM
|
disk at 100% ripem out then learn something
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,862
6/10/05 4:00:29 PM
|
Compress elsewhere, then learn later.
I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
|
Post #210,872
6/10/05 5:32:52 PM
|
*GRIN*
[link|http://www.runningworks.com|
] Imric's Tips for Living
- Paranoia Is a Survival Trait
- Pessimists are never disappointed - but sometimes, if they are very lucky, they can be pleasantly surprised...
- Even though everyone is out to get you, it doesn't matter unless you let them win.
|
Nothing is as simple as it seems in the beginning,
As hopeless as it seems in the middle,
Or as finished as it seems in the end.
|
|
Post #210,909
6/10/05 11:51:54 PM
|
Yes
You did NOT need them.
They are archived log files.
They come into play if you restore a hot backup and then
need to roll forward the transactions.
The control file, on the other hand, you DID need.
But you should have several of them in different locations,
so if you lose one it is not big deal, just copy another over
to that location.
|
Post #210,910
6/10/05 11:56:03 PM
|
nope only one :-)
busy lad today, copy from another box doing the same job and cursing prior folk who did not keep a consistant naming convention across boxes or a consistant method of backing up control files. Will get the lab setup to my satisfaction this coming week.
thanx,
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,937
6/11/05 11:27:19 AM
|
You CANNOT use one from a different box
Oracle maintains multiple control files for a reason.
Part of the initial instance setup should have created
multiple files on different file systems.
If you create the instance "by hand", using the create
statements within sqlplus, then it was up to you to construct
a suitable ini file for generating multiples, or generating
a single, shutting down the datatbase, copying the original
to multiple locations, mondifyig the ini to point to multiples,
and starting up.
Control files are a picture in time of database "state". How
many data files, what the data file to tablespace mapping is,
what the SCN (think transaction number) is the current one,
when the last time a data file was flushed, etc.
There is simply no point copying from another box.
Oracle is not something you screw around with, without doing
some serious reading first.
Also, a note on ini files. Oracle can be told to maintain a
binary version which is will then maintain for you everytime
you alter the environment of a running database.
DON'T DO IT!!!
They are impossible to figure out.
Use the vanilla ascii one, and maintain it yourself.
|
Post #210,939
6/11/05 1:12:41 PM
|
rm -r oracle
place tarfile of oracle that does the same job on a different machine with same hardware and disklayout on my now oracle free machine. Will report how it works out.
thanx,
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,943
6/11/05 1:38:39 PM
|
The tnsnames will be wrong
This file defines your sqlnet connections. You can accidently setup a local connection to access a remote machine. You THINK you are working on your local box, only to find you are accessing the other one.
Not fun after you've dropped a production table.
|
Post #210,947
6/11/05 2:23:48 PM
|
tnsnames on all boxes point to localhost
its cool. Just my own lab not production
thanx,
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,964
6/11/05 9:01:59 PM
|
OK
|
Post #210,965
6/11/05 9:08:30 PM
|
You might find this helpful
[link|http://www.ibiblio.org/pub/Linux/docs/HOWTO/other-formats/html_single/Oracle-9i-RH8-and-RH9-HOWTO.html|http://www.ibiblio.o...nd-RH9-HOWTO.html]
|
Post #210,970
6/11/05 10:18:28 PM
|
thanks! bookmarked
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #211,178
6/14/05 10:30:21 AM
|
backup and running 4hrs to figure out
that oracle is fucking clueless about soft links. I mean if I link /export/home/oracle to /foo/oracle because I am too lazy to edit 5k path files and a user has $ORACLE_HOME=/foo/oracle I would reasonably expect sqlplus to connect me to the database. Nope gotta have $ORACLE_HOME=/export/home/oracle or it doesnt work.. grumble.....
thanx.
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #211,248
6/14/05 7:03:18 PM
|
Hmm
I've been using softlinks to Oracle home for years.
lrwxrwxrwx 1 root other 23 Feb 4 2001 u01 -> /xy/bfd/oracle_base/u01
lrwxrwxrwx 1 root other 23 Feb 4 2001 u02 -> /xy/bfd/oracle_base/u02
lrwxrwxrwx 1 root other 23 Feb 4 2001 u03 -> /xy/bfd/oracle_base/u03
lrwxrwxrwx 1 root other 23 Feb 4 2001 u04 -> /xy/bfd/oracle_base/u04
lrwxrwxrwx 1 root other 23 Feb 4 2001 u05 -> /xy/bfd/oracle_base/u05
lrwxrwxrwx 1 root other 24 Oct 31 2001 u06 -> /xy/bfd2/oracle_base/u06
lrwxrwxrwx 1 root other 24 Oct 31 2001 u07 -> /xy/bfd2/oracle_base/u07
lrwxrwxrwx 1 root other 24 Oct 31 2001 u08 -> /xy/bfd2/oracle_base/u08
lrwxrwxrwx 1 root other 21 Mar 24 2004 u09 -> /xy/H/oracle_base/u09
lrwxrwxrwx 1 root other 21 Mar 24 2004 u10 -> /xy/I/oracle_base/u10
$ echo $ORACLE_HOME
/u01/app/oracle/product/8.1.7
|
Post #211,251
6/14/05 7:16:00 PM
|
yabut does your user $ORACLE_HOME
point at the same one that you use in the startupDB (startup script where you kick oracle awake and mount the database) mine was different startup script pointing to the link and user pointing at the real file.
made them both the same and it worked.
thanx,
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #211,256
6/14/05 7:43:57 PM
|
Yup
Startup sets this, as well as it being sourced in to login scripts.
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=${ORACLE_BASE}/product/8.1.7
So it was really a matter of them being different, not that it was over a symbolic link for you.
|
Post #211,259
6/14/05 7:49:19 PM
|
but if oracle user uses
oracle_base=/export/home/oracle
and user uses
oracle_base-/foo/oracle and /foo/oracle is where /export/home/oracle really lives it should work.
thanx,
bill
All tribal myths are true, for a given value of "true" Terry Pratchett
[link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #211,262
6/14/05 8:12:56 PM
|
Maybe
Maybe not.
Maybe it's checking for a different Oracle home and considering it an error.
|
