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

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 Jared . Still
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: Tuesday, April 01, 2003 2:04 PM

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

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

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

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 because it is

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 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 shell

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 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??

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 response.

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

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

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

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? --

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 PM

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

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

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

Re: Backup Strategy

2002-01-25 Thread Igor Neyman
writes to the file while the copy is taking place. Igor Neyman [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

RE: Backup Strategy

2002-01-25 Thread Johnston, Tim
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 away, that it's not very accurate, at least in one issue. i.e., it states : quote The Windows NT command

RE: Backup Strategy

2002-01-25 Thread Grabowy, Chris
] cc: Subject:Re: Backup Strategy I took a quick look at this paper, and found right away, that it's not very accurate, at least in one issue. i.e., it states : quote The Windows NT command COPY can be used to create a cold backup of a database. It cannot be used to make

Re: Backup Strategy

2002-01-25 Thread Igor Neyman
[EMAIL PROTECTED] cc: Subject:Re: Backup Strategy I took a quick look at this paper, and found right away, that it's not very accurate, at least in one issue. i.e., it states : quote The Windows NT command COPY can be used to create a cold backup

Re: Backup Strategy (NT)

2002-01-25 Thread Eric D. Pierce
[EMAIL PROTECTED] wrote: -- From: Igor Neyman [EMAIL PROTECTED] Date: Thu, 24 Jan 2002 16:14:25 -0500 Subject: Re: Backup Strategy I took a quick look at this paper, and found right away, that it's not very accurate, at least in one issue. i.e

RE: Backup Strategy

2002-01-25 Thread Johnston, Tim
:Re: Backup Strategy I took a quick look at this paper, and found right away, that it's not very accurate, at least in one issue. i.e., it states : quote The Windows NT command COPY can be used to create a cold backup of a database. It cannot be used to make a hot backup

RE: Backup Strategy

2002-01-25 Thread Grabowy, Chris
: Subject:Re: Backup Strategy I took a quick look at this paper, and found right away, that it's not very accurate, at least in one issue. i.e., it states : quote The Windows NT command COPY can be used to create a cold backup of a database. It cannot be used to make

Re: Backup Strategy

2002-01-25 Thread Igor Neyman
: Subject:Re: Backup Strategy I took a quick look at this paper, and found right away, that it's not very accurate, at least in one issue. i.e., it states : quote The Windows NT command COPY can be used to create a cold backup of a database. It cannot

Re: Backup Strategy

2002-01-24 Thread rpapnoi
ORACLE-L Subject: RE: Backup Strategy 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

Re: Backup Strategy

2002-01-24 Thread Bunyamin K. Karadeniz
, Mehish Computer Services [EMAIL PROTECTED] -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, Would you be willing to forward

RE: Backup Strategy

2002-01-24 Thread Mark Leith
To: Multiple recipients of list ORACLE-L Subject: RE: Backup Strategy 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

Re: Backup Strategy

2002-01-24 Thread C.S.Venkata Subramanian
, January 22, 2002 6:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Backup Strategy 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

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.

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 Office 818

RE: Backup Strategy

2002-01-24 Thread Kimberly Smith
:[EMAIL PROTECTED]] Sent: Tue, January 22, 2002 6:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Backup Strategy Hamid, Would you be willing to forward a copy of this paper? Thanks, Ross Mohan -Original Message- Sent

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 Rick_Cale
Smith To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ksmith2@myfirscc: tlink.net Subject: RE: Backup Strategy

RE: Backup Strategy

2002-01-24 Thread Mercadante, Thomas F
: Backup Strategy 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

RE: Backup Strategy

2002-01-24 Thread JoJo Al-Zawawi
] -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, Would you be willing to forward a copy of this paper? Thanks

RE: Backup Strategy

2002-01-24 Thread Bellows, Bambi
22, 2002 6:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Backup Strategy 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

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 gotta

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 Thater

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] Fat

Re: Backup Strategy

2002-01-24 Thread Igor Neyman
PROTECTED] -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, Would you be willing to forward a copy of this paper

Re: Backup Strategy

2002-01-24 Thread Jared . Still
recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Backup Strategy I took a quick look at this paper, and found right away, that it's not very accurate, at least in one issue. i.e., it states : quote The Windows NT command COPY can be used to create a cold backup

RE: Backup Strategy

2002-01-24 Thread Sujatha Madan
, Mehish Computer Services [EMAIL PROTECTED] -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, Would you be willing

