Re: Fwd: please help
Nechama, I do a level 0 or level 1 and then do archivelog current and then backup my archivelogs. I have been able to do point-in-time and ordinary recovery using this plan. This makes a complete set of backups. Further, we put them on tape each day and store a complete set for recovery. Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 5:00 PM would it be reasonable, then to alter system archive log current, and then back up all archived logs ... are there any pitfalls? ... thanks you Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 02, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM 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:[EMAIL PROTECTED] * 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 possible BC 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 from dba_tablespaces BC where status 'INVALID'; 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 location BC 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!? BC Yahoo! Auctions - buy the things you want at great prices BC http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: Fwd: please help
thank you ruth Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, May 03, 2001 8:31 AM To: Multiple recipients of list ORACLE-L Nechama, I do a level 0 or level 1 and then do archivelog current and then backup my archivelogs. I have been able to do point-in-time and ordinary recovery using this plan. This makes a complete set of backups. Further, we put them on tape each day and store a complete set for recovery. Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 5:00 PM would it be reasonable, then to alter system archive log current, and then back up all archived logs ... are there any pitfalls? ... thanks you Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 02, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM 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:[EMAIL PROTECTED] * 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 possible BC 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 from dba_tablespaces BC where status 'INVALID'; 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 location BC 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!? BC Yahoo! Auctions - buy the things you want at great prices BC http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Fwd: please help
Jared, I think you hit the nail on the head when you said Best practice of course is to make a backup of your database in it's current condition prior to restoring it. Too many recoveries are failures because DBAs tend to forget basics when confronted with the pressures from management, users, and the constraints of time (primary key). I made this mistake once early on. Now if I have a possible recovery scenario, the first thing I do is take a deep breath, get a cup of coffee, and THINK about what I'm going to do before I ever touch the keyboard. Absent all that, I still make a copy of the redo logs whenever I do a backup. Yeah, you could mess up and apply them inadvertently, but hopefully you will have practiced recovery scenarios (see Training a DBA by Kimberly Smith) and be comfortable with your tapes, disks, commands, systems administrator, etc. At least if you've got them, and everything goes to h*%$ in a handbasket, you can always give 'them' back something. David A. Barbour Jared Still wrote: Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Fwd: please help
Man, I had to laugh with this one. And I really need it because I have been in the middle of a downtime. Got paged at 3:30am. I only went to bed at midnight so I am a little punchy right now -Original Message- Sent: Thursday, May 03, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Jared, I think you hit the nail on the head when you said Best practice of course is to make a backup of your database in it's current condition prior to restoring it. Too many recoveries are failures because DBAs tend to forget basics when confronted with the pressures from management, users, and the constraints of time (primary key). I made this mistake once early on. Now if I have a possible recovery scenario, the first thing I do is take a deep breath, get a cup of coffee, and THINK about what I'm going to do before I ever touch the keyboard. Absent all that, I still make a copy of the redo logs whenever I do a backup. Yeah, you could mess up and apply them inadvertently, but hopefully you will have practiced recovery scenarios (see Training a DBA by Kimberly Smith) and be comfortable with your tapes, disks, commands, systems administrator, etc. At least if you've got them, and everything goes to h*%$ in a handbasket, you can always give 'them' back something. David A. Barbour Jared Still wrote: Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services
Re: Fwd: please help
Jonathan Gennick wrote: 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:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org I have seen this error before - when the batch script that ran the hot backup job did not take the SYSTEM tablespace *OUT* of BACKUP mode. He should have selected file# from v$backup where status='ACTIVE'. I wasn't checking email while at IOUG. Sorry that I didn't see it sooner. with the database mounted, exec: ALTER DATABASE DATAFILE 'file_name' END BACKUP; ALTER DATABASE OPEN; and you're up. Paul 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 possible BC? 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? from dba_tablespaces BC? where status ?? 'INVALID'; 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 location BC? and i need some advise on what to do as this is a BC? serious issue with my supervisor. BC? Thanks, BC? Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Fwd: please help
Sound to me the same thing had happened.
He did not force a log switch after he finished back up all the datafiles
to tape.
If the required log (probably archive log) which is generated during the
hot backup of the database can no longer be found. Part of that hot backup
will be unusable.
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~``~
(@ @) @}-`-,-`-,--- Winnie Liu --',-'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--oInfonet Services Corporation `~`~
#mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
David A.
Barbour To: Multiple recipients of list ORACLE-L
dbarbour@nuce[EMAIL PROTECTED]
ntrix.netcc:
Sent by: Subject: Re: Fwd: please help
[EMAIL PROTECTED]
om
05/02/01 07:24
AM
Please respond
to ORACLE-L
Bill,
Did you force a log switch before and after the hot backup? Did you
backup your archive logs (or alternatively, are they available)? Sounds
to me like you need to run
ALTER DATABASE SID RECOVER UNTIL (CANCEL, TIME, CHANGE, USING
BACKUP CONTROLFILE);
If you didn't force the log switch, be mindful that you may have to
specify one or more of the redo logs to get the requested SCN. Did you
backup the controlfile? redo logs? initSID.ora? orapasswd?
These are some generalities, which may or may not apply to your specific
situation. However, given the information at hand, it's probably where
I'd start looking.
Regards.
David A. Barbour
Oracle DBA, OCP
Jonathan Gennick wrote:
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:[EMAIL PROTECTED] * 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 possible
BC 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
RE: Fwd: please help
I'm starting to feel my signature is inadequate!
Mark
(plain and simple boring me)
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 06:57
To: Multiple recipients of list ORACLE-L
Sound to me the same thing had happened.
He did not force a log switch after he finished back up all the datafiles
to tape.
If the required log (probably archive log) which is generated during the
hot backup of the database can no longer be found. Part of that hot backup
will be unusable.
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~``~
(@ @) @}-`-,-`-,--- Winnie Liu --',-'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--oInfonet Services Corporation `~`~
#mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
David A.
Barbour To: Multiple recipients of
list ORACLE-L
dbarbour@nuce[EMAIL PROTECTED]
ntrix.netcc:
Sent by: Subject: Re: Fwd: please help
[EMAIL PROTECTED]
om
05/02/01 07:24
AM
Please respond
to ORACLE-L
Bill,
Did you force a log switch before and after the hot backup? Did you
backup your archive logs (or alternatively, are they available)? Sounds
to me like you need to run
ALTER DATABASE SID RECOVER UNTIL (CANCEL, TIME, CHANGE, USING
BACKUP CONTROLFILE);
If you didn't force the log switch, be mindful that you may have to
specify one or more of the redo logs to get the requested SCN. Did you
backup the controlfile? redo logs? initSID.ora? orapasswd?
These are some generalities, which may or may not apply to your specific
situation. However, given the information at hand, it's probably where
I'd start looking.
Regards.
David A. Barbour
Oracle DBA, OCP
Jonathan Gennick wrote:
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:[EMAIL PROTECTED] * 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 possible
BC 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 from dba_tablespaces
BC where status 'INVALID';
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 location
BC 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!?
BC Yahoo! Auctions - buy the things you want at great prices
BC http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
RE: Fwd: please help
would it be reasonable, then to alter system archive log current, and then back up all archived logs ... are there any pitfalls? ... thanks you Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 02, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM 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:[EMAIL PROTECTED] * 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 possible BC 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 from dba_tablespaces BC where status 'INVALID'; 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 location BC 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!? BC Yahoo! Auctions - buy the things you want at great prices BC http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- 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 To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
