RE: REPOST: RMAN Image Copies
- From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
- To: 'DENNIS WILLIAMS ' <DWILLIAMS@xxxxxxxxxxxxx>, "'oracle-l-bounce@xxxxxxxxxxxxx '" <oracle-l-bounce@xxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Sep 2004 10:32:00 -0500
Dennis,
Comments inline below. Sorry to not respond quicker... I'm knee deep in a
book right now (Portable DBA: Oracle) and just don't seem to have time for
anything right now...
Robert
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Sent: 9/2/2004 7:20 AM
Subject: REPOST: RMAN Image Copies
I posted the following a few days ago, but perhaps it was buried in the
concern over Jared's announcement. I can't believe nobody on this list
has
tried image copies. I had previously ignored them, but a closer look
reveals
some interesting capabilities.
Jared - thank you so much for your years of faithful service. Now
your
posts won't be inhibited by your responsibilities.
Steve - welcome and best wishes.
Dennis Williams
DBA
Lifetouch, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of DENNIS WILLIAMS
Sent: Monday, August 30, 2004 2:39 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN Image Copies
>> List - Has anyone worked a significant amount with RMAN Image copies?
>> Or,better yet, compared image copies to RMAN backup sets?
>> One requirement is the ability to schedule cold backups, especially if
>> where is any reluctance to trust RMAN. It seems that an image copy
>> fits requirement. From what I see, you could recover the database from
>> image copies just as if they were created by copying the files (not
>> use RMAN), and I can use this to fulfill the cold backup requirement.
>> Has anyone tried this?
yes, this works. You can actually take the physicla files of an image copy
and move it physically (not via RMAN), rename it to the name of the
associated data file and perform a manual recovery with that backup.
>> Freeman states that datafile (image) copies are registered in the RMAN
>> catalog. Will reports like REPORT UNRECOVERABLE take datafile copies in
>> mind?
It's been so long since I've done anything with image copies that I honestly
don't recall if a image copy counts on the unrecoverable report or not. I'm
about 99.99% sure that it does count, but I'd need to test that.
>> Then he notes that RMAN may use a datafile copy to restore a datafile
>> if it is more recent. Has anyone tried this?
Well, I have... :-)
>> Has anyone chosen to use Image copies in preference to backup sets?
Not me... You loose some of the RMAN benefits such as compression.
RF
---
To unsubscribe -
mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
