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 15:35:20 -0400
Message-Id: <25998.339236@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.

--=_C49AE86E.8DEC2300
Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit

Thanks for the clarification. You got me nervous :)

>>> wisernet100_at_yahoo.com 07/23/03 04:09PM >>>
that's not quite what I said.

I said Oracle will not support hot backups done without putting the tablespace into "backup mode" unless that hot backup is done with RMAN. at least that's what I thought I was saying.

you can still do the good old-fashioned "alter tablespace begin backup"/backup the datafiles/"alter tablespace end backup" sort of hot
backup

or you can use RMAN and not have to do the begin/end backup


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

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

Original text of this message

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