RE: V7 online backups
Try the following link for documentation. http://technet.oracle.com/doc/server734.htm HTH Lee -Original Message- Sent: 06 December 2001 18:29 To: Multiple recipients of list ORACLE-L I'm not sure if I'm bragging or complaining, but I've never setup or supported online backups for Oracle. I'm being directed to implement online backups for a V7.3.4.5 instance. A search of OTN reveals that Oracle no longer seems to have any V7 documents available anymore. :-( Since this DB is stuck at V7.3.4.5 for at least 6 more months, I need to get online backups operational without using RMAN. If somebody who has *nix shell script(s) or Perl code that implements online backups, I'd appreciate if you would send a copy my way. I'm just looking for something to get me started. TIA & HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 to_date((2440588+((date_time-mod(date_time,86400))/86400)),'J')-8/24+mod(dat e_time,86400)/86400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: V7 online backups
How about EBU? It is actually fairly good in 7.3.4+ and is very straightforward to set up. Like RMAN, It uses a database catalog, but the command syntax is radically different - in my opinion, much more straightforward. It also include a shell command line utility named ebutool that is quite useful. I used it for years on many systems without significant problems. What hardware (e.g. DLT IV, etc.) and software (e.g. Veritas NetBackup) resources do you already have? Will the entire backup fit on one tape? If so, I have a set of ksh & SQL scripts that do extensive error checking and get the file list dynamically from v$datafile - so no "new" datafiles are overlooked. They also do archive log cleanup, can verify the backup by reading it off of the tape, and some other stuff. These scripts may or may not be appropriate for your case. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 12:29 PM > I'm not sure if I'm bragging or complaining, but I've never setup > or supported online backups for Oracle. I'm being directed to > implement online backups for a V7.3.4.5 instance. A search of > OTN reveals that Oracle no longer seems to have any V7 documents > available anymore. :-( > > Since this DB is stuck at V7.3.4.5 for at least 6 more months, > I need to get online backups operational without using RMAN. > If somebody who has *nix shell script(s) or Perl code that > implements online backups, I'd appreciate if you would send a > copy my way. I'm just looking for something to get me started. > > TIA & HAND! > > -- > Charlie Mengler Maintenance Warehouse > [EMAIL PROTECTED] 10641 Scripps Summit Ct. > 858-831-2229 San Diego, CA 92131 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: V7 online backups
Charlie, You must first put your database in ArchiveLog mode, of course. The basic init.ora parameters to set and the command "Alter Database ArchiveLog" (while mounted, but not open, after a clean shutdown) haven't really changed from 7 to 8 to 8i, except now you can specify archive log duplexing. A simple SQL script might get you started. For each Tablespace: Alter Tablespace Begin Backup ; Host cp /ts1_datafile_1.dbf Host cp /ts1_datafile_2.dbf ... Alter Tablespace End Backup ; ... Save the datafile copies and your archived redo logs, as well as backup control files, and you've got it covered. Oh, and don't back up your online redo logs - they'll be worthless for a recovery and can cause you grief if you restore them over your current, good, ones. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Mengler Sent: Thursday, December 06, 2001 12:29 PM To: Multiple recipients of list ORACLE-L I'm not sure if I'm bragging or complaining, but I've never setup or supported online backups for Oracle. I'm being directed to implement online backups for a V7.3.4.5 instance. A search of OTN reveals that Oracle no longer seems to have any V7 documents available anymore. :-( Since this DB is stuck at V7.3.4.5 for at least 6 more months, I need to get online backups operational without using RMAN. If somebody who has *nix shell script(s) or Perl code that implements online backups, I'd appreciate if you would send a copy my way. I'm just looking for something to get me started. TIA & HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 to_date((2440588+((date_time-mod(date_time,86400))/86400)),'J')-8/24+mod(dat e_time,86400)/86400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: V7 online backups
Charlie, check out alter tablespace begin backup. thats has not changed since version 7, so even the 9i docs will cover it and with 9i docs, there is a whole section on user managed backups. joe Charlie Mengler wrote: > I'm not sure if I'm bragging or complaining, but I've never setup > or supported online backups for Oracle. I'm being directed to > implement online backups for a V7.3.4.5 instance. A search of > OTN reveals that Oracle no longer seems to have any V7 documents > available anymore. :-( > > Since this DB is stuck at V7.3.4.5 for at least 6 more months, > I need to get online backups operational without using RMAN. > If somebody who has *nix shell script(s) or Perl code that > implements online backups, I'd appreciate if you would send a > copy my way. I'm just looking for something to get me started. > > TIA & HAND! > > -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
V7 online backups
I'm not sure if I'm bragging or complaining, but I've never setup or supported online backups for Oracle. I'm being directed to implement online backups for a V7.3.4.5 instance. A search of OTN reveals that Oracle no longer seems to have any V7 documents available anymore. :-( Since this DB is stuck at V7.3.4.5 for at least 6 more months, I need to get online backups operational without using RMAN. If somebody who has *nix shell script(s) or Perl code that implements online backups, I'd appreciate if you would send a copy my way. I'm just looking for something to get me started. TIA & HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 to_date((2440588+((date_time-mod(date_time,86400))/86400)),'J')-8/24+mod(date_time,86400)/86400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).