Re: Friday Humor - RMAN

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 28 Jun 2003 03:39:33 -0700
Message-ID: <F001.005BBA68.20030628032448@fatcity.com>

Methinks the backup won't fail but the datafile would certainly be ovewritten !

The DBWR verifies the file header before writing in a dirty block to the file and should fail writes to the file once the backup to the file has begun -- so the DBWR should error out ! ---- or am I wrong and would DBWR not be aware of it
and both DBWR and RMAN would be writing to the file so both the datafile and the backup in the datafile would be useless ?

Hemant

At 03:10 PM 27-06-03 -0800, you wrote:

Excerpt from the 9i RMAN Guide :

"If you specify DEVICE TYPE DISK, then you must back up to random access disks. You can make a backup on any device that can store an Oracle datafile: in other words, if the statement CREATE TABLESPACE tablespace_name DATAFILE 'filename' works, then 'filename' is also a valid backup path name."
LOL. What if someone were to take this literally? What would happen if you specified a datafile as the RMAN backup destination? Would your datafile get overwritten, and subsequently, your backup fail coz it cannot read from the datafile? :-)))))
Raj

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

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). Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hemant K Chitale
 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). Received on Sat Jun 28 2003 - 05:39:33 CDT