RE: rman problem with nfs permission.

This is one of the reasons you try to have uniform gid/uid across your fleet to not have perm problems in restoring. You can change the gid/uid of the files on your mount to match the server you are trying to retore to. After restore change them back so they will work with original server.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of pier paolo Bruno Sent: Friday, March 31, 2023 12:22 PM
To: gogala.mladen_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: rman problem with nfs permission.

Already done, as i put in the mail :

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.

And i also tried setting event 10298 trace name context forever, level 32 at session and at system level .
Thanks .

Il giorno ven 31 mar 2023 alle ore 21:15 Mladen Gogala <gogala.mladen_at_gmail.com> ha scritto:
>
> 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



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