RE: Backup DB files to the Tape
Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Backup DB files to the Tape
It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing
RE: Backup DB files to the Tape
Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
RE: Backup DB files to the Tape
Long live Dilbert! The scary thing around here is that the guy that most fits the description is an NT admin. He even has empty Mountain Dew cans all over his cubicle. The only thing missing are the Hostess Twinkie wrappers. -Original Message- From: Brian Dunbar [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Backup DB files to the Tape
Condescending Unix user! -Original Message- Sent: Thursday, December 19, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Backup DB files to the Tape
That's MR. Condescending Unix user thankyouverymuch. -Original Message- Sent: Thursday, December 19, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Condescending Unix user! -Original Message- Sent: Thursday, December 19, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Re: Backup DB files to the Tape
The only thing missing are the Hostess Twinkie wrappers. So, put your wrappers there to make it perfect. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 8:52 PM Long live Dilbert! The scary thing around here is that the guy that most fits the description is an NT admin. He even has empty Mountain Dew cans all over his cubicle. The only thing missing are the Hostess Twinkie wrappers. -Original Message- From: Brian Dunbar [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Backup DB files to the Tape
Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Backup DB files to the Tape
I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Backup DB files to the Tape
Hi!! Check for the -K option of the TAR command... is for supporting files 2 Gb... if you do not have that option, you could use CPIO HTH JL --- Ashraf Salaymeh [EMAIL PROTECTED] wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Backup DB files to the Tape
Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Backup DB files to the Tape
I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
Re: Backup DB files to the Tape
I do not get it. If you put the tablespace in backup mode and then use the os utilities to copy the datafiles to tape why you can not use then for recover. Just restore the datafiles and the archive logs and do recover? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 7:04 PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an
Re: Backup DB files to the Tape
I am using home grown scripts and they work. I have Legato use savepnpc (pre/post proc) command call this script: //begin snippet comment section #!/bin/ksh ### # $ORABIN/db_hot_backup.ksh ### # # Common script used to alter one database or all databases # on this server for hot backup mode (begin/end). # This script does NOT actually copy database files to disk # or to tape. # # Hot Backup Algorithm listed below: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Alter system archive log current ; # 8) Backup controlfile. # 9) Alter system archive log current ; # # Date Author Note # -- # 04/26/02 Gene Sais Original Creation # 08/02/02 Gene Sais Copied trace file to Hot Backup Location ### # Parameter Description # - --- sid=$1 # Database sid or all begend=$2 # Begin or End Hot Backup //end snippet comment section hth, Gene PS. I have tested recoveries and they worked, but soon my scripts will succumb to RMAN :). [EMAIL PROTECTED] 12/18/02 12:04PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Backup DB files to the Tape
The key is putting the tablespace in backup mode. It then doesn't matter whether you write the file to disk or tape. Homegrown scripts will work just fine in writing directly to tape, although it should be quite a bit slower than writing to disk and then letting the system backup process simply sweep the directory to tape (preferred method). Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com www.KBMotorsports.biz -Original Message- Sent: Wednesday, December 18, 2002 12:56 PM To: Multiple recipients of list ORACLE-L I do not get it. If you put the tablespace in backup mode and then use the os utilities to copy the datafiles to tape why you can not use then for recover. Just restore the datafiles and the archive logs and do recover? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 7:04 PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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:
Re: Backup DB files to the Tape
You probably can. I just wasn't sure. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:55 PM I do not get it. If you put the tablespace in backup mode and then use the os utilities to copy the datafiles to tape why you can not use then for recover. Just restore the datafiles and the archive logs and do recover? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 7:04 PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 --
Re: Backup DB files to the Tape
Ruth, I am a little confused here. Are you saying that putting hot backups to tape directly will NOT be useful for recovery? Why not? Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 12:04 PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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,
Re: Backup DB files to the Tape
If you are using Legato, you are using a third party media manager. I am not sure you can do backup to tape directly without such a product. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:15 PM I am using home grown scripts and they work. I have Legato use savepnpc (pre/post proc) command call this script: //begin snippet comment section #!/bin/ksh ### # $ORABIN/db_hot_backup.ksh ### # # Common script used to alter one database or all databases # on this server for hot backup mode (begin/end). # This script does NOT actually copy database files to disk # or to tape. # # Hot Backup Algorithm listed below: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Alter system archive log current ; # 8) Backup controlfile. # 9) Alter system archive log current ; # # Date Author Note # -- # 04/26/02 Gene Sais Original Creation # 08/02/02 Gene Sais Copied trace file to Hot Backup Location ### # Parameter Description # - --- sid=$1 # Database sid or all begend=$2 # Begin or End Hot Backup //end snippet comment section hth, Gene PS. I have tested recoveries and they worked, but soon my scripts will succumb to RMAN :). [EMAIL PROTECTED] 12/18/02 12:04PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
Re: Backup DB files to the Tape
Not true Ruth. I use Legato's savepnpc command to call pre/post proc scripts. Their media manager Oracle Business Suite requires RMAN and I am not switching just yet :) [EMAIL PROTECTED] 12/18/02 02:56PM If you are using Legato, you are using a third party media manager. I am not sure you can do backup to tape directly without such a product. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:15 PM I am using home grown scripts and they work. I have Legato use savepnpc (pre/post proc) command call this script: //begin snippet comment section #!/bin/ksh ### # $ORABIN/db_hot_backup.ksh ### # # Common script used to alter one database or all databases # on this server for hot backup mode (begin/end). # This script does NOT actually copy database files to disk # or to tape. # # Hot Backup Algorithm listed below: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Alter system archive log current ; # 8) Backup controlfile. # 9) Alter system archive log current ; # # Date Author Note # -- # 04/26/02 Gene Sais Original Creation # 08/02/02 Gene Sais Copied trace file to Hot Backup Location ### # Parameter Description # - --- sid=$1 # Database sid or all begend=$2 # Begin or End Hot Backup //end snippet comment section hth, Gene PS. I have tested recoveries and they worked, but soon my scripts will succumb to RMAN :). [EMAIL PROTECTED] 12/18/02 12:04PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Re: Backup DB files to the Tape
Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).