On 3/31/23 13:05, pier paolo Bruno wrote:
I have to duplicate an ora10g database from one machine to another one .Hi Paolo,
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.