Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Veritas like RMAN?

RE: Veritas like RMAN?

From: Gene Sais <Gsais_at_co.palm-beach.fl.us>
Date: Wed, 23 Jul 2003 14:35:49 -0400
Message-Id: <25998.339220@fatcity.com>


This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages.

--=_1E403282.B9D81732
Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit

Rachel - I am confused, now mind you it doesn't take much :). Can you clarify on a statement you made? Oracle will not support hot backups unless done w/ RMAD? I currently do hot backups w/ scripts using IBM's flashcopy. Is the Oracle Tablespace hot backup mode no longer supported? Thanks,
Gene

>>> DWILLIAMS_at_LIFETOUCH.COM 07/23/03 03:04PM >>> Michael

   But you do have a good reason why the client should hire you. ;-)

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, July 23, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L

I was afraid of that....



Performing Remote Agent backup

Media Name: "Media created 7/18/2003 08:00:06 PM" Backup of "\\FAILSAFE\V$ "
Backup set #11 on storage media #1
Backup set description: "DailyBackup"
Backup Type: FULL - Back Up Files - Reset Archive Bit Backup started on 7/19/2003 at 12:59:44 AM.

Backup completed on 7/19/2003 at 1:11:05 AM. Backed up 31 files in 4 directories.
Processed 5,785,060,909 bytes in 11 minutes and 21 seconds. Throughput rate: 486.1 MB/min


This doesn't give me a "warm" feeling. Alert log shows NOTHING.

This is a manufacturing site where the click of a bar code reader is moving materials from one location to another and that may or may not occur at any time. I'm not positive that one could say that this would never happen. Every time I've been in there looking around random jobs are coming into dbms_jobs in what appears to be all hours of the night.

They have an export, but I think that's it. If they take a backup on Sunday, I think everything is shutdown. It MIGHT be good if the moon is right.

Maks.

-----Original Message-----
Rachel Carmichael
Sent: Wednesday, July 23, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L

you don't have backups. Oracle will only support recovery from hot backups taken when the tablespaces are not flagged as in backup mode if
you do the backup via RMAN.

