Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: incremental rman backup using image copy

Re: incremental rman backup using image copy

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Sat, 24 Mar 2007 11:07:13 +0300
Message-ID: <97b7fd2f0703240107p5ebd09calea7fe9979f2d697f@mail.gmail.com>


>>

I read some documentation and did limited testing but sounds like we still can't backup the datafiles as it is. RMAN backups the datafile using it's own naming convention(format command) e.g. datafile users_01.dbf can not be backed up as users_01.dbf in backup destination. >> If you are not using FRA (Flash Recovery Area), it is very well possible to have the same name using the format with BACKUP AS .

BACKUP AS COPY DATAFILE 'user01.dbf' FORMAT 'user01.dbf';

Anil, just a though, why dont the client wants to have backupsets rather than image copies? I know that Oracle first perfers to the image copies compare to incremental or backupsets.

But, you know, image copy is just a block to block copy, no compression. It would take good considerable time to finish the backup.

10g RMAN has very rich features, like BTC, binary compression and etc.

Jaffar

On 3/20/07, Anil Goel <agoel01_at_hotmail.com> wrote:
>
> I am no expert on RMAN, so, I thought I post it here to get some possible
> solution for a client of mine.
>
> Currently, they are taking "image copy' of rman backups for 9i/10g
> databases, they are not using rman catalog. As RMAN 9i did not allow image
> copy, they wrote custom code to generate statement like below for "rman" to
> execute for all datafiles within a database:
>
> COPY DATAFILE '/opt/oradata/test10g/users_01.dbf' TO
> '/rman/test10g/users_01.dbf';
>
> That's how they accomplished rman 9i "image copy". They want to continue
> the same path on rman 10g but want to get rid of custom code as 10g now
> allows "image copy". I read some documentation and did limited testing but
> sounds like we still can't backup the datafiles as it is. RMAN backups the
> datafile using it's own naming convention(format command) e.g. datafile
> users_01.dbf can not be backed up as users_01.dbf in backup destination.
>
> Is there a way to do that and also would incremental backup be
> possible using the same approach.
>
> I will appreciate any response.
>
> Thanks,
>
> Anil Goel.
>
> ------------------------------
> Get a FREE Web site, company branded e-mail and more from Microsoft Office
> Live! <http://g.msn.com/8HMAENUS/2740??PS=47575> --
> http://www.freelists.org/webpage/oracle-l

-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Mar 24 2007 - 03:07:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US