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
- Gene Sais <Gsais_at_co.palm-beach.fl.us> wrote:
> 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.
>
>
> --- Michael Kline <mkline1_at_comcast.net> wrote:
> > I found no signs of RMAN being used in
> > any way shape or form...
> >
> > I've been told they are doing "hot" backups
> > using Veritas... HOWEVER, the alert log shows
> > no signs what so ever of "alter tablespace
> > xyz begin/end backup"...
> >
> > Can it do a good backup backing up live
> > DB files and leaving no signs what so
> > ever that backup took place.
> >
> > Is Veritas capable of this?
> >
> > If so, why is there a Veritas interface
> > to RMAN???
> >
> > Confusion, confusion...
> >
> >
> > Michael Alan Kline, Sr.
> > Principal Consultant
> > Business to Business Solutions, LLC
> > Phone: 804-744-1545 Cell: 804-314-6262
> > ICQ: 1009605, 975313
> > Email: mkline_at_b2bsol.com Web: www.b2bsol.com
> >
> >
>
>
> __________________________________
> 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).
Received on Wed Jul 23 2003 - 14:12:45 CDT