RE: backup strategy for a database over 1 TB running SAP R/3

2003-04-01 Thread Jared . Still
e respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: backup strategy for a database over 1 TB running SAP R/3 Yes. In fact, I am trying to decide using RMAN or SAP BR-tools. -Original Message- Sent

RE: backup strategy for a database over 1 TB running SAP R/3

2003-04-01 Thread Roger Xu
Yes. In fact, I am trying to decide using RMAN or SAP BR-tools. -Original Message- Sent: Tuesday, April 01, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Roger We don't run SAP, but are you considering using RMAN as a part of your plans? Dennis Williams DBA, 40%OCP, 100% DBA

RE: backup strategy for a database over 1 TB running SAP R/3

2003-04-01 Thread DENNIS WILLIAMS
Roger We don't run SAP, but are you considering using RMAN as a part of your plans? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hi, What is the backup stra

RE: Backup Strategy

2003-03-17 Thread Jack van Zanen
Good one. :-) Jack -Original Message- Sent: maandag 17 maart 2003 11:29 To: Multiple recipients of list ORACLE-L So what are you doing this afternoon after you have mastered the SQL Server gui this morning? -Original Message- Sent: 15 March 2003 09:44 To: Multiple recipients o

RE: Backup Strategy

2003-03-17 Thread Hallas, John, Tech Dev
So what are you doing this afternoon after you have mastered the SQL Server gui this morning? -Original Message- Sent: 15 March 2003 09:44 To: Multiple recipients of list ORACLE-L I put them on http://www.vanzanen.com/rman.zip They are oracle 8.0 (if memory serves me right) so they wo

RE: Backup Strategy

2003-03-15 Thread Jack van Zanen
I put them on http://www.vanzanen.com/rman.zip They are oracle 8.0 (if memory serves me right) so they won't work with 9i. I'll see if I can find the time to do the same for 9i one of these days (have to learn SQL Server first) Jack -Original Message- Sent: vrijdag 14 maart 2003 20:24 T

RE: Backup Strategy

2003-03-14 Thread Hallas, John, Tech Dev
I have found Joe Testa's site has a good set of RMAN scripts (I think they came from Jack van Zanen off this list), quite simple but they give the syntax for most of the commands you will want The link was http://www.oracle-dba.com but that is no longer working Where have you put them Joe?? Joh

RE: Backup Strategy

2003-03-14 Thread DENNIS WILLIAMS
Jay If you want a good book to get up to speed on RMAN, buy Oracle9i RMAN Backup & Recovery by Robert Freeman and Matthew Hart If you want to compare the steps for various recovery scenarios between RMAN and user-managed recovery, get Oracle Backup & Recovery 101 by Smith and Haisley. It

Re: Backup Strategy

2003-03-14 Thread Chuck Hamilton
Post a message to the list where they can be found when your ready. I'd like to take a look at them. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 6:53 AM > Jay, I've got pretty much a common framework written in unix she

Re: Backup Strategy

2003-03-14 Thread Joe Testa
Jay, I've got pretty much a common framework written in unix shell scripts to do most backup/restores for RMAN. I'm finishing up the front end(text menus for unix) but the back end scripts are pretty much solid. I'll be releasing the whole thing under GPL(for those of you who don't know what

RE: Backup Strategy

2003-03-14 Thread Jack van Zanen
1.    I suggest U buy the book on RMAN by I believe O'Reilly & Backup & Recovery by Rama Velpuri 2.    Come up with a list of all possible failures/crashes 3.    Document a recovery scenario for all points 4.    TEST Them.     Redo log member failure. How do you see that??  It should be OK

RE: Backup Strategy - Informal Survey

2002-09-20 Thread DENNIS WILLIAMS
Nat Just a plug for always testing your backups, regardless of whether you are doing hot or cold. We do cold backups, and we test them from time to time by restoring them on a test system so the developers have some data to test against. Several times over the years we've found that a file was

RE: Backup Strategy - Informal Survey

