Re: RAC/ASM environment, RMAN Clone error

2008/12/12 Li Li <litanli_at_gmail.com>

> Hi, List,
>
> I am running into an error when trying to clone a database with RMAN.
> The error message is the following. Error seems to be a permission
> issue but actually it shouldn't because RMAN finished restoring and
> recovering the datafiles successfully, it fails only when it tries to
> re-create the online logs. Has anybody seen this before? Any help
> would be greatly appreciated!
>
> Oracle 10.2.0.3 on Linux x-64, Cloning from a 2-node RAC db to a 5-node RAC
> db.
>
> Thanks,
> -Li
>
> contents of Memory Script:
> {
> Alter clone database open resetlogs;
> }
> executing Memory Script
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of Duplicate Db command at 12/11/2008 23:36:42
> RMAN-03015: error occurred in stored script Memory Script
> RMAN-06136: ORACLE error from auxiliary database: ORA-00344: unable to
> re-create online log '/+FSFLASH/prdfs90/online
> log/group_1.387.672580653'
> ORA-27040: file create error, unable to create file
> Linux-x86_64 Error: 2: No such file or directory
> --
> http://www.freelists.org/webpage/oracle-l
>

rman is trying to create the redo files in the /+FLASH.... directory that surely doesn't exist. As Joe pointed, if you plan to have your redos in filesystem, add the conversion name in the standby instance parameter file. If you wanna have the same environment, be sure to have an ASM instance in the standby host with the +FSFLASH disc group created, or use again the convert parameter to point to a valid ASM disk group

log file name convert

http://www.lsbu.ac.uk/oracle/oracle9i/server.920/a96536/ch1104.htm#1019215

and for datafiles

http://www.lsbu.ac.uk/oracle/oracle9i/server.920/a96536/ch144.htm

D.

--
http://www.freelists.org/webpage/oracle-l