Hey
1. you dont need to do anything with redologs either backup or restore.
2. you can use the current control file(in which case you dont have to do
anything) or use old control file.
Incase, If you use old control file with combo of current relo logs then you
need to use
Just my 2 cents:
Last backup from 03-Feb is way too long. Data check on one of the tapes,
that you backed the archive logs to, and you can not recover.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 12:33
I'm sure you'll get lots of help on this one, but the things that stand
out to me are:
Should I restore the control files(of FEb 3) before starting the
recovery.?
Don't restore the control files from Feb. 3, you need them from the
current time. Otherwise Oracle will not know it has recovery to
Dont restore redo logs, or controlfiles...
Restoring controlfile is only if you have lost ALL your current ones.
Open resetlogs rebuilds you a new set.(You are not in danger of
redoing the other transactions).
Take a new backup after you finish your restore.
I assume you knew but
Donot restore Online Redo Logs. It will be in sync with
the current control file. However, your decision to do
resetlogs is correct since it is an imcomplete (time based
recovery).
--- Basavaraja, Ravindra
[EMAIL PROTECTED] wrote: Hi,
I have to recover my database back to
This line complete gets you the good doc..
http://www.contemporary-technologies.com/oracle-training/oracle-certificatio
n/download/cram-8i-backup.doc
Brian
-Original Message-
Sent: Wednesday, March 26, 2003 6:19 PM
To: Multiple recipients of list ORACLE-L
Dont restore redo logs, or
We've run into this with Backtrack 3.3, which is also supposed to support
8.1.7.x. If I recall correctly, the temp tablespace is there, but offline.
We usually have the create scripts for the database in question, so we just
drop the tablespace and recreate it. We usually create it as locally
Hello Jai,
Tuesday, February 4, 2003, 4:13:51 AM, you wrote:
Jic Dear friends,
Jic Could someone enlighten me on the steps to be carried out using RMAN
Jic and using OS commands for Recovery if :
Jic 1. A current redo log file is corrupted.
Jic 2. The System TS is corrupted.
Jic Thanks for
Jay,
If any redo log file is corrupted (i.e. online or
archived), nothing has happened to you *yet*. It is just that every
transaction committed by the database nowis unrecoverable after the point
of corruption. So, your response is based on your requirements. If
protecting every single
Hi,
In both case, you have to restore an old backup, and do you recovery. If current
redo is corrupted, (unless shutdown cleanly), you have to do incomplete recovery, if
system ts is corrupted, you can do complete recovery if you have all the files needed.
For detailed steps, you should
AM
Subject: Re: Recovery Scenarios -
Consolidated
Finally, I have figured out a Freeware Hex editor
at http://www.hhdsoftware.com/hexeditor.html.
Using this freeware, I could open Oracle data files (while database is
shutdown) and corrupt them (for testing, of course).
1
-Original Message-
Could you please suggest me how to corrupt a data file, for testing
recovery.
--
How corrupt do you want the file to be?
vi the file?
copy /usr/bin/ksh on top of the file. That ought to corrupt it real good!
--
Please
Stephen - I don't think that will work on Windows. I don't work on Windows,
but I recall someone saying that Oracle locks the file while it is used.
Ruth - If you drop a table, I don't think a recovery will be automatically
triggered. You'd probably need to do a TSPITR, and I'm not sure that was
Hello Krishna
I just tried to open a datafile using textpad and got
sharing violation.
I tried opening using notepad and it worked.
For obvious reasons (not trying to test recovery) I did
not change and save the file with notepad.
Yechiel AdarMehish
- Original Message -
From:
.
HTH, Krishna
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 11, 2002 10:14
AM
Subject: Re: Recovery Scenarios
Hello Krishna
I just tried to open a datafile using textpad and got
sharing violation
Krishna Rao Kakatur,
You can try bbed(password blockedit).
Regards
zhu chao
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)
=== 2002-12-10 16:00:00 ,you wrote£º===
Hi,
Could you please suggest me how to corrupt a data file, for testing
What I do and have just done a couple of days ago is copy your latest redo
log into the suggested name below
'/u07/oracle/testdb/8.1.7/dbs/arch1_1.dbf'
and do your recover again. Worked fine for me
HTH
Lee
-Original Message-
Sent: 12 September 2002 19:38
To: Multiple recipients of
I think you need the online redo log file that was current when you did
shutdown abort.
This is provided it was not recycled!
Waleed
-Original Message-
Sent: Thursday, September 12, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
Database 8.1.7
Cloning a database that was
Let me clarify a bit. I cloned the database from coldbackup .
I opened the database fine, but I goofed up the name. I shutdown the database, it
hung so I
did a shutdown abort and forgot to open it up normally before I tried to rename the
database.
I don't have any archive files created by
select * from v$logfile. Specify the current logfile.
From: Kathy Duret [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: recovery question - I know I am missing something
Date: Thu, 12 Sep 2002 11:08:33 -0800
Let me clarify
Kathy,
Let me clarify a bit. I cloned the database from coldbackup .
I opened the database fine, but I goofed up the name. I
shutdown the database, it hung so I
did a shutdown abort and forgot to open it up normally before
I tried to rename the database.
I don't have any archive
I ended up giving it one of the log files but they all said stale so it took me a
couple of tries.
Thanks!
Kathy
-Original Message-
Sent: Thursday, September 12, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L
Database 8.1.7
Cloning a database that was brought down using
Harvinder - If you select from DBA_DATA_FILES, you will probably see those
tablespaces as having a MISSING location. Take them offline if you like. Not
a big deal, I have run a lot that way on test databases. Of course, if
anyone tries to access the tablespace they get an error.
Dennis Williams
Harvinder
I think u have to restore complete from cold backup and create controlfile
including 3 datafiles also and bring back to database and then u can drop
tablespaces.
OR
at current stage.did u status in check v_$datafile and v_$tablespace
dictionary table ?
Thx
-Seema
From: Harvinder
sirry , it should be v$datafile and other table dba_data_files etc..
-Original Message-
Sent: Thursday, June 20, 2002 2:17 PM
To: Multiple recipients of list ORACLE-L
Seema,
there is no reference to these 3 tablespace and files in v$database or any other
system table
A Sample Test :-
1) Database Cold Backup taken
2) CTAS ...NOLOGGING Option used to create a table
3) Crashed the Database Lost ALL the Datafiles Containing the Table
4) Extracted the Col Back Did Recovery
RESULT Was Able to Successfully Recover ALL Data of the Table which had been created
On Wed, 5 Jun 2002, VIVEK_SHARMA wrote:
Did a Database Recovery was Able to Successfully Recover ALL Data
of a Table Created with the CTAS NOLOGGING Option
Did you recover from a backup taken before or after the CTAS?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the
Thanks All for help!
I did not switch logfile after end backup statment.
Now everything working.
Thanks.
Greg.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Greg,
How did you do your hot backup? Did you do the following for each
tablespace?:
alter tablespace tbsname begin backup;
!cp datafile1
alter tablespace tbsname end backup;
Mike
From: Greg Faktor [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
After you have done the hot backup, and do ALTER TABLESPACE xxx END
BACKUP;,
have you done that sentence ALTER SYSTEM ARCHIVE LOG CURRENT; ?
In fact it's necessary to have the archive files of the redo logs used
during the time of the hot backup ! In your case, One of the redo logs is
necessary
Hi,
It is expected behaviour only. That is why it is recommended to do a log
switch and copy the log files once
the backup is complete
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Wednesday, March 06, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Not to get too far off your topic here, but what does ALTER SYSTEM ARCHIVE LOG CURRENT
do? I'm familiar with switching logfiles at the end of the backup, but I haven't seen
that command before.
Thanks,
Beth
-Original Message-
Sent: Wednesday, March 06, 2002 5:25 PM
To: Multiple
and statements above are entirely my own and not those of my
employer or clients **
-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 2:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RECOVERY PROBLEM
Hi,
It is expected
From: shashi_cs [EMAIL PROTECTED]
Date: Mon, 11 Feb 2002 22:17:38 +0530
Subject: Recovery case studies
Hi folks
Does anyone have a good document providing step-by-step various database
recovery scenerios ?
In addition to Velpuri BR book, Oracle DBA Checklists Pocket Reference
from O'Reilly
Sean,
If they are not being backed up, you won't be able to open the database
with them in it if you have to recover. You would have to mount the
database, alter the datafiles offline drop (this tells Oracle you don't
care what was in them anyway, so ignore errors on them) and then after
My take on this is, if you have stuff in your database that
is not used get it out. Then you have more space and you
are not dealing with the maintenance on things that are not
relevant.
If they are needed but not updated, put them in a tablespace
that is read only, back it up once, onto a
If all of the datafiles you restoring are in 1 tablespace you can do a
tablespace restore/recovery. How ever, if there are some datafiles in the
tablespace that are not included in the backup, I think you will not be able
to do a tablespace restore.
HTH,
Ruth
- Original Message -
To:
Personally I would challenge myself with writing a backup script that
rotated the data files not being backed up. Then I would make sure that I
had all of my archived redo logs available and backed up. This way you
could recover anything with a minimum amount of effort. Have you tried
zipping
Instead of writing a fancy backup script, why not learn and use Rman? It
does everything that is needed - backup, removal of archivelog files, easily
restore to any point in time.
a real no-brainer.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January
Speaking of Rman, has anyone used it directly interfaced w/ Legato networker? I have
to park my trusty scripts and learn Rman w/ Legato. Any gotchas I should be aware of.
I know to keep a sep schema for each Oracle version, anything else? Reason for this
is that I have a 1tb db of blobs
Gene - I'll be interested in the relies you garner. I'm just starting down
the RMAN road. Takes awhile to understand just how it works and it isn't
easy to work with. Originally we were going to use it with Veritas, but
according to knowledgeable people on this list, that is where RMAN gets
We use Rman with Legato Netwoker. Once we got Legato Networker set up
correctly, it was pretty straight forward from the Rman side of the
fence. We use networker to schedule the jobs. That adds some
complexity to the setup, but it's pretty well documented. I added some
script trickery
Except that you really should have a catalog and a catalog really should
be in a separate database and he mentioned that space was tight.
-Original Message-
Thomas F
Sent: Friday, January 11, 2002 12:20 PM
To: Multiple recipients of list ORACLE-L
Instead of writing a fancy backup
O'Neill, Sean wrote:
We perform disk-to-disk offline backups on a nighlty basis. Database is
running in archived log mode. Due to space contraints (don't ask =:-[ ) we
are currently forced to backup only some of the data files. The data files
excluded belong to specific schema owners and
Hi,
I would want to ensure that the datafiles being exluded have READ ONLY
Tablespaces
to ensure that they do not change.
This would ensure that in the event of a recovery there will not be an SCN
issue
Martin
-Original Message-
Sean
Sent: 10 January 2002 12:05
To: Multiple recipients
Sean,
First of all, datafiles actually belong to a
tablespace - not a schema.
1. You could place the tablespace into read-only
mode, take a backup of the tablespaces datafile(s),
then no additional backups are required for those
datafile(s) (and you are assured that no one updates
the data).
If you don't have enough disk space to backup all the datafiles in one run
.
create alternate backup sets.
On Mondays, Wednesdays,Fridays : Backup the Active tablespaces
On Tuesdays, Thursdays : Backup the Inactive tablespaces
[You could break this down further if you still
instead of stripping the other files from the controlfile, have you
tried to use the original controlfile, mount the database and then
offline drop the datafiles of the tablespaces you don't care about
before you open the database?
--- [EMAIL PROTECTED] wrote:
OK we had some data deleted
)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 2:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: recovery during refresh
Hi Gerardo,
Thnq for responding.
My doubt is , if I apply online logs , will it cause index
corruptions.
(ora - 600 error).
In my last
Run the following via svrmgrl or sqlplus
alter database backup controlfile to trace;
This generates a trace file in udump directory.
edit trace file:
1) strip out all lines prior to STARTUP NOMOUNT...
2) change all references to SID to test instance.
3) change all reference to file names to
Hi Gerardo,
Thnq for responding.
My doubt is , if I apply online logs , will it cause index corruptions.
(ora - 600 error).
In my last refresh , I applied online redo log. I got the message when I
apply this log is Media recovery completed.
After that I opened the db with resetlogs.
-Mensaje original-
De: Richard Ji [SMTP:[EMAIL PROTECTED]]
Enviado el:Martes 30 de Octubre de 2001 09:57 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: recovery database!!
Hmmm, sorry but I will have to say depends on the situation.
Can you
Hmmm, sorry but I will have to say depends on the situation.
Can you be a little more specific? Otherwise I would recommend
the Oracle Backup and Recovery Handbook.
Richard
[EMAIL PROTECTED] 10/30/01 10:30AM
Hi gurus,
question??
I can recovery any database with only datafiles???
@lex
-Mensaje original-
De: Richard Ji [SMTP:[EMAIL PROTECTED]]
Enviado el: Martes 30 de Octubre de 2001 09:57 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: recovery database!!
Hmmm, sorry but I will have to say depends on the situation.
Can you be a little more
It is correct if the files weren't renamed or physically removed. In that
case, you have
to re-create the controlfile and do recovery using backup controlfile (which
means that it
doesn't have the target SCN).
-Original Message-
Sent: Wednesday, September 26, 2001 4:05 PM
To: Multiple
Title: RE: recovery
The control files are all intact and the database is open.
Only one datafile (for an offline tablespace) is missing.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Meddle not in the affairs of troff,
for it is subtle and quick to anger.
-Original Message
ur right on.
the ts is offline, restore the file, do the alter database recovery
tablespace command, alter tablespace online.
tested on 9i on linux, with a rm -f of the datafile after the ts was taken
offline.
joe
[EMAIL PROTECTED] 09/26/01 04:05PM
It's been a while for this scenerio
Title: RE: recovery
Perhaps preserve the CURRENT redo logs so that after the archived ones
bring you up to their lasttime, you can use the currents to come up to the
last moments?
(I've
not tried this exact scenario though)
-Original Message-From: Adams, Matthew (GEA, 088130
!! Please do not post Off Topic to this List !!
If you have had a catalog in the past and it is backed up somewhere you can
get restore in from backup. If you don't have a backup I would just create
a new recovery catalog. Then backup all of you databases using rman in
order to have current
!! Please do not post Off Topic to this List !!
I missed a step...
you have to register the database using the command
register database; in rman once you are connected...
Anjan
Malik, Fawzia wrote:
Hi,
Please can someone advise me on how to recreate the recovery catalog from
the
!! Please do not post Off Topic to this List !!
Couple of things here..
Do u have a backup u can restore from.. If yes restore...
If never had a catalog..
Create the schema in the database u want to create the catalog and follow these
steps... (pl check the syntax of the commands)
1. connect to
Hi Kamel
You have to tell oracle that the controlfile is not originale one by
using recover database using backup controlefile
GL2Z/ INF DBA BENLATRECHE wrote:
Hi List,
I am testing one situation where :
- The database is in archive log mode,
- I have a cold backup of all the
Title: RE: Recovery Question
But don't you end up with an incomplete recovery then?
AJ
-Original Message-
From: Peter Gram [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 5:56 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Recovery Question
Hi Kamel
You have
Title: RE: Recovery Question
Hi Kamel
No, when using backup control file you are telling oracle that it should
not trust the control file to know when to end the recovery. The recovery
will keep on asking for archive log files until there are now more archivelogs
and since it dos not know
, but it is only useful if it is shared.
From: Raj Gopalan [EMAIL PROTECTED]
To: LazyDBA.com Discussion [EMAIL PROTECTED]
Subject: RE: RECOVERY
Date: Tue, 7 Aug 2001 10:03:00 +0100
Use recover until option and enter cancel when oracle asks for the
corrupted
archive log. You need to open the database
point in time recovery:
1. restore all datafiles to some time BEFORE you want to
stop recovery.
2. recover until (let you look this one up, hint
probably use time, unless you know the SCN).
3. open database w/resetlogs option.
here is the catch, if you're in noarchivelogmode, all of the
i have tested this recovery feature in 8.1.7 and worked fine for me.
Thx
-Seema
From: Christopher Spence [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Recovery without backup.
Date: Wed, 08 Aug 2001 14:03:02 -0800
I
Chris,
Good luck on the testing of the new feature that you heard about. But I think that
there needs to be some clarification stated about the archivelogs. IF you have ALL
of the archivelogs that ever did anything with the tables in the datafile that you
delete ( I mean everything from
yea its been around a while, look at
alter database create datafile, in the 817 docs its under the
category:
Re-Creating Datafiles when Backups Are
Unavailable
joe
[EMAIL PROTECTED] 08/08/01 03:21PM
I don't know much about this feature, but someone
mentioned in 8.1.7 you can recover a
That sounds impossible. Where do you get the file from?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 8 Aug 2001, Christopher Spence wrote:
I don't know much about this feature, but someone mentioned in 8.1.7 you can
recover a datafile even without a backup as long as you
Title: Recovery without backup.
It
existed before 8i. There is an example in Backup and Recovery book. alter
database create datafile ...
and
then recover.
Alex
Hillman
-Original Message-From: Christopher Spence
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08, 2001 3:22
I believe what was meant is having all archive logs since tablespace
created, but not the datafiles.
I am going to look more into it over the weekend when I get a little break
from the chaos.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you
There is no file, just logs since the creation.
I know the create datafile syntax, but I think there is some hitch that is
new to 8.1.7. Unless he was talking about create datafile. I am going to
look into it more, didn't want to mess with it until I got some time with my
test box.
Do not
Joe,
Thanks for the info. the site for the manual pages is
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76993/performi.htm#19041
I will read and understand.
ROR mª¿ªm
[EMAIL PROTECTED] 08/08/01 04:16PM
yea its been around a while, look at
alter
Yes indeed.
It was there in 7.3.I don't know about earlier versions.
Refer to Case 12 (page no 361 of 7.3 edition) of Backup and Recovery
Handbook by BR God, Rama Velpuri.
Suren
-Original Message-
Sent: Wednesday, August 08, 2001 4:33 PM
To: Multiple recipients of list ORACLE-L
It
For that, you have to have all the logs since the file was created.
It is the same command you use to add a newly created datafile to a
standby.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 8 Aug 2001, JOE TESTA wrote:
yea its been around a while, look at
alter database
could this be used for a datafile point-in-time recovery? I was thinking
if joe wanted to recover some data he trashed between backups,
it might be cool to use this to recover to the log switch just
before joe hit the return key. The recovery being done on a
aux db, of course. the names
ford 01863
-Original Message-From: Hillman, Alex
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08,
2001 4:33 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Recovery without backup.
It
existed before 8i. There is an example in Backup and Recovery book. alter
datab
this is for those scenerios where u have old control
file backup which might not include entry of newer
datafiles that u might have added (and later on lost
due to media failure) .. so like said in the thread
below .. u create a new entry in the control file by
using the create datafile ..
One way should work : DUL
You'll get this by phoning Oracle WWS and cost quite a few dollars but
could well be worth it.
But maybe Oracle WWS can solve it some other way. I have heard of stories
where they go in and change bits/bytes in datafiles (hexeditor) to combat
corruption or just to make
Hi DBA's,
I'll provide some information about our Oracle 8.0.5 instance, to help in
formulating your opinions.
Alter database backup control file to trace:
Dump file e:\orant\rdbms80\trace\ORA00216.TRC
Wed Jul 25 14:53:48 2001
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows
Do you have the ability to do a point in time recovery of the database up to
just before he loaded the file ?? Are you in archive mode or anything sane
like that ??
-Original Message-
Sent: Tuesday, July 31, 2001 7:32 PM
To: Multiple recipients of list ORACLE-L
Ok, I've been trying
That is interesting. It should start with sequence 66 logically. Is it possible that some or few of the tablespaces were left in the hot backup mode on sunday/monday morning ? Please check the alert log. My guess is that, one of the tablespace was in the backup mode, say from Sunday at least, and
[EMAIL PROTECTED] wrote
We are looking at the product. If one chooses to store the backup
information in the target database's control files, what happpens if all
the control files and data files are lost? For this query, assume the redo
logs are intact.
... then you are the looser of the
Sinardy,
what's your uptime requirement?
You're allowed a weekly cold shutdown for backup?
what I'm asking is - when you are copying the datafiles to tape, its
during a clean, cold shutdown, right?
Have you ever tested the recovery portion of your backup/recovery
scheme?
If your 'copying files
Currently the application insert data from batch localy and a bit from
online insertion. We have clustering for our database.
noarchive, I do export tables after run batch (daily), weakly copy out all
dbf files and ctl and redo log files. and copy them to tape.
It's that true once the redo log
0) 115 945 6643
* +44 (0) 115 945 6774
-Original Message-
From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
Sent: 06 April 2001 11:10
To: Multiple recipients of list ORACLE-L
Subject: RE: Rec
To: Multiple recipients of list ORACLE-L
Subject:RE: Recovery from noarchive db corrected
Hi Hallas and All DBAs
Thank you for your advise.
I have a question if I turn on our archive redo log do I
need to copy out
5 945 6774
-Original Message-
From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
Sent: 06 April 2001 11:10
To: Multiple recipients of list ORACLE-L
Subject: RE: Recovery from noarchive db
I would tell them that THEY are then responsible for database recovery if a problem
should occur. If the DBA is to be responsible, then the DBA should be able to utilize
the recovery tools provided by the vendor (Oracle).
[EMAIL PROTECTED] 04/06/01 12:45AM
The developer application running
Sinardy Xing wrote:
The developer application running huge batch inserting data into database,
that is what they told me, if you are me what you will do?
Sinardy,
You definitely want to turn archiving on.
Without it, your recovery options are limited to the last offline backup
of the
Here, here!!! If they can dictate the fact the the DB will not be in archive log
mode, they must live with unrecoverability.
Terry
Tim Sawmiller wrote:
I would tell them that THEY are then responsible for database recovery if a problem
should occur. If the DBA is to be responsible, then
Our Developer prefer the archive off, I can't change that anymore :(
-Original Message-
Sent: Thursday, 5 April 2001 8:54 PM
To: LazyDBA mailing list
Turn archiving on.
-Original Message-
From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 4:57 AM
assuming you're the dba, since when does the developer dictate
recoverability to a DBA about a database.
sounds like a role problem there.
joe
Sinardy Xing wrote:
Our Developer prefer the archive off, I can't change that anymore :(
-Original Message-
Sent: Thursday, 5 April 2001
The developer application running huge batch inserting data into database,
that is what they told me, if you are me what you will do?
-Original Message-
Testa
Sent: Friday, 6 April 2001 11:55 AM
To: Multiple recipients of list ORACLE-L
assuming you're the dba, since when does the
Sinardy,
Who will recover the database in case of a failure?
Turing on archiving would not hinder performance so much.
Proper planning of your backup strategy and db setup will have little
overhead
on performance of your database.
You cannot sacrifice backups for a marginal increase in
The actual archiving of log files itself should not impact the
performance of the insert jobs, unless the archiving process is slow enough to
cause the database to pause while a log is archived so it can be reused.
The only other reason why the developers wouldn't want it is if the space
SQL-Backtrack was a good product at one time. In theory it still is.
Here's the problem though. When Data Tools sold SQL-Backtrack to BMC,
it seems that anyone that knew anything about the product left.
There is no one in tech support that can help you beyond the menu
items. There is no one
I have used rman exclusively since I became an Oracle DBA because it was
there and I needed a backup strategy. It has gotten better with later
releases. We are now on 8.0.6. It used Oracle internals so that is an
advantage. It comes free with Oracle so that is another advantage.
I can send
Send it through the list. I would like to see it also. Thanks.
[EMAIL PROTECTED] 04/03/01 11:56AM
I have used rman exclusively since I became an Oracle DBA because it was
there and I needed a backup strategy. It has gotten better with later
releases. We are now on 8.0.6. It used Oracle
1 - 100 of 104 matches
Mail list logo
