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 "recover..blah..blah..us
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:3
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
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 23-MAR-0
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 jus
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 d
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
ma
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
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 now is unrecoverable after the point
of corruption. So, your response is based on your requirements. If
protecting every singl
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 check
8:53
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, o
o you.
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
sh
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 -
Fro
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 t
-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 s
All you have to do is drop a couple of tables and try to get them back.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 7:00 PM
Hi,
Could you please suggest me how to corrupt a data file, for testing
recovery.
I
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 r
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 sh
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 ar
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
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 t
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 broug
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 lis
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
applicat
Seema,
there is no reference to these 3 tablespace and files in v$database or any other
system table
application is running fine..
Thanks
--Harvinder
-Original Message-
Sent: Thursday, June 20, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L
Harvinder
I think u have to
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 S
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
DB
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 th
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
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
ble!
** The opinions 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:
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 reci
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
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
necessa
Did you first backup the datafiles, then the controlfiles, then
logswitch and backup the archive logs? Is it possible the system01.dbf
datafile wasn't restored from backup?? Is it possible the tablespace
for that datafile wasn't in backup mode???
Greg Faktor wrote:
>
> Hi All!
> I'm trying
Greg,
How did you do your hot backup? Did you do the following for each
tablespace?:
alter tablespace begin backup;
!cp datafile1
alter tablespace end backup;
Mike
>From: "Greg Faktor" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PRO
>> 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 B&R book, "Oracle DBA Checklists" Pocket Re
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 script
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 th
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
pretty
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 and
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
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 y
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: "Mu
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 perma
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
finishin
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 d
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).
2
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
"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 owne
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
ddy, Shrinivas (MED, Keane)
> [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 lo
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. Everything
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 t
Presumably all required transactions to be recovered were in the online
logs ? You cannot
copy the online logs "online" (when they are active !).
Check if those indexes were created NOLOGGING when the backup was running
-- that could
explain why the indexes could not be recovered.
If you canno
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
> -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.
>
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
Title: RE: recovery
Perhaps preserve the CURRENT redo logs so that after the archived ones
bring you up to their last time, 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, 0
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 sce
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 Mess
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 re
!! 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
!! 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 !!
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 bac
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
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 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 t
owledge is power, 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 o
t;Knowledge is power, 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
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,
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 .." stat
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 b
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 have
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 cr
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 B&R God, Rama Velpuri.
Suren
-Original Message-
Sent: Wednesday, August 08, 2001 4:33 PM
To: Multiple recipients of list ORACLE-L
It ex
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 da
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 cri
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
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
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 ha
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
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 cr
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
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
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 t
Matt,
If the log switched from 66 to 67 on Monday, and you want to
do a PIT recovery to Friday, the recovery will never want to
look at log # 67, as it contains transactions that all occurred
*after* the PIT on Friday that you wish to recover to.
Jared
On Friday 08 June 2001 13:05, Adams, Mat
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 t
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 t
add redo groups and archiver processes
oli
[EMAIL PROTECTED] 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?
>
> -Original Message-
> Testa
> Sent: Friday, 6 April 2001 11:55 AM
> To: Multipl
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
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 da
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 run
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
: 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
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
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 swi
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
re
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 perform
1 - 100 of 112 matches
Mail list logo
