Backup database on distinct OS using RMAN ( RMAN Hangs ) [message #72700] |
Tue, 23 September 2003 06:34 |
B
Messages: 327 Registered: August 1999
|
Senior Member |
|
|
Hi,
we're in trouble.
We trying to backup database ( Ora 8174 ) on a SUN SOLARIS 28 server. We want to keep backup files on our main backup server, a dec osf 5.1.
So we try to mount a FS using NFS on SUN SOLARIS Server. ( ie export DEC OSF FS and mount it on SUN SOLARIS ). But rman hangs without any errors.
So we decide to use Net*8 and run DEC OSF rman binary to backup remote SUN SOLARIS database ( So the FS is now local ). But Rman hangs too without any errors
We put RMAN in trace debug and we have this message :
RMAN-08010: canal ch1 : insertion du fichier de données dans l'ensemble de sauvegarde
krmxrpc: xc=5372260288 kpurpc2 rc=0 db=target proc=DBMS_BACKUP_RESTORE.BACKUPDATAFILE
krmxrpc: xc=5372260288 RPC #8 completed immediately
RMAN-08522: fichier de données en entrée fno=00004 nom=/IGMQUA98/ORA_DB/V12YN0UK/V12YN0UK_TOOLS_01.dbf
krmxrpc: xc=5372260288 kpurpc2 rc=0 db=target proc=DBMS_BACKUP_RESTORE.BACKUPSTATUS
krmxrpc: xc=5372260288 RPC #9 completed immediately
krmxrpc: xc=5372260288 kpurpc2 rc=3123 db=target proc=DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
krmxrpc: xc=5372260288 starting longrunning RPC #10 to target: DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
krmxr: xc=5372260288 started long running rpc
krmxpoq: xc=5372260288, action="0000010 STARTED", col_l=15, ind=0, sid=13
krmxr: callback returned TRUE, skipping sleep
krmxpoq: xc=5372260288, action="0000010 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 1 seconds
krmxpoq: xc=5372260288, action="0000010 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 2 seconds
krmxpoq: xc=5372260288, action="0000010 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 4 seconds
krmxpoq: xc=5372260288, action="0000010 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 8 seconds
krmxpoq: xc=5372260288, action="0000010 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 10 seconds
etc ... and loop ... and never finish.
It seems to work if we use a SUN SOLARIS NFS, but we really need to use our DEC OSF server.
we are sure that NFS are correctly mounted.
We think that we can create a temporary local FS to make backup and then move all datafiles on NFS. But we can never had enough local space disk.
So i have two questions ...
1) any ideas to solve this problem ?
2) did someone do this before ( ie: backup database and store datafile on others OS ) ? and how did you do ?
Thanks in advance.
Best regards.
B.
|
|
|
Re: Backup database on distinct OS using RMAN ( RMAN Hangs ) [message #73248 is a reply to message #72700] |
Tue, 09 March 2004 04:20 |
Stewart W. Bryson
Messages: 1 Registered: March 2004
|
Junior Member |
|
|
Did you ever find a workaround for this problem? The exact same thing is happenining to me. I'm running Oracle 9.2.0.4 on Red Hat Advanced Server writing to a SuSE 8.2 filesystem mounted with NFS. I had the exact same configuration on Solaris with another Solaris filesystem mounted with NFS and everything worked fine. I've tried experimenting with the BLKSIZE parm but to no avail.
|
|
|
|