RE: Backup DB files to the Tape

2002-12-19 Thread Hemant K Chitale
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

RE: Backup DB files to the Tape

2002-12-19 Thread Stephen Lee
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

RE: Backup DB files to the Tape

2002-12-19 Thread Brian Dunbar
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

RE: Backup DB files to the Tape

2002-12-19 Thread Stephen Lee
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

RE: Backup DB files to the Tape

2002-12-19 Thread Miller, Jay
: 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

RE: Backup DB files to the Tape

2002-12-19 Thread Brian Dunbar
. -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

Re: Backup DB files to the Tape

2002-12-19 Thread Yechiel Adar
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

Re: Backup DB files to the Tape

2002-12-18 Thread Ruth Gramolini
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

RE: Backup DB files to the Tape

2002-12-18 Thread Stephen Lee
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

Re: Backup DB files to the Tape

2002-12-18 Thread Jose Luis Delgado
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

RE: Backup DB files to the Tape

2002-12-18 Thread John Weatherman
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

Re: Backup DB files to the Tape

2002-12-18 Thread Ruth Gramolini
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

Re: Backup DB files to the Tape

2002-12-18 Thread Yechiel Adar
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

Re: Backup DB files to the Tape

2002-12-18 Thread Gene Sais
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

RE: Backup DB files to the Tape

2002-12-18 Thread Burke, William F (Bill)
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

Re: Backup DB files to the Tape

2002-12-18 Thread Ruth Gramolini
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

Re: Backup DB files to the Tape

2002-12-18 Thread Arup Nanda
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

Re: Backup DB files to the Tape

2002-12-18 Thread Ruth Gramolini
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

Re: Backup DB files to the Tape

2002-12-18 Thread Gene Sais
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

Backup DB files to the Tape

2002-12-17 Thread Ashraf Salaymeh
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

Re: Backup DB files to the Tape

2002-12-17 Thread dilmohan
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: