rman problem with nfs permission.
From: pier paolo Bruno <pbrunoster_at_gmail.com>
Date: Fri, 31 Mar 2023 19:05:46 +0200
Message-ID: <CA+dM1yMNcTTyXu-+nuG8xvAutcmnkQEZwoqWXFiviM+_PY9H3Q_at_mail.gmail.com>
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.
Date: Fri, 31 Mar 2023 19:05:46 +0200
Message-ID: <CA+dM1yMNcTTyXu-+nuG8xvAutcmnkQEZwoqWXFiviM+_PY9H3Q_at_mail.gmail.com>
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.
Do you have any suggestion ?
Regards
Pier paolo
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 31 2023 - 19:05:46 CEST