Technically, if you are very very lucky, the moon is in the seventh house and Jupiter has aligned with Mars, you *MIGHT* be able to use the
hot backup taken without RMAN. If and only if there is absolutely NO activity whatsoever in the database from the time the backup starts until when it finishes. Even then, recovery is still not supported.


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com 

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: ListGuru_at_fatcity.com (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: Michael Kline
  INET: mkline1_at_comcast.net 

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM 

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: ListGuru_at_fatcity.com (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).


--=_1E403282.B9D81732
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px">
<DIV>Rachel&nbsp; - I am confused, now mind you it doesn't take much 
:).&nbsp;Can you clarify on a statement you made?&nbsp; Oracle will not support 
hot backups unless done w/ RMAD?&nbsp; I currently do hot backups w/ scripts 
using IBM's flashcopy.&nbsp; Is the Oracle Tablespace hot backup mode no longer 
supported?&nbsp; Thanks,<BR>Gene</DIV>
<DIV><BR>&gt;&gt;&gt; DWILLIAMS_at_LIFETOUCH.COM 07/23/03 03:04PM 
&gt;&gt;&gt;<BR>Michael<BR>&nbsp;&nbsp; But you do have a good reason why the 
client should hire you. ;-)<BR><BR>Dennis Williams<BR>DBA, 80%OCP, 100% 
DBA<BR>Lifetouch, Inc.<BR>dwilliams_at_lifetouch.com <BR><BR><BR>-----Original 
Message-----<BR>Sent: Wednesday, July 23, 2003 12:39 PM<BR>To: Multiple 
recipients of list ORACLE-L<BR><BR><BR>I was afraid of 
that....<BR><BR>----------------------------------------------------------------------<BR>Performing 
Remote Agent backup<BR><BR>Media Name: "Media created 7/18/2003 08:00:06 
PM"<BR>Backup of "\\FAILSAFE\V$ "<BR>Backup set #11 on storage media 
#1<BR>Backup set description: "DailyBackup"<BR>Backup Type: FULL - Back Up Files 
- Reset Archive Bit<BR>Backup started on 7/19/2003 at 12:59:44 AM.<BR><BR>Backup 
completed on 7/19/2003 at 1:11:05 AM.<BR>Backed up 31 files in 4 
directories.<BR>Processed 5,785,060,909 bytes in&nbsp; 11 minutes and&nbsp; 21 
seconds.<BR>Throughput rate: 486.1 
MB/min<BR>----------------------------------------------------------------------<BR><BR>This 
doesn't give me a "warm" feeling. Alert log shows NOTHING.<BR><BR>This is a 
manufacturing site where the click of a bar code<BR>reader is moving materials 
from one location to another and<BR>that may or may not occur at any time. I'm 
not positive that<BR>one could say that this would never happen. Every time 
I've<BR>been in there looking around random jobs are coming into<BR>dbms_jobs in 
what appears to be all hours of the night.<BR><BR>They have an export, but I 
think that's it. If they take<BR>a backup on Sunday, I think everything is 
shutdown. It<BR>MIGHT be good if the moon is 
right.<BR><BR>Maks.<BR><BR>-----Original Message-----<BR>Rachel 
Carmichael<BR>Sent: Wednesday, July 23, 2003 12:59 PM<BR>To: Multiple recipients 
of list ORACLE-L<BR><BR><BR>you don't have backups. Oracle will only support 
recovery from hot<BR>backups taken when the tablespaces are not flagged as in 
backup mode if<BR>you do the backup via RMAN.<BR><BR>Technically, if you are 
very very lucky, the moon is in the seventh<BR>house and Jupiter has aligned 
with Mars, you *MIGHT* be able to use the<BR>hot backup taken without RMAN. If 
and only if there is absolutely NO<BR>activity whatsoever in the database from 
the time the backup starts<BR>until when it finishes. Even then, recovery is 
still not supported.<BR><BR><BR>--- Michael Kline &lt;mkline1_at_comcast.net&gt; 
wrote:<BR>&gt; I found no signs of RMAN being used in<BR>&gt; any way shape or 
form...<BR>&gt; <BR>&gt; I've been told they are doing "hot" backups<BR>&gt; 
using Veritas... HOWEVER, the alert log shows<BR>&gt; no signs what so ever of 
"alter tablespace<BR>&gt; xyz begin/end backup"... <BR>&gt; <BR>&gt; Can it do a 
good backup backing up live<BR>&gt; DB files and leaving no signs what 
so<BR>&gt; ever that backup took place.<BR>&gt; <BR>&gt; Is Veritas capable of 
this? <BR>&gt; <BR>&gt; If so, why is there a Veritas interface<BR>&gt; to 
RMAN???<BR>&gt; <BR>&gt; Confusion, confusion...<BR>&gt; <BR>&gt; <BR>&gt; 
Michael Alan Kline, Sr.<BR>&gt; Principal Consultant<BR>&gt; Business to 
Business Solutions, LLC<BR>&gt; Phone: 804-744-1545&nbsp; Cell: 
804-314-6262<BR>&gt; ICQ: 1009605, 975313<BR>&gt; Email: mkline_at_b2bsol.com Web: 
<A href="http://www.b2bsol.com/">www.b2bsol.com</A><BR>&gt; <BR>&gt; 
<BR><BR><BR>__________________________________<BR>Do you Yahoo!?<BR>Yahoo! 
SiteBuilder - Free, easy-to-use web site design software<BR><A 
href="http://sitebuilder.yahoo.com/">http://sitebuilder.yahoo.com</A><BR>-- 
<BR>Please see the official ORACLE-L FAQ: <A 
href="http://www.orafaq.net/">http://www.orafaq.net</A><BR>-- <BR>Author: Rachel 
Carmichael<BR>&nbsp; INET: wisernet100_at_yahoo.com<BR><BR>Fat City Network 
Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A 
href="http://www.fatcity.com/">http://www.fatcity.com</A><BR>San Diego, 
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and web 
hosting 
services<BR>---------------------------------------------------------------------<BR>To 
REMOVE yourself from this mailing list, send an E-Mail message<BR>to: 
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message 
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list 
you want to be removed from).&nbsp; You may<BR>also send the HELP command for 
other information (like subscribing).<BR>-- <BR>Please see the official ORACLE-L 
FAQ: http://www.orafaq.net<BR>-- 
<BR>Author: Michael Kline<BR>&nbsp; INET: mkline1_at_comcast.net<BR><BR>Fat City 
Network Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A 
href="http://www.fatcity.com/">http://www.fatcity.com</A><BR>San Diego, 
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and web 
hosting 
services<BR>---------------------------------------------------------------------<BR>To 
REMOVE yourself from this mailing list, send an E-Mail message<BR>to: 
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message 
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list 
you want to be removed from).&nbsp; You may<BR>also send the HELP command for 
other information (like subscribing).<BR>-- <BR>Please see the official ORACLE-L 
FAQ: http://www.orafaq.net<BR>-- 
<BR>Author: DENNIS WILLIAMS<BR>&nbsp; INET: DWILLIAMS_at_LIFETOUCH.COM<BR><BR>Fat 
City Network Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A 
href="http://www.fatcity.com/">http://www.fatcity.com</A><BR>San Diego, 
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and web 
hosting 
services<BR>---------------------------------------------------------------------<BR>To 
REMOVE yourself from this mailing list, send an E-Mail message<BR>to: 
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message 
Received on Wed Jul 23 2003 - 13:35:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US