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