RE: rman backup
Sorry to respond to such an old thread (man I'm way behind), but what if the expected location of the archived logs isn't large enough? For example, let's say we have a 10G archive directory, and we dump 5-10G of logs per day. I have to go to a backup made a week ago. That's 35-70G worth of logs if I need to roll forward. Does RMAN try and cram 'em all in at once, or will it roll through them? That sure would be a nice feature. ;-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Tuesday, October 28, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: rman backup AK When you have RMAN back up archived logs, IIRC, in a recovery RMAN first restores those archived logs to the location that Oracle will expect them to be, and I believe that is done as part of the RESTORE DATABASE command. In my situation, I found no advantage from having RMAN store the archive logs, so I have no experience there, just what I've read in the manual. Only RMAN can perform the RESTORE DATABASE command, but once you complete that command, you can complete the recovery using svrmgrl. From everything I've seen, RMAN just issues the RECOVER DATABASE command to svrmgrl or SQL*Plus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Thanks Dennis for Reply, My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: AK 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: DENNIS WILLIAMS 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
RE: rman backup
AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: rman backup
You can restore database and open it to the mount phase using RMAN. Then you can get into sqlplus and type something like: alter system set log_archive_dest_1=/directory/where/log/archives/reside set autorecovery on recover database auto until cancel On 10/28/2003 12:44:24 PM, AK wrote: We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: rman backup
Thanks Dennis for Reply, My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: AK 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: rman backup
As long as you have the database in archivelog mode and have a level 0 backup as your starting point then you can recover. Make sure that your level 0 includes the controlfiles. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Tuesday, October 28, 2003 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: rman backup We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak
RE: rman backup
AK When you have RMAN back up archived logs, IIRC, in a recovery RMAN first restores those archived logs to the location that Oracle will expect them to be, and I believe that is done as part of the RESTORE DATABASE command. In my situation, I found no advantage from having RMAN store the archive logs, so I have no experience there, just what I've read in the manual. Only RMAN can perform the RESTORE DATABASE command, but once you complete that command, you can complete the recovery using svrmgrl. From everything I've seen, RMAN just issues the RECOVER DATABASE command to svrmgrl or SQL*Plus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Thanks Dennis for Reply, My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: AK 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: DENNIS WILLIAMS 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: RMAN backup and recovery scenarios
Prem - I haven't found anything significant online. Perhaps someone else (Bwill point to a resource. If you want to learn RMAN, my recommendation is to (Bget a couple of books. The advantage of a book is you end up with a (Bcomprehensive resource for reference. Myself, I need to go back and refresh (Bmyself now and then. (B - Oracle9i RMAN Backup Recovery by Robert Freeman (B - I found Oracle 101 Backup Recovery (Smith and Haisley) helpful to get (Bstarted. About half of it is RMAN. It has very simple tutorials that you can (Bfollow step-by-step to understand the basic RMAN concepts. But Robert's book (Bwasn't published when I was trying to set up RMAN. (B (BDennis Williams (BDBA, 80%OCP, 100% DBA (BLifetouch, Inc. (B[EMAIL PROTECTED] (B (B (B-Original Message- (BSent: Thursday, September 04, 2003 1:44 AM (BTo: Multiple recipients of list ORACLE-L (B (B (BHi all, (B (BIs there any doc./URL which lists out RMAN backup and recovery scenarios ? (Bdid not find one in metalink. (B (BThanks Regards, (BJp. (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: DENNIS WILLIAMS (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
RE: RMAN backup and recovery scenarios
Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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).
RE: RMAN backup and recovery scenarios
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: RMAN backup and recovery scenarios
Besides you may refer to Backup Recovery by Rama Velpuri (8/8i). A bit old but nevertheless good. All said and done, create a clone database and keep crashing it in all ways you can think of, and try to recover it. That should give you the confidence , letting you know how oracle handles the internals etc. Go thru Recovery principles, Case Studies by Rama Velpuri. (Add RF's book too). Try doing the same with Standby too. HTH GovindanK My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: GovindanK 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: RE: RMAN backup and recovery scenarios
Thanx Dennis,Robert,and Ruth. I'm going thro' Roberts's book now. as Robert said, it has a dedicated chapter for that. ...and i'm trying all the scenarios one by one . but just thought, i could some more inputs from you Gurus. thanx a lot guys. I will continue with the book. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: RMAN Backup piece being placed in wrong directory
Good point Tom RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 1:29 PM Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Robert? Dennis? Anyone? -Original Message- Sent: Thursday, August 07, 2003 9:24 AM To: Multiple recipients of list ORACLE-L OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{ set archivelog destination to 'D:\backup\oracle\Hotbackup'; set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak'; backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; } Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=4 recid=2 stamp=500738572 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting archive log backupset channel ORA_DISK_2: specifying archive log(s) in backup set input archive log thread=1 sequence=5 recid=1 stamp=500738568 input archive log thread=1 sequence=6 recid=3 stamp=500738573 input archive log thread=1 sequence=7 recid=4 stamp=500738574 input archive log thread=1 sequence=8 recid=5 stamp=500815654 input archive log thread=1 sequence=9 recid=6 stamp=500824391 input archive log thread=1 sequence=10 recid=7 stamp=501340112 channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting archive log backupset channel ORA_DISK_3: specifying archive log(s) in backup set input archive log thread=1 sequence=11 recid=8 stamp=501343673 input archive log thread=1 sequence=12 recid=9 stamp=501343804 input archive log thread=1 sequence=13 recid=10 stamp=501347437 input archive log thread=1 sequence=14 recid=11 stamp=501347562 input archive log thread=1 sequence=15 recid=12 stamp=501407160 input archive log thread=1 sequence=16 recid=13 stamp=501407288 channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=17 recid=14 stamp=501407709 input archive log thread=1 sequence=18 recid=15 stamp=501407832 input archive log thread=1 sequence=19 recid=16 stamp=501407991 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:20 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBF input datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBF input datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBF input datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBF channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting full datafile backupset channel ORA_DISK_2: specifying datafile(s) in backupset input datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBF input datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBF input datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBF input datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBF channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting full datafile backupset
RE: RMAN Backup piece being placed in wrong directory
Syntax error: backup database format = 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; add the = after the format and it should run. RMAN is trying to help you by ignoring this error and proceeding to backup the database to the default location. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 12:14 PM Robert? Dennis? Anyone? -Original Message- Sent: Thursday, August 07, 2003 9:24 AM To: Multiple recipients of list ORACLE-L OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{ set archivelog destination to 'D:\backup\oracle\Hotbackup'; set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak'; backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; } Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=4 recid=2 stamp=500738572 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting archive log backupset channel ORA_DISK_2: specifying archive log(s) in backup set input archive log thread=1 sequence=5 recid=1 stamp=500738568 input archive log thread=1 sequence=6 recid=3 stamp=500738573 input archive log thread=1 sequence=7 recid=4 stamp=500738574 input archive log thread=1 sequence=8 recid=5 stamp=500815654 input archive log thread=1 sequence=9 recid=6 stamp=500824391 input archive log thread=1 sequence=10 recid=7 stamp=501340112 channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting archive log backupset channel ORA_DISK_3: specifying archive log(s) in backup set input archive log thread=1 sequence=11 recid=8 stamp=501343673 input archive log thread=1 sequence=12 recid=9 stamp=501343804 input archive log thread=1 sequence=13 recid=10 stamp=501347437 input archive log thread=1 sequence=14 recid=11 stamp=501347562 input archive log thread=1 sequence=15 recid=12 stamp=501407160 input archive log thread=1 sequence=16 recid=13 stamp=501407288 channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=17 recid=14 stamp=501407709 input archive log thread=1 sequence=18 recid=15 stamp=501407832 input archive log thread=1 sequence=19 recid=16 stamp=501407991 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:20 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBF input datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBF input datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBF input datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBF channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting full datafile backupset channel ORA_DISK_2: specifying datafile(s) in backupset input datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBF input datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBF input datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBF input datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBF channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting full datafile backupset channel ORA_DISK_3: specifying datafile(s) in backupset input datafile fno=1 name=D:\ORACLE\EWFMS\SYSTEM01.DBF input datafile fno=4 name=D:\ORACLE\EWFMS\DRSYS01.DBF input datafile fno=5 name=D:\ORACLE\EWFMS\INDX01.DBF input datafile fno=7 name=D:\ORACLE\EWFMS\USERS01.DBF channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece
RE: RMAN Backup piece being placed in wrong directory
Title: Message Doh! Thanks for pointing out the obvious to me. I'm sure that will work. I'll go crawl back in my cave now :ol Thanks Tom! -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RMAN Backup piece being placed in wrong directory Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: RMAN Backup piece being placed in wrong directory Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being placed in wrong directory OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;} Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 stamp=501343673input archive log thread=1 sequence=12 recid=9 stamp=501343804input archive log thread=1 sequence=13 recid=10 stamp=501347437input archive log thread=1 sequence=14 recid=11 stamp=501347562input archive log thread=1 sequence=15 recid=12 stamp=501407160input archive log thread=1 sequence=16 recid=13 stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:20Finished backup at 07-AUG-03 Starting backup at 07-AUG-03using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile
RE: RMAN Backup piece being placed in wrong directory
Title: Message Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: RMAN Backup piece being placed in wrong directory Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being placed in wrong directory OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;} Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 stamp=501343673input archive log thread=1 sequence=12 recid=9 stamp=501343804input archive log thread=1 sequence=13 recid=10 stamp=501347437input archive log thread=1 sequence=14 recid=11 stamp=501347562input archive log thread=1 sequence=15 recid=12 stamp=501407160input archive log thread=1 sequence=16 recid=13 stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:20Finished backup at 07-AUG-03 Starting backup at 07-AUG-03using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBFinput datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBFinput datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBFinput datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBFchannel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting full datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBFinput datafile fno=00012
RE: RMAN backup with MULTIPLE CHANNELS ......
Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: DENNIS WILLIAMS 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: RMAN backup with MULTIPLE CHANNELS ......
Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: DENNIS WILLIAMS 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: Janardhana Babu Donga 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: RMAN backup with MULTIPLE CHANNELS ......
One possibility is that the backup job is already maxing out the network connection between the client system and the Veritas NetBackup master server and/or media server. If you have a 10megabit network and LTO drives, the network will never be able to keep the tapes streaming. Adding 3 channels won't help if your network can't keep up. I'm speculating here, as you don't really supply enough info about your environment. Jared Janardhana Babu Donga [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/20/2003 10:47 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: DENNIS WILLIAMS 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: Janardhana Babu Donga 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: 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: RMAN backup with MULTIPLE CHANNELS ......
Jared, Please let me know what info you need. I would collect it from my Netbackup administrator and let you know. Thanks, -- Babu -Original Message- Sent: Thursday, February 20, 2003 1:02 PM To: Multiple recipients of list ORACLE-L One possibility is that the backup job is already maxing out the network connection between the client system and the Veritas NetBackup master server and/or media server. If you have a 10megabit network and LTO drives, the network will never be able to keep the tapes streaming. Adding 3 channels won't help if your network can't keep up. I'm speculating here, as you don't really supply enough info about your environment. Jared Janardhana Babu Donga [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/20/2003 10:47 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: DENNIS WILLIAMS 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: Janardhana Babu Donga 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: 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: RMAN backup with MULTIPLE CHANNELS ......
Look for something like channels-per-tapedrive on the backup server configuration. You have to be above this figure to use multiple tape drives. [EMAIL PROTECTED] 02/21/03 07:47a.m. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: DENNIS WILLIAMS 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: Janardhana Babu Donga 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: Binley Lim 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: RMAN backup with MULTIPLE CHANNELS ......
also check Maximum Jobs per client. you will find this setting in the Netbackup preferences window (Netbackup Java console). -Mandar -Original Message- From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup with MULTIPLE CHANNELS .. Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: Mandar A. Ghosalkar 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: RMAN backup with MULTIPLE CHANNELS ......
Just be sure and post it to the list. There are folks here with more NBU/RMAN experience than I. Network between database server, master server and media server. 10Megabit, 100 Megabit, Gigabit? Concurrent backup jobs? # of Tape drives dedicated to this backup? Type of drive? LTO, DLT, Super DLT? This question is better phrased as: What is the streaming capacity of the drives involved in the backup? There are more questions, but this is a start. Jared Janardhana Babu Donga [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/20/2003 02:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Jared, Please let me know what info you need. I would collect it from my Netbackup administrator and let you know. Thanks, -- Babu -Original Message- Sent: Thursday, February 20, 2003 1:02 PM To: Multiple recipients of list ORACLE-L One possibility is that the backup job is already maxing out the network connection between the client system and the Veritas NetBackup master server and/or media server. If you have a 10megabit network and LTO drives, the network will never be able to keep the tapes streaming. Adding 3 channels won't help if your network can't keep up. I'm speculating here, as you don't really supply enough info about your environment. Jared Janardhana Babu Donga [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/20/2003 10:47 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: DENNIS WILLIAMS 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: Janardhana Babu Donga 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
RE: RMAN backup with MULTIPLE CHANNELS ......
Mandar, Thanks for your reply. Iam in the process of checking with my Netbackup Administrator about the parameter: Max_jobs_per_client. After seeing your E-Mail, I too looked into the online manual and it seems the value should be = Number of streams X No.Of Classes. In my case No.Of classes equals to 1, and since I would like to use 3 tape drives thru 3 channels, I think Max_Jobs_per_client must be set to 3. I forwarded the info to my Netbackup Admin. Thanks for the info. -- Babu -Original Message- Sent: Thursday, February 20, 2003 2:52 PM To: Multiple recipients of list ORACLE-L also check Maximum Jobs per client. you will find this setting in the Netbackup preferences window (Netbackup Java console). -Mandar -Original Message- From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup with MULTIPLE CHANNELS .. Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: Mandar A. Ghosalkar 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: Janardhana Babu Donga 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: RMAN backup/restore to disk on 600G - terabyte Databases?? SP
Title: RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED? Brian, If time is of the essence and you have EMC BCV's, look at Time Finder. I believe that's EMC's piece of software that allows you to sync and split a third mirror. That will be much faster for recovery than just about anything you can tweak. Have fun ! Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Spears, Brian [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:21 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED? Hi, I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how fast I might restore a full backup of a 600gig to a Terabyte database. The machine probably will have 10+ cpus HP machine and EMC disk although the backups will probably sit on a fast SAN. There will be 12Gig of fast memory... 200,000 users...max 10,000 concurrent, 100MB io card. IF anyone has done it...what speeds could you obtain with RMAN from Disk? What were the best SPEED enhancing factors?? ( I know cpus, mult-channels, and memory, disk ban widths anymore?) Thanks, Brian Spears -Original Message- Sent: Thursday, January 30, 2003 10:09 AM To: Multiple recipients of list ORACLE-L OK, that's it. My mountain bike is coming out TODAY. I don't care if it's 10F out. There's no snow, so it won't be as fun, but that's alright. And, Lisa, in '99 I pedalled 450 miles from Superior to Madison, WI in a week. I admit that I spent some time in Rehab afterwards for rough cartilage (I was BORN geeky, too!), but it was a blast nonetheless. Hm...maybe I'd better set my arse on the stationary bike for a few weeks first before taking on the trails. Now I'm depressed. Thank God it's Beer Day! http://society.servebeer.com :) Now back to your regularly schedule database problems... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:15 PM To: Multiple recipients of list ORACLE-L Hey, I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND! Koivu, Lisa Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by: Subject: RE: Take Care of your DBAs [EMAIL PROTECTED] 01/29/2003 01:54 PM Please respond to ORACLE-L I used to play Ping Pong with the sysadmins and the app architect... aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Spears, Brian 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: RMAN backup/restore to disk on 600G - terabyte Databases?? SP
Hi, I have used 12 channels to backup 700GB database and writing to FOUR TAPES at the same time. I used to backed up in 4 1/2 hours. On EMC disk, restore was done in 8 hours. allocate channel c1 type 'SBT_TAPE'; allocate channel c2 type 'SBT_TAPE'; allocate channel c3 type 'SBT_TAPE'; allocate channel c4 type 'SBT_TAPE'; allocate channel c5 type 'SBT_TAPE'; allocate channel c6 type 'SBT_TAPE'; allocate channel c7 type 'SBT_TAPE'; allocate channel c8 type 'SBT_TAPE'; allocate channel c9 type 'SBT_TAPE'; allocate channel c10 type 'SBT_TAPE'; allocate channel c11 type 'SBT_TAPE'; allocate channel c12 type 'SBT_TAPE'; setlimit channel c1 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c2 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c3 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c4 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c5 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c6 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c7 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c8 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c9 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c10 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c11 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c12 kbytes 2097150 maxopenfiles 16 readrate 500; Thanks Muqthar Ahmed DBA -Original Message- Sent: Thursday, January 30, 2003 11:21 AM To: Multiple recipients of list ORACLE-L SPEED? Hi, I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how fast I might restore a full backup of a 600gig to a Terabyte database. The machine probably will have 10+ cpus HP machine and EMC disk although the backups will probably sit on a fast SAN. There will be 12Gig of fast memory... 200,000 users...max 10,000 concurrent, 100MB io card. IF anyone has done it...what speeds could you obtain with RMAN from Disk? What were the best SPEED enhancing factors?? ( I know cpus, mult-channels, and memory, disk ban widths anymore?) Thanks, Brian Spears -Original Message- Sent: Thursday, January 30, 2003 10:09 AM To: Multiple recipients of list ORACLE-L OK, that's it. My mountain bike is coming out TODAY. I don't care if it's 10F out. There's no snow, so it won't be as fun, but that's alright. And, Lisa, in '99 I pedalled 450 miles from Superior to Madison, WI in a week. I admit that I spent some time in Rehab afterwards for rough cartilage (I was BORN geeky, too!), but it was a blast nonetheless. Hm...maybe I'd better set my arse on the stationary bike for a few weeks first before taking on the trails. Now I'm depressed. Thank God it's Beer Day! http://society.servebeer.com :) Now back to your regularly schedule database problems... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:15 PM To: Multiple recipients of list ORACLE-L Hey, I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND! Koivu, Lisa Lisa.Koivu@efairTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by: Subject: RE: Take Care of your DBAs [EMAIL PROTECTED] 01/29/2003 01:54 PM Please respond to ORACLE-L I used to play Ping Pong with the sysadmins and the app architect... aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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
RE: RMAN backup - basic Qs
I stand corrected. thanks Robert. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 3:20 PM To: Multiple recipients of list ORACLE-L RMAN does no compression on any blocks with data. The only compression that occurs that blocks above the HWM are not included. No compression of data occurs, and in fact empty blocks can and are backed up by RMAN. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L No. Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is simply reading the blocks, compressing them, and writing them to tape. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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: Mercadante, Thomas F 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: Freeman Robert - IL 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: Mercadante, Thomas F 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: RMAN backup - basic Qs
Also, RMAN can do incremental backups, copying only the blocks that changed since last backup. More about all this in Oracle Manuals and in Robert's book. - Kirti -Original Message- Sent: Thursday, January 16, 2003 10:04 PM To: Multiple recipients of list ORACLE-L Maria - Definitely faster. Often hot backups can generate additional redo. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 16, 2003 9:24 PM To: Multiple recipients of list ORACLE-L does this make RMAN hot backups faster or slower than when backing up file in backup mode? [EMAIL PROTECTED] wrote: To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the process of being backed up, with reads happening in chunks of say, 512 bytes. Assume a user transaction updates this block while the backup is in progress. This could result in an inconsistent version of the block being backed up, or what is called as split blocks. Putting a tablespace in backup mode, is primarily, a flag which tells Oracle to copy the entire block into the redo stream, and not just the changed vectors or deltas, which it would have done otherwise. This is so that, in case of recovery, the entire block can be read from the redo stream, and applied. Hence, this results in an increase in the redo size during normal hot backups. RMAN however, does not place the tablespaces in hot backup mode. They use the same read consistency mechanism used by the SQL statements. Hence, no excessive redo is generated. Hope this helps. Raj Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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: RMAN backup - basic Qs
No. Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is simply reading the blocks, compressing them, and writing them to tape. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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: Mercadante, Thomas F 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: RMAN backup - basic Qs
Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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).
RE: RMAN backup - basic Qs
RMAN does no compression on any blocks with data. The only compression that occurs that blocks above the HWM are not included. No compression of data occurs, and in fact empty blocks can and are backed up by RMAN. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L No. Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is simply reading the blocks, compressing them, and writing them to tape. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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: Mercadante, Thomas F 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: Freeman Robert - IL 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: RMAN backup - basic Qs
Title: RE: RMAN backup - basic Qs what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case? many i'm missing something. -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: RMAN backup - basic Qs Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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).
RE: RMAN backup - basic Qs
Maybe you could explain why you think ORA-1550 is related to backups? It isn't, but you have some misconception about it to clear up. Jared Chris Stephens [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/16/2003 01:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup - basic Qs what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case? many i'm missing something. -Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: RMAN backup - basic Qs
To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the process of being backed up, with reads happening in chunks of say, 512 bytes. Assume a user transaction updates this block while the backup is in progress. This could result in an inconsistent version of the block being backed up, or what is called as split blocks. Putting a tablespace in backup mode, is primarily, a flag which tells Oracle to copy the entire block into the redo stream, and not just the changed vectors or deltas, which it would have done otherwise. This is so that, in case of recovery, the entire block can be read from the redo stream, and applied. Hence, this results in an increase in the redo size during normal hot backups. RMAN however, does not place the tablespaces in hot backup mode. They use the same read consistency mechanism used by the SQL statements. Hence, no excessive redo is generated. Hope this helps. Raj Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: RMAN backup - basic Qs
does this make RMAN hot backups faster or slower than when backing up file in backup mode? [EMAIL PROTECTED] wrote: To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the process of being backed up, with reads happening in chunks of say, 512 bytes. Assume a user transaction updates this block while the backup is in progress. This could result in an inconsistent version of the block being backed up, or what is called as split blocks. Putting a tablespace in backup mode, is primarily, a flag which tells Oracle to copy the entire block into the redo stream, and not just the changed vectors or deltas, which it would have done otherwise. This is so that, in case of recovery, the entire block can be read from the redo stream, and applied. Hence, this results in an increase in the redo size during normal hot backups. RMAN however, does not place the tablespaces in hot backup mode. They use the same read consistency mechanism used by the SQL statements. Hence, no excessive redo is generated. Hope this helps. Raj Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. If you don't risk anything, you risk even more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega 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: RMAN backup - basic Qs
Maria - Definitely faster. Often hot backups can generate additional redo. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 16, 2003 9:24 PM To: Multiple recipients of list ORACLE-L does this make RMAN hot backups faster or slower than when backing up file in backup mode? [EMAIL PROTECTED] wrote: To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the process of being backed up, with reads happening in chunks of say, 512 bytes. Assume a user transaction updates this block while the backup is in progress. This could result in an inconsistent version of the block being backed up, or what is called as split blocks. Putting a tablespace in backup mode, is primarily, a flag which tells Oracle to copy the entire block into the redo stream, and not just the changed vectors or deltas, which it would have done otherwise. This is so that, in case of recovery, the entire block can be read from the redo stream, and applied. Hence, this results in an increase in the redo size during normal hot backups. RMAN however, does not place the tablespaces in hot backup mode. They use the same read consistency mechanism used by the SQL statements. Hence, no excessive redo is generated. Hope this helps. Raj Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. If you don't risk anything, you risk even more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega 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: DENNIS WILLIAMS 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: RMAN backup
And of course there is the obvious reason, a level 0 also backs up the controlfile. This is essential for point in tijme recovery. Ruth - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Saturday, November 16, 2002 1:23 PM Subject: Re: RMAN backup How about switching to incremental (from "full") backups? Even if all youdo are level-0 backups?My understanding of the difference between a "full" and a "level-0" backup(besides the obvious impact on any subsequent level-n incremental backups)is that level-0 backups only back up database blocks that are currently inuse, as opposed to "full" backups which back up all database blocks whichhave ever been used (i.e. no longer "unformatted").- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMANfull backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table whichwe were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. Iam considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Tim Gorman INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: RMAN backup
Joe - Which type of RMAN backup are you doing? If you are doing RMAN datafile backups, then the size of your datafiles matter. If you are using the RMAN backup command, you are creating RMAN backup pieces. RMAN backup pieces contain parts of several data files, and you can't control that. You can control the maximum size of each piece. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, November 16, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Joe Tim, It is accurate to state the both full and level 0 have the same impact on the database, and both backup all used blocks. It is also accurate that a full backup cannot be used as a piece of an incremental strategy. Although there may be rare instances (no pun intended :-) ) when you want to use a full backup (e.g. separate from your incremental flow) I never use full backups in RMAN myself. If you want to reduce the size of your backups: 1) Reduce the size of segments by reorging data (yes, I now this is stating the obvious) 2) Make any tablespaces containing static data read-only (thereby skipping them in RMAN after level 0) 3) Use an incremental strategy (level 0, 1...) Of course you must balance MTTR. If you just need to reduce disk space utilized, consider integrating RMAN with your backup vendor's software (Legato, Veritas...) so the backups go directly to tape. HTH, -Ron- Joe, nice to see you still contributing to this group. Hope all is well. -Ron- -Original Message- Sent: Saturday, November 16, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Tim, i'd be glad to hear someone else verify your statement as my understanding is the the only difference between full and level 0 is that full cannot be used as part of an incremental strategy, other than that they both back up the ever used blocks. Anyone else care to jump in on this one? joe Tim Gorman wrote: How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks that are currently in use, as opposed to full backups which back up all database blocks which have ever been used (i.e. no longer unformatted). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Joe Testa 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: Ron/Sarah Yount 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
Re: RMAN backup
How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks that are currently in use, as opposed to full backups which back up all database blocks which have ever been used (i.e. no longer unformatted). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Tim Gorman 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: RMAN backup
Tim, i'd be glad to hear someone else verify your statement as my understanding is the the only difference between full and level 0 is that full cannot be used as part of an incremental strategy, other than that they both back up the ever used blocks. Anyone else care to jump in on this one? joe Tim Gorman wrote: How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks that are currently in use, as opposed to full backups which back up all database blocks which have ever been used (i.e. no longer unformatted). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Joe Testa 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: RMAN backup
Joe Tim, It is accurate to state the both full and level 0 have the same impact on the database, and both backup all used blocks. It is also accurate that a full backup cannot be used as a piece of an incremental strategy. Although there may be rare instances (no pun intended :-) ) when you want to use a full backup (e.g. separate from your incremental flow) I never use full backups in RMAN myself. If you want to reduce the size of your backups: 1) Reduce the size of segments by reorging data (yes, I now this is stating the obvious) 2) Make any tablespaces containing static data read-only (thereby skipping them in RMAN after level 0) 3) Use an incremental strategy (level 0, 1...) Of course you must balance MTTR. If you just need to reduce disk space utilized, consider integrating RMAN with your backup vendor's software (Legato, Veritas...) so the backups go directly to tape. HTH, -Ron- Joe, nice to see you still contributing to this group. Hope all is well. -Ron- -Original Message- Sent: Saturday, November 16, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Tim, i'd be glad to hear someone else verify your statement as my understanding is the the only difference between full and level 0 is that full cannot be used as part of an incremental strategy, other than that they both back up the ever used blocks. Anyone else care to jump in on this one? joe Tim Gorman wrote: How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks that are currently in use, as opposed to full backups which back up all database blocks which have ever been used (i.e. no longer unformatted). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Joe Testa 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: Ron/Sarah Yount 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: RMAN backup to remote dir. - how ?
Use map network drive on your target machine and define the drive as a directory on your recovery machine. I mean: map drive K on the target machine as f:\backup on the recovery machine. Then backup to drive K. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 12:48 PM Guys, I have a target DB and a recovery catalog DB. both r on two diff. machines in two diff. network ; both on oracle 8.1.6/win2k. i have created the recovery catalog and registered the target database. i want to backup a datafile DF1 in the target database. when i say, RMAN run { allocate channel c1 type disk; copy datadile DF1 to 'f:\backup'; } f:\backup -- this is a directory on the recovery DB machine. I get the error below. RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03007: retryable error occurred during execution of command: copy RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19504: failed to create file F:\DF1.D AT.BAK ORA-27040: skgfrcre: create error, unable to create file OSD-04002: ¢¢¢ O/S-Error: (OS 3) ORA-19600: input file is datafile 9 (D:\ORACLE\DF1.DAT) ORA-19601: output file is datafile-copy 0 (F:\DF1.DAT.BAK) RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.COPYDATAFILE backup to local directory on target DB is okay. but can i backup to a remote machine on which my reco. DB resides ? if so , how do i do it ? kindly explaine me. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN backup to remote dir. - how ?
Well since you haven't gotten a reply from anyone else yet, I'll take a crack at it, but I don't use Oracle on Windows so I may be totally off base. I'm assuming that your f drive is a mapped drive to your catalog db server. I don't recall the details, but I believe that just because you have mapped a share that you can see, doesn't mean that Oracle can see the same mapped share. I think Oracle has fewer privileges than necessary to see the mapped drive. I don't recall the solution, but I'm pretty sure it was covered on MetaClunk. -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 6:48 AM Guys, I have a target DB and a recovery catalog DB. both r on two diff. machines in two diff. network ; both on oracle 8.1.6/win2k. i have created the recovery catalog and registered the target database. i want to backup a datafile DF1 in the target database. when i say, RMAN run { allocate channel c1 type disk; copy datadile DF1 to 'f:\backup'; } f:\backup -- this is a directory on the recovery DB machine. I get the error below. RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03007: retryable error occurred during execution of command: copy RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19504: failed to create file F:\DF1.D AT.BAK ORA-27040: skgfrcre: create error, unable to create file OSD-04002: ¢¢¢ O/S-Error: (OS 3) ORA-19600: input file is datafile 9 (D:\ORACLE\DF1.DAT) ORA-19601: output file is datafile-copy 0 (F:\DF1.DAT.BAK) RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.COPYDATAFILE backup to local directory on target DB is okay. but can i backup to a remote machine on which my reco. DB resides ? if so , how do i do it ? kindly explaine me. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN backup and restore Q?
Hi My problem went away when I did a startup mount of the database. I have Rman user in TEST2 just for testing purposes (same username password on target catalog is easier with ctrl C ctrl V) One more question if I may. Do you or anybody else have an example of a very complex rman command(most of the features used) and an example of cloning a database on the same host with renaming of the log datafiles? Documentation explains a lot but is very limited in the examples and the syntax errors are easy to make. TIA Jack Jay Hostetter [EMAIL PROTECTED]@fatcity.com on 16-01-2002 14:10:24 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) What version of the database are you using? My info here is based on 8.1.7. I connect to my databases as internal to do the backups. I fire up RMAN with either one of these commands: rman target / catalog rman/rman@test1 (SID must be set correctly) rman target internal/pwd@test2 catalog rman/rman@test1 I'm not sure why you have an rman user in test2, unless you set up a second catalog so that you can backup your first catalog. To test your restore, shutdown test2 and delete all the .dbf, .log, .arc, and .ctl files. Then startup nomount the test2 database. Then try this: rman target internal/pwd@test2 catalog rman/rman@test run { allocate channel ch1 type disk; restore controlfile; alter database mount; restore database; recover database; alter database open resetlogs; } If you did a hot backup, you may need your archivelog backups. This command backs up the archivelogs: run { allocate channel ch1 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t'; set limit channel ch1 kbytes=100; # Limit sets to 1 Gb. backup archivelog until time 'sysdate-1/24' delete input; backup archivelog from time 'sysdate-1/24'; } Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 01/16/02 07:25AM Hi All, I'm in the process of figuring out the workings of RMAN and created 2 test databases. TEST1 = catalog database TEST2 = target database I have created the catalogs and registered the database with the catalog. I than mad a full backup of the database TEST2 (is in Archivelog mode) with the following syntax **BACKUP rman EOF connect target rman/rman@test2 connect catalog rman/rman@test1 run { allocate channel d1 type disk; backup full format '/data/oracle/BACKUP/rman_%d_%t_%U.bus' database; } EOF * which created the database backup OK When I try the restore however I get ORA 19753 cannot obtain exclusive enqueue for datafile 1. RESTORE* rman EOF connect target rman/rman@test2 connect catalog rman/rman@test1 run { allocate channel d1 type disk; restore database; recover database; alter database open; } EOF ** Checking the database TEST2 showed a shared MR lock in the v$lock view on all tablespaces. What am I doing wrong here? TIA Jack === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: RMAN backup and restore Q?
Jack, What is the status of your target database? Try having it in startup mount status rather than startup open. The other thing you should do is to backup your control file (using Rman) with every database backup. I do this as my last step with every backup so that the latest changes within the control file are also saved. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 7:25 AM To: Multiple recipients of list ORACLE-L Hi All, I'm in the process of figuring out the workings of RMAN and created 2 test databases. TEST1 = catalog database TEST2 = target database I have created the catalogs and registered the database with the catalog. I than mad a full backup of the database TEST2 (is in Archivelog mode) with the following syntax **BACKUP rman EOF connect target rman/rman@test2 connect catalog rman/rman@test1 run { allocate channel d1 type disk; backup full format '/data/oracle/BACKUP/rman_%d_%t_%U.bus' database; } EOF * which created the database backup OK When I try the restore however I get ORA 19753 cannot obtain exclusive enqueue for datafile 1. RESTORE* rman EOF connect target rman/rman@test2 connect catalog rman/rman@test1 run { allocate channel d1 type disk; restore database; recover database; alter database open; } EOF ** Checking the database TEST2 showed a shared MR lock in the v$lock view on all tablespaces. What am I doing wrong here? TIA Jack === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN backup and restore Q?
What version of the database are you using? My info here is based on 8.1.7. I connect to my databases as internal to do the backups. I fire up RMAN with either one of these commands: rman target / catalog rman/rman@test1 (SID must be set correctly) rman target internal/pwd@test2 catalog rman/rman@test1 I'm not sure why you have an rman user in test2, unless you set up a second catalog so that you can backup your first catalog. To test your restore, shutdown test2 and delete all the .dbf, .log, .arc, and .ctl files. Then startup nomount the test2 database. Then try this: rman target internal/pwd@test2 catalog rman/rman@test run { allocate channel ch1 type disk; restore controlfile; alter database mount; restore database; recover database; alter database open resetlogs; } If you did a hot backup, you may need your archivelog backups. This command backs up the archivelogs: run { allocate channel ch1 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t'; set limit channel ch1 kbytes=100; # Limit sets to 1 Gb. backup archivelog until time 'sysdate-1/24' delete input; backup archivelog from time 'sysdate-1/24'; } Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 01/16/02 07:25AM Hi All, I'm in the process of figuring out the workings of RMAN and created 2 test databases. TEST1 = catalog database TEST2 = target database I have created the catalogs and registered the database with the catalog. I than mad a full backup of the database TEST2 (is in Archivelog mode) with the following syntax **BACKUP rman EOF connect target rman/rman@test2 connect catalog rman/rman@test1 run { allocate channel d1 type disk; backup full format '/data/oracle/BACKUP/rman_%d_%t_%U.bus' database; } EOF * which created the database backup OK When I try the restore however I get ORA 19753 cannot obtain exclusive enqueue for datafile 1. RESTORE* rman EOF connect target rman/rman@test2 connect catalog rman/rman@test1 run { allocate channel d1 type disk; restore database; recover database; alter database open; } EOF ** Checking the database TEST2 showed a shared MR lock in the v$lock view on all tablespaces. What am I doing wrong here? TIA Jack === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
Re: RMAN backup and restore Q?
This error occurs when you are trying recovery on an open database.the database should be in MOUNT mode for recovery. Sona - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 4:25 AM Hi All, I'm in the process of figuring out the workings of RMAN and created 2 test databases. TEST1 = catalog database TEST2 = target database I have created the catalogs and registered the database with the catalog. I than mad a full backup of the database TEST2 (is in Archivelog mode) with the following syntax **BACKUP rman EOF connect target rman/rman@test2 connect catalog rman/rman@test1 run { allocate channel d1 type disk; backup full format '/data/oracle/BACKUP/rman_%d_%t_%U.bus' database; } EOF * which created the database backup OK When I try the restore however I get ORA 19753 cannot obtain exclusive enqueue for datafile 1. RESTORE* rman EOF connect target rman/rman@test2 connect catalog rman/rman@test1 run { allocate channel d1 type disk; restore database; recover database; alter database open; } EOF ** Checking the database TEST2 showed a shared MR lock in the v$lock view on all tablespaces. What am I doing wrong here? TIA Jack === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN backup pieces
Thanks - that worked. Chris Mercadante, Thomas F wrote: Chris, here is one way - use the SETSIZE command 7 backup 8incremental level 0 9setsize 222 it will figure out how many database files to fit into the 2 gig limit above and create multiple pieces. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 05, 2001 4:51 PM To: Multiple recipients of list ORACLE-L How do you split a RMAN backupset into multiple pieces? I am using Standard Edition so I can't use multiple channels but I need to split the backup up because of a 2GB file size limit (I'm backing up files from a Solaris box to a Linux box). Chris Rezek Oracle DBA DotClick Digital Music Network http://www.dotclick.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN backup pieces
Chris, here is one way - use the SETSIZE command 7 backup 8incremental level 0 9setsize 222 it will figure out how many database files to fit into the 2 gig limit above and create multiple pieces. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 05, 2001 4:51 PM To: Multiple recipients of list ORACLE-L How do you split a RMAN backupset into multiple pieces? I am using Standard Edition so I can't use multiple channels but I need to split the backup up because of a 2GB file size limit (I'm backing up files from a Solaris box to a Linux box). Chris Rezek Oracle DBA DotClick Digital Music Network http://www.dotclick.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Backup Size
Rman backs up only used blocks, so the size difference Johnson --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Backup Size
Hi, It's all O.K., blocks that never been used aren't backuped by rman. oli [EMAIL PROTECTED] wrote DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Backup Size
I believe that RMAN only backs up blocks that have been allocated to an oracle object - index, segment, table, etc. If the block is in a datafile but not in use by an oracle object (that is, the block is free), then RMAN doesn't backup those blocks. Steve [EMAIL PROTECTED] 04/30/01 12:25PM DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Baucum INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Backup and Recovery
Don, You don't state whether or not you're getting the archived redo logs at each Level 0 and 1 backup as well as the 3 archive-logs-only backups. If not, you probably should. Also, if recovery speed will be important, those incremental backups should be cumulative, not differential. However, cumulative takes more storage than differential - always the tradeoffs! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Donald Bricker Sent: Tuesday, March 20, 2001 3:31 PM To: Multiple recipients of list ORACLE-L We are in the midst of starting to use RMAN for our Backup and Recovery. The backups I have put into place are Once a week a Level 0 full backup, three times a week Level 1 incremental and three times archive logs only. Can anyone suggest some different recovery scenarios to test? Or if I missed any backups. Thanks Don Bricker Information Systems Analyst Illinois Environmental Protection Agency 1021 North Grand Avenue East Mail Code #32 Springfield, IL 62794-9276 [EMAIL PROTECTED] (217) 558-2290 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Backup and Recovery
Hi, In one of our production site, I implemented RMAN backup and recovery scripts. I did the following way. Take a full backup using RMAN, the following things will be backed up datafiles,Archive logs files, controlfile. I didn't use the catalog database. I used the database's controlfile instead. After this for next 6 days take incremental backup ie archivelog files and control files. Once in a week(lets us say Sunday) we are taking a full Database online backup. From Monday to Sunday incremental backup. Let us assume that my db crashes on thursday. I restore the full database backup from Sunday and start applying the incremental backup till wed and the rest of logs that are generated(provided they are there) then my I can bring the database upto the point where it had crashed. This particular method was tested and it is successfully running in the production site. The DBA now in the production site has managed to take the incremental backup twice a day(early morning and late evening) he schedules them copies the files from the disk to tapes and keeps them. Recovery depends what type of failure u face. In this db controlfiles,redolog files are mirrored from OS. The load is easily distributed.It has four HDD controllers with a combination of RAID 0 and RAID 1, with MSCS in WinNT. RMAN saves time and disk space. If we use the traditional Oracle backup utility(ALter tablespace tbl begin backup) we need the exact space that is occupied for Datafile. If we integrate with Media Management software with RMAN, then u can directly write into tapes. -- On Wed, 21 Mar 2001 07:22:01 Jack C. Applewhite wrote: Don, You don't state whether or not you're getting the archived redo logs at each Level 0 and 1 backup as well as the 3 archive-logs-only backups. If not, you probably should. Also, if recovery speed will be important, those incremental backups should be cumulative, not differential. However, cumulative takes more storage than differential - always the tradeoffs! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Donald Bricker Sent: Tuesday, March 20, 2001 3:31 PM To: Multiple recipients of list ORACLE-L We are in the midst of starting to use RMAN for our Backup and Recovery. The backups I have put into place are Once a week a Level 0 full backup, three times a week Level 1 incremental and three times archive logs only. Can anyone suggest some different recovery scenarios to test? Or if I missed any backups. Thanks Don Bricker Information Systems Analyst Illinois Environmental Protection Agency 1021 North Grand Avenue East Mail Code #32 Springfield, IL 62794-9276 [EMAIL PROTECTED] (217) 558-2290 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).