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 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 -- 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: Gene Sais > 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: 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).