RE: GZip/WinZip...hot backups...
You are welcome. :) -Original Message- Sent: Thursday, July 18, 2002 10:28 AM To: Multiple recipients of list ORACLE-L My humble apologies to the list... He checked the backup script... host gzip -cf1 /disk2/oradata/rcdc/system.dbf > /disk1/orabkup/rcdc/system.gz Good call Richard... There was a junior DBA that he was training that had setup the backup script. Oh well. Sorry for wasting everyone's time. A beer for everyone at the next IOUG...Jared is buying -Original Message- Sent: Wednesday, July 17, 2002 3:24 PM To: Multiple recipients of list ORACLE-L A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything "seems" to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Grabowy, Chris 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: Ji, Richard 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: GZip/WinZip...hot backups...
My humble apologies to the list... He checked the backup script... host gzip -cf1 /disk2/oradata/rcdc/system.dbf > /disk1/orabkup/rcdc/system.gz Good call Richard... There was a junior DBA that he was training that had setup the backup script. Oh well. Sorry for wasting everyone's time. A beer for everyone at the next IOUG...Jared is buying -Original Message- Sent: Wednesday, July 17, 2002 3:24 PM To: Multiple recipients of list ORACLE-L A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything "seems" to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Grabowy, Chris 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: GZip/WinZip...hot backups...
>From what i remember Winzip has a file limit of 4gb... Lewis Bishop --- Barclays Enable/ISS/OPTS Oracle Database Consultant Phone: 020 8298 3418 Mobile: 07950 380857 Email:[EMAIL PROTECTED] -Original Message- Sent: 17 July 2002 20:24 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything "seems" to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: GZip/WinZip...hot backups...
You may want to investigate 'sparse files' on MetaLink, as some compression utilities could cause problems. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/17/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: GZip/WinZip...hot backups... A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything "seems" to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: 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: GZip/WinZip...hot backups...
If you gzip a .dbf file, you get .dbf.gz extension. Is that what he was doing? What's the full filename after gzipped? Richard -Original Message- Sent: Wednesday, July 17, 2002 3:24 PM To: Multiple recipients of list ORACLE-L A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything "seems" to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Ji, Richard 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).
GZip/WinZip...hot backups...
A fellow DBA had mentioned that during his disaster recovery test, gzip had unzipped his Solaris files but did not restore the .dbf extension. Thus leaving him to manually rename his files to include a .dbf extension. He examined the gzip man pages but could not find any flags to set or anything to help. Has anyone else encountered this? Ideas? During a hot backup, on W2K platform, he uses WinZip to backup/compress all the datafiles into one large backup file. Has anyone encountered any problems with using this approach? Versus using the ocopy or copy command? He mentioned that on occasion he gets an error message from WinZip that the file was open, but everything "seems" to work. Many thanks in advance!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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).