2002-09-20 Thread Miller, Jay
On our larger database we do exports of some of the smaller users which also have frequent changes. I wish I had some of the larger tables also, it would have saved a big headache last week getting one table restored (7 days to get the files restored from tape, 1.5 hours to modify the control tr

RE: Backup Strategy - Informal Survey

2002-09-20 Thread Freeman, Robert
Well I just happen to know of this great Oracle Press RMAN book due out in October! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles

Re: Backup Strategy - Informal Survey

2002-09-20 Thread Nat
No we do trust our hot backups. Our databases are mostly idle during early ours of Sunday between 12 AM - 1 AM. So we thought lets go for a cold backup on weekends. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 12:28 P

Re: Backup Strategy - Informal Survey

2002-09-20 Thread Jeremiah Wilton
On Fri, 20 Sep 2002, Nat wrote: > We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our > database once a week for half an hour for cold bcv splits. So far it has > worked very well. Just curious, why do you do a cold backup weekly? Do you not trust your hot backups? -- Jer

RE: Backup Strategy - Informal Survey

2002-09-20 Thread DENNIS WILLIAMS
Robert I don't think a full export has a place since your largest tables are probably too large to reimport in a reasonable amount of time. I like Jay's suggestion though. But your original question wasn't about a full export, you just said export. My answer is a definite "yes". Following Paret

RE: Backup Strategy - Informal Survey

2002-09-20 Thread Jenner Mike
An export with data will probably cause more headaches than it solves in large DBs. A logical export without data will also have limited use. It is quick to do and small but I suggest may be invaluable for various tasks. Mike Jenner Database Administrator -Original Message- Sent: 20 Se

Re: Backup Strategy - Informal Survey

2002-09-20 Thread Nat
Our db size is around 350Gig. We have stopped full logical exports since our database size has grown above 200 Gigs. It is just not feasible for us to do the full exports anymore, time it takes to export is too much. We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our data

Re: Backup Strategy - Informal Survey

2002-09-20 Thread Jay Hostetter
I do nightly exports of my large databases with ROWS=N. This way I can restore users, grants, indexes, table definitions, etc. Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 09/20/02 10:13AM >>> I'd like to pose a question to you all and get your respo

Re: Backup Strategy

2002-01-25 Thread Igor Neyman
ending on your > > > Oracle > > > version, the distribution includes a utility called EBU (Oracle7) or > RMAN > > > > > > (Oracle8 and later) that can be used for online recovery as well. You > > > will need > > > to use a media management

RE: Backup Strategy

2002-01-25 Thread Grabowy, Chris
> command. Utilities like the NT commands copy, xcopy CANNOT be used to > > back up. > > The Windows NT feature to be aware of is that NT Backup does not allow > > files in > > use to be copied, so you must use the OCOPY utility that Oracle provides > > to >

RE: Backup Strategy

2002-01-25 Thread Johnston, Tim
the NT commands copy, xcopy CANNOT be used to > > back up. > > The Windows NT feature to be aware of is that NT Backup does not allow > > files in > > use to be copied, so you must use the OCOPY utility that Oracle provides > > to > > copy the open database

Re: Backup Strategy (NT)

2002-01-25 Thread Eric D. Pierce
lt;[EMAIL PROTECTED]> wrote: > fyi: > > On 25 Jan 2002 at 1:05, Oracle RDBMS Community Forum > <[EMAIL PROTECTED]> wrote: > > > > > > ------ > > > > From: "Igor Neyman" <[EMAIL PROTECTED]> > > Da

Re: Backup Strategy

2002-01-25 Thread Igor Neyman
s NT feature to be aware of is that NT Backup does not allow > > files in > > use to be copied, so you must use the OCOPY utility that Oracle provides > > to > > copy the open database files to another disk location. Since OCOPY cannot > > copy > > files directly to ta

RE: Backup Strategy

2002-01-25 Thread Grabowy, Chris
tape, as required. > > OCOPY allows writing to continue while the backup is running. The NT COPY > is a > closed copy and the files may be marked either as "fuzzy" or "corrupt." > Ocopy > opens the file using CreateFile() with the FILE_SHARE_READ and >

RE: Backup Strategy

2002-01-25 Thread Johnston, Tim
need to use NT Backup or copy or a > similar utility to copy the files to tape, as required. > > OCOPY allows writing to continue while the backup is running. The NT COPY > is a > closed copy and the files may be marked either as "fuzzy" or "corrupt." > O

Re: Backup Strategy

2002-01-25 Thread Igor Neyman
hile the backup is running. The NT COPY > is a > closed copy and the files may be marked either as "fuzzy" or "corrupt." > Ocopy > opens the file using CreateFile() with the FILE_SHARE_READ and > FILE_SHARE_WRITE > flags. This allows writing to continue

Re: Backup Strategy

2002-01-24 Thread Peter . McLarty
ipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject: Re: Backup Strategy > Wrong. NT 'COPY' has no problems copying 'opened' oracle db files. > I'm using it in 'hot backup' scripts on many dozens systems,

RE: Backup Strategy

2002-01-24 Thread Kimberly Smith
is not a member!!! "Kimberly Smith" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Backup Strategy Sent by:

RE: Backup Strategy

2002-01-24 Thread Johnston, Tim
> > Sent: Wednesday, January 23, 2002 3:25 PM > >> > > >> > > Hello Hamid > >> > > > >> > > I would like to have this paper as well. > >> > > We are now revising our Backup strategy. > >> > > > >

RE: Backup Strategy

2002-01-24 Thread Sujatha Madan
t ORACLE-L <[EMAIL PROTECTED]> > >> > Sent: Wednesday, January 23, 2002 3:25 PM > >> > > >> > > Hello Hamid > >> > > > >> > > I would like to have this paper as well. > >> > > We are now revising

Re: Backup Strategy

2002-01-24 Thread Jared . Still
n" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/24/02 01:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Backup Strategy I took a quick look at this paper, and found right awa

Re: Backup Strategy

2002-01-24 Thread Igor Neyman
> > >> > Sent: Wednesday, January 23, 2002 3:25 PM > >> > > >> > > Hello Hamid > >> > > > >> > > I would like to have this paper as well. > >> > > We are now revising our Backup strategy. > >>

RE: Backup Strategy

2002-01-24 Thread JoJo Al-Zawawi
Now you're really stretching it! :D --JoJo [EMAIL PROTECTED] wrote: >JoJo -- > >Sure, but be aware that Unix abaci are better than NT abaci. > don't forget the VMS abaci.;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi INET: [EMAIL PROTECTED] F

RE: Backup Strategy

2002-01-24 Thread Henry Poras
You can count on it. Henry -Original Message- Sent: Thursday, January 24, 2002 2:13 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: >JoJo -- > >Sure, but be aware that Unix abaci are better than NT abaci. > don't forget the VMS abaci.;-) -- -- Bill "Shrek" Tha

Re: Backup Strategy

2002-01-24 Thread bill thater
[EMAIL PROTECTED] wrote: >JoJo -- > >Sure, but be aware that Unix abaci are better than NT abaci. > don't forget the VMS abaci.;-) -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You g

RE: Backup Strategy

2002-01-24 Thread Bellows, Bambi
as well. > > > We are now revising our Backup strategy. > > > > > > Yechiel Adar, Mehish Computer Services > > > [EMAIL PROTECTED] > > > > > > > -Original Message- > > > > From: Mohan, Ross [SMTP:[EMAIL PROTEC

RE: Backup Strategy

2002-01-24 Thread JoJo Al-Zawawi
2002 3:25 PM > > > > > Hello Hamid > > > > > > I would like to have this paper as well. > > > We are now revising our Backup strategy. > > > > > > Yechiel Adar, Mehish Computer Services > > > [EMAIL PROTECTED] > > > >

RE: Backup Strategy

2002-01-24 Thread Mercadante, Thomas F
gt; Yechiel Adar, Mehish Computer Services > > > [EMAIL PROTECTED] > > > > > > > -Original Message- > > > > From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tue, January 22, 2002 6:35 PM > > > > To: Multiple

RE: Backup Strategy

2002-01-24 Thread Rick_Cale
berly Smith" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Backup Strategy

RE: Re: Backup Strategy

2002-01-24 Thread Nick Wagner
Title: RE: Re: Backup Strategy here is a pretty good one as well...  The paper is on building a 24x7 database. http://www.quest.com/whitepapers/Building_WP.pdf -Original Message- From: Jan Pruner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:10 AM To: Multiple

RE: Backup Strategy

2002-01-24 Thread Kimberly Smith
ld like to have this paper as well. > > > We are now revising our Backup strategy. > > > > > > Yechiel Adar, Mehish Computer Services > > > [EMAIL PROTECTED] > > > > > > > -Original Message- > > > > From: Mohan, Ross [SMTP:[

Fwd: Re: Backup Strategy

2002-01-24 Thread Jan Pruner
http://www.stormgt.org/white.html JP On Thursday 17 January 2002 18:26, you wrote: > Hi List, > I have a white paper for Backup Strategy on Microsoft NT but I am looking > for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or > link I realy appreciate. > > > > > Hamid Alavi > O

Re: Backup Strategy

2002-01-24 Thread Jan Pruner
http://www.sun.com/storage/white-papers/backup-planning.html JP On Thursday 17 January 2002 18:26, you wrote: > Hi List, > I have a white paper for Backup Strategy on Microsoft NT but I am looking > for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or > link I realy appreciate

Re: Backup Strategy

2002-01-24 Thread C.S.Venkata Subramanian
2 3:25 PM >> > >> > > Hello Hamid >> > > >> > > I would like to have this paper as well. >> > > We are now revising our Backup strategy. >> > > >> > > Yechiel Adar, Mehish Computer Services >> > > [EMAIL

RE: Backup Strategy

2002-01-24 Thread Mark Leith
gt; We are now revising our Backup strategy. > > > > > > Yechiel Adar, Mehish Computer Services > > > [EMAIL PROTECTED] > > > > > > > -Original Message- > > > > From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] > > >

Re: Backup Strategy

2002-01-24 Thread Bunyamin K. Karadeniz
TECTED] > > > > > > > -Original Message- > > > > From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tue, January 22, 2002 6:35 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RE: Backup Strategy >

Re: Backup Strategy

2002-01-24 Thread rpapnoi
-Original Message- > > > From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] > > > Sent: Tue, January 22, 2002 6:35 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Backup Strategy > > > > > > Hamid, > > > > > &g

RE: Backup Strategy

2002-01-22 Thread Mohan, Ross
Hamid, Would you be willing to forward a copy of this paper? Thanks, Ross Mohan -Original Message- Sent: Thursday, January 17, 2002 12:27 PM To: Multiple recipients of list ORACLE-L Hi List, I have a white paper for Backup Strategy on Microsoft NT but I am looking for Backup Strate

RE: Backup Strategy

2002-01-17 Thread DENNIS WILLIAMS
Hamid - You might consider buying the book "Oracle8i Backup and Recovery" by Rama Velpuri, George Williams, Anand Adkoli. It is highly recommended by everyone, myself included. I believe that it will help you design a backup strategy that works for your system. A backup strategy will vary widely,

RE: Backup strategy

2001-11-21 Thread Ron Rogers
Bing, Please explain your reasoning for backing up the archivelogs when you backup the readonly tablespaces. One reason you change a tablespace to read only is to reduce the backup needed. After a tablespace is in read only mode no changes are made to the data and you only need to back it up o

RE: Backup strategy

2001-11-20 Thread Wong, Bing
When you backup the read-only tablespace, you must backup the archive logs (if any) as well. -Original Message- Sent: Tuesday, November 20, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Ya but you don't normally backup a read-only tablespace. The whole reason I make them rea

RE: Backup strategy

2001-11-20 Thread Kimberly Smith
Ya but you don't normally backup a read-only tablespace. The whole reason I make them read-only is to ensure that I finish the backup this century. -Original Message- Sent: Tuesday, November 20, 2001 11:01 AM To: Multiple recipients of list ORACLE-L My hot backup is to put one tables

RE: Backup strategy

2001-11-20 Thread Wong, Bing
My hot backup is to put one tablespace in backup mode one at a time and copy that data file to disk and alter it back online. No problem Bing -Original Message- Sent: Tuesday, November 20, 2001 10:28 AM To: Multiple recipients of list ORACLE-L My fault, I should have said copy. Clim

RE: Backup strategy

2001-11-20 Thread Kimberly Smith
My fault, I should have said copy. Climbing night last night so I am dead tired. Thanks for the input. -Original Message- Sent: Tuesday, November 20, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Kimberly, You can change a tablespace to read only with no problems and you sh

Re: Backup strategy

2001-11-20 Thread Ron Rogers
Kimberly, You can change a tablespace to read only with no problems and you should take a backup to capture the change. Your last paragraph stated you wanted to "move the datafile to the disk that the tape backup picks" That will cause you problems if you move the datafile. You should copy the

RE: Backup Strategy

2001-10-22 Thread Rachel Carmichael
; > Regards > > > -Original Message- > > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, October 22, 2001 5:25 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Re: Backup Strategy > > > > We

RE: Backup Strategy

2001-10-22 Thread DENNIS WILLIAMS
L PROTECTED]] > Sent: Monday, October 22, 2001 7:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Backup Strategy > > Why export at all? As long as your database is in archive log > mode you should be ok. Do your cold backup to disk and always > have t

RE: Backup Strategy

2001-10-22 Thread Kimberly Smith
, 2001 7:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Backup Strategy > > Why export at all? As long as your database is in archive log > mode you should be ok. Do your cold backup to disk and always > have the latest on disk. That way you reduce your re

RE: Backup Strategy

2001-10-22 Thread Ahmed Gholam Hussain
? Regards > -Original Message- > From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 7:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Backup Strategy > > Why export at all? As long as your database is in archive log &g

RE: Backup Strategy

2001-10-22 Thread Ahmed Gholam Hussain
to care about resource utilization Normally we do a backup every weekend Regards > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 5:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:

RE: Backup Strategy

2001-10-22 Thread Kimberly Smith
Why export at all? As long as your database is in archive log mode you should be ok. Do your cold backup to disk and always have the latest on disk. That way you reduce your recover time by not having to go to tape for your backup. I have all our OS backups scheduled to go after the backup for

Re: Backup Strategy

2001-10-22 Thread Rachel Carmichael
We'd need a little more information before we can give any advice (okay, this group gives advice on no information but..) Some questions: 1) during the business hours, do you add critical data that you can't afford to lose to your database? If so, you should be in archivelog mode. The cold back

RE: Backup Strategy

2001-10-22 Thread Sinard Xing
Hi, It will depend on how much data you can afford to lose (in terms of time)? may be you can do exp at 8, 9, 10, 11, 12, 13 Cold backup at 14 or perhaps you want to consider RMAN Sinardy -Original Message- Gholam Hussain Sent: Monday, 22 October 2001 6:00 PM To: Multiple recipient

RE: Backup Strategy

2001-10-05 Thread Guy Hammond
That is a good point, it is important to consider who will be doing the recovery. If it is a relatively small and static database, and the recovery will be performed by an Unix admin (i.e. not a specialist DBA) then export/cold backup does make a lot of sense. The main issue to consider is $$$. If

Re: Backup Strategy

2001-10-05 Thread Joe Testa
Jeremiah, you must evidently not know Jared based on your reply. He didnt detail the step but gave an overall theory. I know his scripts wouldnt take anything on blind faith(unless of course he's the ONLY one who does DBA work on that database, then if he's as anal as me, he still wouldnt trust

RE: Backup Strategy

2001-10-05 Thread Christopher Spence
se it is not necessary to use a cold backup. Jared "Gene Sais" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> ach.fl.us> cc: Sent by:

RE: Backup Strategy

2001-10-05 Thread Cherie_Machler
us> cc: Sent by: Subject: RE: Backup Strategy

RE: Backup Strategy

2001-10-05 Thread Jeremiah Wilton
On Thu, 4 Oct 2001, Gene Sais wrote: > 2) Cold backups follow the KISS principle. Shutdown db, tar, dump, > cpio, dd, etc. the datafiles, redo logs, ctl files, oracle > filesystems, etc. to tape, Startup db, Done. Take the tape to same or > another server and restore, No Oracle cmds required (f

Re: RE: Backup Strategy

2001-10-04 Thread Gene Sais
ally needed after you open a database with 'resetlogs' . Otherwise it is not necessary to use a cold backup. Jared "Gene Sais" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PRO

Re: RE: Backup Strategy

2001-10-04 Thread Gene Sais
>>> [EMAIL PROTECTED] 10/04/01 18:26 PM >>> 1. If you can afford to lose data from the time of the last backup, then you are right. However, I even put those databases on 24x7 mode whenever possible because (1) Developers, like DBAs, work strange hours in the night and day and would probally like

RE: Backup Strategy

2001-10-04 Thread Veronica Levin
Para: Multiple recipients of list ORACLE-L Asunto: RE: Backup Strategy Veronica, If you got some cash I highly recommend the Oracle Press book "Backup & Recover Handbook" by Velpuri Adkoli. It goes into some of that and has test cases and all that fun stuff. Its one of the best O

RE: Backup Strategy

2001-10-04 Thread satar naghshineh
1. If you can afford to lose data from the time of the last backup, then you are right. However, I even put those databases on 24x7 mode whenever possible because (1) Developers, like DBAs, work strange hours in the night and day and would probally like to have access to the database. (2) You neve

RE: Backup Strategy

2001-10-04 Thread Connor McDonald
Just to add some controversary - I cannot think of a single reason to bring a database down during normal operation. To change some static parameters, or upgrade it, then yes, but other than that - its just shooting yourself in the foot. When your database has been up for some time, its nice and

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
of list ORACLE-L <[EMAIL PROTECTED]> ach.fl.us> cc: Sent by:Subject: RE: Backup Strategy [EMAIL PROTECTED] 10/04/01 02:10 PM Please respond to

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
e: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 04 de Octubre de 2001 12:39 p.m. Para: [EMAIL PROTECTED] CC: Veronica Levin Asunto: RE: Backup Strategy Veronica, Here is yet one more reply for you, but I think you'll be glad to get it. Tom Cox put together an excell

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
Once you have been in production for a while you really should not be changing your init that much. But there is a big difference between the downtime necessary to restart a database and to shut it down, copy all the files, and then start it up again. -Original Message- Sent: Thursday, O

RE: Backup Strategy

2001-10-04 Thread Veronica Levin
de Octubre de 2001 01:05 p.m. Para: Multiple recipients of list ORACLE-L Asunto: RE: Backup Strategy Oh, guess I jumped the gun. Sorry. However, now she knows its ok not to shut it down if she was just doing it cause she though she should:-) -Original Message- Sent: Thursday, October 04

RE: Backup Strategy

2001-10-04 Thread Gene Sais
Henry brings up a good point. Users accept scheduled downtime (cold backups), therefore it allows me perform system maintenance w/out asking for permission :) They always want 24x7 and never give permission. >>> [EMAIL PROTECTED] 10/04/01 05:55PM >>> And what about changes to the init.ora? No

