Re: Oracle newbie

--=_18432840.9AFB0F30

Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

JD,
If people are NOT complaining about the performance against this server = then I would not worry about your disk or memory config at this point. The = server is obviously running and people are "happy" (objective #1). I don't = know what Oracle recommends as minimum config, but it is a huge resource = hog so I'd bet their minimum is insufficient. However, as I mentioned, if = everyone is happy, do not worry about this at all at this point.

As for objective #2, as others have already mentioned, doing cold backups = is far easier if you can afford it. This apparently isn't a 24x7 database. = Shutdown immediate, copy all the datafiles, control files, redo logs, = parameter files, etc to a second disk or tape. Startup database.

Is this a critical database? If so make sure it is running in archivelog = mode. You should see something like log_archive_start=3Dtrue and log_archiv= e_dest=3D<some path>. Look in some path and if you see some recent files, = it is enabled. If it is enabled you need to make sure this dest does not = fill up! Keep enough files to cover back to at least 2 cold backups in = your case. You can delete those older than that.

I would spend most of your time learning about backup and recovery. When = objective #1 terminates, your future job will be determined by how good = you did on objective #2 and what would be objective #3 (getting the = database back up quickly with minimal data loss).

What is the reason you (with no experience) have this database now rather = than your "in house oracle person"?

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

>>> DanversJ_at_gunlocke.com 11/06/00 12:04PM >>>
Hi there...

I have inhereted an oracle server that I need to ensure

     1 - runs
                 and
     2 - gets backed up.

--=_18432840.9AFB0F30

Content-Type: TEXT/HTML
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="TEXT.htm"

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by04ODU5LTEiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDUuMDAuMjkxOS42MzA3IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iRk9O VDogOHB0IE1TIFNhbnMgU2VyaWY7IE1BUkdJTi1MRUZUOiAycHg7IE1BUkdJTi1UT1A6IDJweCI+ DQo8RElWPkpELDwvRElWPg0KPERJVj5JZiBwZW9wbGUgYXJlIE5PVCBjb21wbGFpbmluZyBhYm91 dCB0aGUgcGVyZm9ybWFuY2UgYWdhaW5zdCB0aGlzIHNlcnZlciANCnRoZW4gSSB3b3VsZCBub3Qg d29ycnkgYWJvdXQgeW91ciBkaXNrIG9yIG1lbW9yeSBjb25maWcgYXQgdGhpcyBwb2ludC4gVGhl IA0Kc2VydmVyIGlzIG9idmlvdXNseSBydW5uaW5nIGFuZCBwZW9wbGUgYXJlICJoYXBweSIgKG9i amVjdGl2ZSAjMSkuIEkgZG9uJ3Qga25vdyANCndoYXQgT3JhY2xlIHJlY29tbWVuZHMgYXMgbWlu aW11bSBjb25maWcsIGJ1dCBpdCBpcyBhIGh1Z2UgcmVzb3VyY2UgaG9nIHNvIEknZCANCmJldCZu YnNwO3RoZWlyIG1pbmltdW0gaXMgaW5zdWZmaWNpZW50LiBIb3dldmVyLCBhcyBJIG1lbnRpb25l ZCwgaWYgZXZlcnlvbmUgaXMgDQpoYXBweSwgZG8gbm90IHdvcnJ5IGFib3V0IHRoaXMgYXQgYWxs IGF0IHRoaXMgcG9pbnQuPC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj5BcyBmb3Igb2Jq ZWN0aXZlICMyLCBhcyBvdGhlcnMgaGF2ZSBhbHJlYWR5IG1lbnRpb25lZCwgZG9pbmcgY29sZCBi YWNrdXBzIA0KaXMgZmFyIGVhc2llciBpZiB5b3UgY2FuIGFmZm9yZCBpdC4gVGhpcyBhcHBhcmVu dGx5IGlzbid0IGEgMjR4NyBkYXRhYmFzZS4gDQpTaHV0ZG93biBpbW1lZGlhdGUsIGNvcHkgYWxs IHRoZSBkYXRhZmlsZXMsIGNvbnRyb2wgZmlsZXMsIHJlZG8gbG9ncywgcGFyYW1ldGVyIA0KZmls ZXMsIGV0YyB0byBhIHNlY29uZCBkaXNrIG9yIHRhcGUuIFN0YXJ0dXAgZGF0YWJhc2UuPC9ESVY+ DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj5JcyB0aGlzIGEgY3JpdGljYWwgZGF0YWJhc2U/IElm IHNvIG1ha2Ugc3VyZSBpdCBpcyBydW5uaW5nIGluIGFyY2hpdmVsb2cgDQptb2RlLiBZb3Ugc2hv dWxkIHNlZSBzb21ldGhpbmcgbGlrZSBsb2dfYXJjaGl2ZV9zdGFydD10cnVlIGFuZCANCmxvZ19h cmNoaXZlX2Rlc3Q9Jmx0O3NvbWUgcGF0aCZndDsuIExvb2sgaW4gc29tZSBwYXRoIGFuZCBpZiB5 b3Ugc2VlIHNvbWUgcmVjZW50IA0KZmlsZXMsIGl0IGlzIGVuYWJsZWQuIElmIGl0IGlzIGVuYWJs ZWQgeW91IG5lZWQgdG8gbWFrZSBzdXJlIHRoaXMgZGVzdCBkb2VzIG5vdCANCmZpbGwgdXAhIEtl ZXAgZW5vdWdoIGZpbGVzIHRvIGNvdmVyIGJhY2sgdG8gYXQgbGVhc3QgMiBjb2xkIGJhY2t1cHMg aW4geW91ciANCmNhc2UuIFlvdSBjYW4gZGVsZXRlIHRob3NlIG9sZGVyIHRoYW4gdGhhdC48L0RJ Vj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPkkgd291bGQgc3BlbmQgbW9zdCBvZiB5b3VyIHRp bWUgbGVhcm5pbmcgYWJvdXQgYmFja3VwIGFuZCByZWNvdmVyeS4gV2hlbiANCm9iamVjdGl2ZSAj MSB0ZXJtaW5hdGVzLCB5b3VyIGZ1dHVyZSBqb2Igd2lsbCBiZSBkZXRlcm1pbmVkIGJ5IGhvdyBn b29kIHlvdSBkaWQgDQpvbiBvYmplY3RpdmUgIzIgYW5kIHdoYXQgd291bGQgYmUgb2JqZWN0aXZl ICMzIChnZXR0aW5nIHRoZSBkYXRhYmFzZSBiYWNrIHVwIA0KcXVpY2tseSB3aXRoIG1pbmltYWwg ZGF0YSBsb3NzKS48L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPldoYXQgaXMgdGhlIHJl YXNvbiB5b3UgKHdpdGggbm8gZXhwZXJpZW5jZSkgaGF2ZSB0aGlzIGRhdGFiYXNlIG5vdyByYXRo ZXIgDQp0aGFuIHlvdXIgImluIGhvdXNlIG9yYWNsZSBwZXJzb24iPzwvRElWPg0KPERJVj4mbmJz cDs8L0RJVj4NCjxESVY+TWljaGFlbCBSYXk8QlI+T3JhY2xlIERCQTxCUj5UUlcsIE1hcnNoYWxs LCBJTDxCUj4yMTctODI2LTMwMTEgDQp4MjQzODxCUj48QlI+Jmd0OyZndDsmZ3Q7IERhbnZlcnNK QGd1bmxvY2tlLmNvbSAxMS8wNi8wMCAxMjowNFBNIA0KJmd0OyZndDsmZ3Q7PEJSPkhpIHRoZXJl Li4uPEJSPjxCUj5JIGhhdmUgaW5oZXJldGVkIGFuIG9yYWNsZSBzZXJ2ZXIgdGhhdCBJIG5lZWQg DQp0byBlbnN1cmU8QlI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IDEgLSANCnJ1bnM8QlI+Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KYW5kPEJSPiZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyAyIC0gZ2V0cyBiYWNrZWQgdXAuPC9ESVY+PC9CT0RZPjwvSFRNTD4NCg== Received on Mon Nov 06 2000 - 13:55:23 CST