You must be using an old version. Been there done that. Works!
Ron
PS: Also works on NT!
-----Original Message-----
Sent: Thursday, October 03, 2002 4:11 PM
To: Multiple recipients of list ORACLE-L
Unless:
You do a point in time recovery, find out you were
given the wrong time, and try to do it again.
Not so simple, can't be done from the SQL*Bactrack menu.
Jared
"Smith, Ron L." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/03/2002 01:26 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: RE: RE: Backups
SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be
simpler.
R. Smith
-----Original Message-----
Sent: Thursday, October 03, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Richard,
Distateful is being nice. Try down right horrifying is a more
appriopriate
description. Been There, Done that, now have three Unix SA's who handle
it.
Life is so grand!!
Dick Goulet
____________________Reply Separator____________________
Author: "Markham; Richard" <[EMAIL PROTECTED]>
Date: 10/3/2002 10:53 AM
Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber
SAN has its added benefits as well =). I have never really explored the
implications of these other utilities. My head filled with many
distasteful visuals. Yes, I agree with you and I realize that I am
spoiled <knocking on wood>.
-----Original Message-----
Sent: Thursday, October 03, 2002 1:38 PM
To: Markham; Richard; Multiple recipients of list ORACLE-L
I've used cpio, dd, and fbackup to do hot and cold backups before, but
never
again. With those utilities the burden of keeping track of what is on
which
tape rests with you and normally a stubby pencil & pad of paper because
you
know
what won't be available when you need to do a recovery. They do work be
assured, but the administrative overhead is just not worth it anymore,
even
for
a small shop. Get a copy of Veritas or OmniBack or some other software
package
that does library management for you and preferably integrates with RMAN.
Life
can be so much easier!!
Dick Goulet
____________________Reply Separator____________________
Author: "Markham; Richard" <[EMAIL PROTECTED]>
Date: 10/3/2002 10:03 AM
It would be interesting to see how you would explain how either
cp or dd (which know nothing of archive log mode, or the concept
of hot backup, itself, none the less) is going to keep things
consistent, when these utilities themselves are for point in
time operations.
-----Original Message-----
Sent: Thursday, October 03, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
This doesn't sound right. Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode. Why wouldn't you be able to recover?
John P Weatherman
Database Administrator
Replacements Ltd.
-----Original Message-----
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L
If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup. If it is not, you won't
be
able to recover.
Just a thot,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 9:08 AM
Robyn,
We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
ROR mª¿ªm
>>> [EMAIL PROTECTED] 10/02/02 08:08PM >>>
Hello,
I need some info about backups. I am working on a customer site, and
have implemented both exports and hot backups. Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.
Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals. The file
system is built on a 12 disk A1000 array. We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape? Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.
Robyn
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
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 Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: Backups</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>It would be interesting to see how you would explain how
either</FONT>
<BR><FONT SIZE=2>cp or dd (which know nothing of archive log mode, or the
concept</FONT>
<BR><FONT SIZE=2>of hot backup, itself, none the less) is going to keep
things</FONT>
<BR><FONT SIZE=2>consistent, when these utilities themselves are for point
in
</FONT>
<BR><FONT SIZE=2>time operations.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: John Weatherman [<A
HREF="mailto:[EMAIL PROTECTED]";>mailto:john.weatherman@replac
emen
ts.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, October 03, 2002 12:18 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: Backups</FONT>
</P>
<BR>
<P><FONT SIZE=2>This doesn't sound right. Put the database in hot
backup
mode,</FONT>
<BR><FONT SIZE=2>backup (whether using cp to a staging point like the
poster
here</FONT>
<BR><FONT SIZE=2>is doing or straight to tape using dd or dump or some
other
utility),</FONT>
<BR><FONT SIZE=2>come out of hot backup mode. Why wouldn't you be
able
to
recover? </FONT>
</P>
<P><FONT SIZE=2>John P Weatherman</FONT>
<BR><FONT SIZE=2>Database Administrator</FONT>
<BR><FONT SIZE=2>Replacements Ltd.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>Sent: Thursday, October 03, 2002 10:18 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<P><FONT SIZE=2>If you want to be able to use any OS backup for
restore/recovery
that</FONT>
<BR><FONT SIZE=2>database must be closed when you do the backup. If
it
is
not, you won't be</FONT>
<BR><FONT SIZE=2>able to recover.</FONT>
</P>
<P><FONT SIZE=2>Just a thot,</FONT>
<BR><FONT SIZE=2>Ruth</FONT>
</P>
<P><FONT SIZE=2>----- Original Message -----</FONT>
<BR><FONT SIZE=2>To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]></FONT>
<BR><FONT SIZE=2>Sent: Thursday, October 03, 2002 9:08 AM</FONT>
</P>
<BR>
<P><FONT SIZE=2>Robyn,</FONT>
<BR><FONT SIZE=2> We used the DD method on pre 7.1 oracle with RAW
devices.
It worked</FONT>
<BR><FONT SIZE=2>fine except that it used a lot of tape dumping a
raw
device when only a</FONT>
<BR><FONT SIZE=2>small portion was used. Using a dd command to place a
copy
of
the data</FONT>
<BR><FONT SIZE=2>on tape should not be a problem if a restoral is needed.
The dd
function</FONT>
<BR><FONT SIZE=2>is just another OS method of copying data to a tape. I
don't
know for</FONT>
<BR><FONT SIZE=2>sure but I think there might be some issues about
transportability of</FONT>
<BR><FONT SIZE=2>the dd tape.</FONT>
<BR><FONT SIZE=2>Other users will know about the transportability
issues.</FONT>
<BR><FONT SIZE=2>Ron</FONT>
<BR><FONT SIZE=2> ROR mª¿ªm</FONT>
</P>
<P><FONT SIZE=2>>>> [EMAIL PROTECTED] 10/02/02 08:08PM
>>></FONT>
<BR><FONT SIZE=2>Hello,</FONT>
</P>
<P><FONT SIZE=2>I need some info about backups. I am working on a
customer
site, and</FONT>
<BR><FONT SIZE=2>have implemented both exports and hot backups. Both
jobs
copy to a</FONT>
<BR><FONT SIZE=2>separate mount point, and a job scripted by another
individual
then</FONT>
<BR><FONT SIZE=2>moves the files to tape.</FONT>
</P>
<P><FONT SIZE=2>Here's the problem - he's using a dd command, primarily
because
it</FONT>
<BR><FONT SIZE=2>provides a succinct output he can email to
non-technicals. The file</FONT>
<BR><FONT SIZE=2>system is built on a 12 disk A1000 array. We've
provided
him with a</FONT>
<BR><FONT SIZE=2>ufsdump script, but he's doesn't want to use it. Can the
system
be</FONT>
<BR><FONT SIZE=2>recovered from this tape? Has anyone ever relied on
a
dd
for a daily</FONT>
<BR><FONT SIZE=2>backup method? The system is Oracle 9i on Solaris
8.</FONT>
</P>
<P><FONT SIZE=2>Robyn</FONT>
</P>
<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com";
TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Author: Robyn Anderson Sands</FONT>
<BR><FONT SIZE=2> INET: [EMAIL PROTECTED]</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services --
858-538-5051
<A
HREF="http://www.fatcity.com";
TARGET="_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=2>San Diego,
California
-- Mailing list and web hosting services</FONT>
<BR><FONT
SIZE=2>---------------------------------------------------------------------
</FO
NT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru')
and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed
from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like
subscribing).</FONT>
<BR><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com";
TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Author: Ron Rogers</FONT>
<BR><FONT SIZE=2> INET: [EMAIL PROTECTED]</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services --
858-538-5051
<A
HREF="http://www.fatcity.com";
TARGET="_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=2>San Diego,
California
-- Mailing list and web hosting services</FONT>
<BR><FONT
SIZE=2>---------------------------------------------------------------------
</FO
NT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru')
and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed
from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like
subscribing).</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com";
TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Ruth Gramolini</FONT>
<BR><FONT SIZE=2> INET: [EMAIL PROTECTED]</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services --
858-538-5051
<A
HREF="http://www.fatcity.com";
TARGET="_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=2>San Diego,
California
-- Mailing list and web hosting services</FONT>
<BR><FONT
SIZE=2>---------------------------------------------------------------------
</FO
NT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru')
and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed
from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like
subscribing).</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com";
TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: John Weatherman</FONT>
<BR><FONT SIZE=2> INET: [EMAIL PROTECTED]</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services --
858-538-5051
<A
HREF="http://www.fatcity.com";
TARGET="_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=2>San Diego,
California
-- Mailing list and web hosting services</FONT>
<BR><FONT
SIZE=2>---------------------------------------------------------------------
</FO
NT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru')
and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed
from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like
subscribing).</FONT>
</P>
</BODY>
</HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
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:
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: Smith, Ron L.
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).
