You are lucky to have all your databases in archivelog mode. We have large
datawarehouses here, where business is quite acceptable to a recovery from
a cold backup taken 3 months earlier. RMAN is goooooood, but waiting for
Oracle to come out with an object point in time recovery, before we can
completely do away with exports. Not that it cannot be done using RMAN, but
with limited resources at our disposal, a logical backup and restore is
much easier. Having said that, we use RMAN for 90% of our databases, and HP
omniback as the media manager.
Raj
"Mercadante,
Thomas F" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
ate.ny.us> Subject: RE: Backups
Sent by:
[EMAIL PROTECTED]
October 03, 2002
04:17 PM
Please respond
to ORACLE-L
I haven't done nor recommended a cold backup in 3 years since I've been
using Rman. Just not needed anymore.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Thursday, October 03, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L
I still prefer cold backups when performing full OS backups.
>>> [EMAIL PROTECTED] 10/03/02 02:28PM >>>
Lest we not forget the archivelogs also during this backup procedure.
Ron
>>> [EMAIL PROTECTED] 10/03/02 01:53PM >>>
I forgot about alter tablespace begin backup; etc. I am spoiled, I use
rman
to do online backups. No problem with recovery!
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 12:18 PM
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 -- Maili
ng 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).
--
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: 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: Gene Sais
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: 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.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).
