Re: rman problem with nfs permission.

On 3/31/23 13:05, pier paolo Bruno wrote:
> I have to duplicate an ora10g database from one machine to another one .
> I have host A, on which i do a backup rman to disk ( it is a rubric
> nfs appliance ) .
> On host A, uid and gid of oracle user are 205 and 204 .
> I have to restore it on an host B in which oracle user has uid/gid 203/202 .
> I put a chmod 777 on the backup script so that from host B i see
> backuppiece mounted like this :
> -rwxrwxrwx 1 205 204 93749248 Mar 31 18:15 ctl-j21oel54_1_1
> and in theory i could read backuppiece from rubrik mount .
> If i mount the nfs backup to host B and if i try to restore, i have a problem .
> if i copy the backuppiece of a controlfile from nfs rubrik mount
> point with user oracle , on a local filesystem and i launch restore
> it works, instead if i launch the restore of a controlfile directly
> from the rubrik mount points i have the error
> RMAN-06172: no autobackup found or specified handle is not a valid
> copy or piece.
> I have already tried to use :
> sql "alter system set events=''10298 trace name context forever, level 32''" ;
> and mount option
> cio,rw,bg,hard,nointr,rsize=32768,
> wsize=32768,proto=tcp,noac,
> vers=3,timeo=600
> as in support note Doc ID 359515.1.
>
> On local filesystem i tried to restore a controlfile , changing the
> ownership and leaving the ownership as the source system, and it works
> with no errors in any case
> -rw-r--r-- 1 ora10g dba 93749248 Mar 31 18:02 ctl-ih1oej5q_1_1
> -rwxrwxrwx 1 205 204 93749248 Mar 31 18:15 ctl-j21oel54_1_1
> but when i try to read the controlfile from nfs , it finish with RMAN-06172.
>
Hi Paolo,

Your NFS mount options are likely wrong. I recommend the following document:

Mount Options for Oracle files for RAC databases and Clusterware when used with NFS on NAS devices (Doc ID 359515.1)

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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