RE: Backup Strategy

2001-10-04 Thread Jared . Still
ch.fl.us> cc: Subject: RE: Backup Strategy

RE: Backup Strategy

2001-10-04 Thread Veronica Levin
EMAIL PROTECTED] CC: Veronica Levin Asunto: RE: Backup Strategy Veronica, Here is yet one more reply for you, but I think you'll be glad to get it. Tom Cox put together an excellent paper on BU and Reco requirements, and it can be found at: http://www.geocities.com/tbcox23/ Look for &

RE: Backup Strategy

2001-10-04 Thread Gene Sais
<[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> ach.fl.us> cc:

RE: Backup Strategy

2001-10-04 Thread Jared . Still
ipients of list ORACLE-L <[EMAIL PROTECTED]> ach.fl.us> cc: Sent by:Subject: RE: Backup Strategy

RE: Backup Strategy

2001-10-04 Thread Henry Poras
And what about changes to the init.ora? No scheduled downtime is necessary with cold backups. (of course more stuff can be changed on line these days) Henry -Original Message- Sent: Thursday, October 04, 2001 5:11 PM To: Multiple recipients of list ORACLE-L Well for 1 reason, Cold back

RE: Backup Strategy

2001-10-04 Thread Koivu, Lisa
Title: RE: Backup Strategy Gene is a sysadmin at heart.  He hasn't been fully groomed and trained in the Data Base Arts.  I think that's the main reason for his (unjustified) reluctance to TRUST something that works.  It's like physics.  You see it every day, the math d

RE: Backup Strategy

2001-10-04 Thread Gene Sais
Well for 1 reason, Cold backups are restored using OS cmds, no need for Oracle recovery, whereas, Hot Backups require OS cmds + Oracle recovery. One exception is pt in time recoveries. I do have 1 db that will be web-enabled, therefore 24x7. So guess what I have to do, Hot Backups. I am not

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
iginal- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de [EMAIL PROTECTED] Enviado el: Thursday, 04 October, 2001 2:40 PM Para: Multiple recipients of list ORACLE-L Asunto: RE: Backup Strategy Veronica, Here is yet one more reply for you, but I think you'll be glad to get i

RE: Backup Strategy

2001-10-04 Thread satar naghshineh
Actually, I'll take it even one step further... ;) There should be no reason to choose cold backups over hot backups. Even companies who can afford to be down during weekends and weeknights will appreciate a database that can be accessed by users anytime. Regards, Satar --- Kimberly Smith <[EMA

RE: Backup Strategy

2001-10-04 Thread Ramon Estevez
ltiple recipients of list ORACLE-L Asunto: RE: Backup Strategy Veronica, Here is yet one more reply for you, but I think you'll be glad to get it. Tom Cox put together an excellent paper on BU and Reco requirements, and it can be found at: http://www.geocities.com/tbcox23/ Look for 'Bac

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
Why is better Gene? What is it about the files being closed that gives you the trust factor? I don't use RMAN here either but its more because my backup method works wonders and I just don't need those extra features that RMAN provides. There are a lot of sites out there that cannot afford t

RE: Backup Strategy

2001-10-04 Thread Jared . Still
Sent by: Subject: RE: Backup Strategy [EMAIL PROTECTED]

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
Oh, guess I jumped the gun. Sorry. However, now she knows its ok not to shut it down if she was just doing it cause she though she should:-) -Original Message- Sent: Thursday, October 04, 2001 11:40 AM To: Multiple recipients of list ORACLE-L Kimberly, I think we agree with each othe

