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@xxxxxxxxxxx> 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> -- //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."