| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: please help
Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime.
--
Best regards,
Jonathan Gennick
mailto:jonathan_at_gennick.com * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Tuesday, May 01, 2001, 10:27:51 PM, X wrote: BC> Hi Jonathan,
BC> I always read and like your articles in the Oracle BC> Magazine.
BC> Could you please give me a moment of your time .. BC> I have some couple of pressing problems and questions BC> if you don't mind as i am under fire at work .. BC> I have trouble with some of the Oracle databases that BC> i manage on Sun Solaris platform, sometimes i have my BC> shutdowns hanging and this takes a very long time to BC> complete. Also, hanging problems with some of the sql BC> statements. Could you lend a hand about any possibleBC> clues as to what i should do or where i should look BC> for answers.
BC> My last question is about hotback.
BC> I ran a hot backup yesterday and tried recovering BC> today. I was faced with an Oracle error saying system BC> tablespace needs more recovery and that open resetlogs BC> will get an error after automatically applying the BC> redo logs.
BC> My backup strategy went this way,
BC> i created a backup shell script and BC> i put all tablespaces in hotbackup mode at the same BC> time with this syntax.. BC> select 'alter tablespace' || tablespace_name ||'begin BC> backup;'
BC> I copied my datafiles to backup using the syntax below BC> ...
BC> !cp /u02/oradata/prod/system01.dbf /backup/prod BC> !cp .... BC> !cp .... BC> !cp .... BC> !cp ....
BC> then ended backup the same way as i began backup BC> with the ||'end backup;'
BC> I backed up my controlfile
BC> and everything went well. Today, I restored my BC> datafiles from backup and i was greeted with the BC> problem i just expalined to you. BC> I am the only dba DBA at this locationBC> and i need some advise on what to do as this is a BC> serious issue with my supervisor.
BC> Thanks,
BC> Bill
BC> __________________________________________________ BC> Do You Yahoo!?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: jonathan_at_gennick.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 01 2001 - 23:11:00 CDT
 |
 |