RE: Backup Strategy

2001-10-04 Thread Mercadante, Thomas F
Kimberly, I think we agree with each other. The only reason I suggested that she stay with the cold backup on the weekend was because she was already doing that. If we were devising a brand new backup strategy, and the requirement was that there was no down-time available for a cold backup, the

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
I agree with your export statement but I must question this one. I cannot think of a single reason to get a cold backup over a hot backup. I can think of reasons for cold backups but if I was doing hot backups already I would not shutdown my database just to get a cold. There is a myth out ther

RE: Backup Strategy

2001-10-04 Thread Veronica Levin
e day! Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 04 de Octubre de 2001 06:09 a.m. Para: '[EMAIL PROTECTED]' CC: Veronica Levin Asunto: RE: Backup Strategy Veronica

RE: Backup Strategy

2001-10-04 Thread Mercadante, Thomas F
hear if there is anything else I should be doing, Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 03 de Octubre de 2001 01:17 p.m. Para: '[EMAIL PROTECTED]' CC: Veroni

RE: Backup Strategy

2001-10-04 Thread Guy Hammond
Enviado el: Miércoles, 03 de Octubre de 2001 01:17 p.m. Para: '[EMAIL PROTECTED]' CC: Veronica Levin Asunto: RE: Backup Strategy Veronica, Before you can decide on what your backup strategy will be, you really need to talk to the users of your database. One of the most important pieces

Re: Backup Strategy

2001-10-03 Thread George Schlossnagle
mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 03 de Octubre de 2001 01:17 p.m. Para: '[EMAIL PROTECTED]' CC: Veronica Levin Asunto: RE: Backup Strategy Veronica, Before you can decide on what your backup strategy will be, you really need to talk to the users of your database. One

RE: Backup Strategy

2001-10-03 Thread Veronica Levin
PROTECTED]' CC: Veronica Levin Asunto: RE: Backup Strategy Veronica, Before you can decide on what your backup strategy will be, you really need to talk to the users of your database. One of the most important pieces of information to get from your users is the "Mean Time to Recovery".

  1   2   >