RE: Backup Strategy

2002-01-24 Thread Johnston, Tim
:[EMAIL PROTECTED]] Sent: Tue, January 22, 2002 6:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Backup Strategy Hamid, Would you be willing to forward a copy of this paper? Thanks, Ross Mohan -Original Message

RE: Backup Strategy

2002-01-24 Thread Kimberly Smith
is not a member!!! Kimberly Smith To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ksmith2@myfirscc: tlink.net Subject: RE: Backup Strategy Sent

Re: Backup Strategy

2002-01-24 Thread Peter . McLarty
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, and it works fine. Igor, you sure about

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

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

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-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

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.

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

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

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

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

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: Backup Strategy We'd

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 mode you should be ok. Do your

RE: Backup Strategy

2001-10-22 Thread Kimberly Smith
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 recover time by not having to go to tape

RE: Backup Strategy

2001-10-22 Thread DENNIS WILLIAMS
]] 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 the latest on disk. That way you reduce your

RE: Backup Strategy

2001-10-22 Thread 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'd need a little more information before we can give any advice (okay, this group gives advice on no information but..) Some questions

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

RE: Backup Strategy

2001-10-05 Thread Cherie_Machler
: Sent by:Subject: RE: Backup Strategy [EMAIL PROTECTED

RE: Backup Strategy

2001-10-05 Thread Christopher Spence
PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ach.fl.us cc: Sent by:Subject: RE: Backup Strategy [EMAIL PROTECTED] 10/04/01 02:10 PM

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-04 Thread Guy Hammond
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 of information to get from your users is the Mean

RE: Backup Strategy

2001-10-04 Thread Mercadante, Thomas F
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: Veronica Levin Asunto: RE: Backup Strategy Veronica, Before you can decide on what your

RE: Backup Strategy

2001-10-04 Thread Veronica Levin
, 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, I hope the replies you

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

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

RE: Backup Strategy

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

RE: Backup Strategy

2001-10-04 Thread Ramon Estevez
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 'Backup and Recovery

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

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
- 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 it. Tom Cox put

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

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 doesn't make 100% sense

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

RE: Backup Strategy

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

RE: Backup Strategy

2001-10-04 Thread Gene Sais
] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ach.fl.us cc: Sent by:Subject: RE: Backup Strategy

RE: Backup Strategy

2001-10-04 Thread Veronica Levin
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 'Backup

RE: Backup Strategy

2001-10-04 Thread Jared . Still
: Subject: RE: Backup Strategy 10/04/01 02:23 PM

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 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 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,

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
] [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 excellent paper on BU and Reco

RE: Backup Strategy

2001-10-04 Thread Kimberly Smith
: Backup Strategy [EMAIL PROTECTED] 10/04/01 02:10 PM Please respond to ORACLE-L Well for 1 reason, Cold backups are restored using OS cmds, no need for Oracle recovery, whereas, Hot Backups require OS cmds

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

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

RE: Backup Strategy

2001-10-04 Thread Veronica Levin
: 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 Oracle Press books I have

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 to

Re: RE: Backup Strategy

2001-10-04 Thread Gene Sais
Gene Sais [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ach.fl.us cc: Sent by:Subject: RE: Backup Strategy [EMAIL PROTECTED

Re: Backup Strategy

2001-10-03 Thread satar naghshineh
Your backup strategy all depends on your business requirements for uptime. Consult your Manager and let him/her give you the guidelines. I can give you my backup strategy, just write me an e-mail at [EMAIL PROTECTED] It has our business requirements and the Backup that I have put in place to

RE: Backup Strategy

2001-10-03 Thread Mercadante, Thomas F
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. Simply put, you ask the user how long they can afford to be without

RE: Backup Strategy

2001-10-03 Thread Veronica Levin
: 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. Simply put, you ask the user how

Re: Backup Strategy

2001-10-03 Thread George Schlossnagle
: 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 of information to get

Re: Backup strategy using RMAN

2001-09-08 Thread rabbit
Thanks to respondee's: The problem was a host name in etc/system on the netbackup server: I'm sure the funs not over yet. Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: Backup strategy using RMAN

2001-09-04 Thread Ruth Gramolini
I will give these questions a shot. See my replies inline. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 10:02 AM Hi all, I have been given an assignment to formulate different backup strategies for OLTP

  1   2   >