Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, August 23, 2011

NFS mount options for Oracle on Solaris

NFS mounts need to have the correct mount options so the following document may help:

- Mount Options for Oracle files when used with NAS devices (Doc ID 359515.1)


rw,bg,vers=3,hard,intr,proto=tcp,rsize=32768,wsize=32768,llock,suid,timeo=600,actimeo=0


when we used these options

rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,forcedirectio,vers=3,suid

we had some issues while backing up the controlfile with the below command:

>rman

Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 19 21:50:38 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target /

connected to target database: Database (DBID=482)


RMAN> backup current controlfile format '/icm_stage/sshaik/backup_controlfile.ctl';

Starting backup at 19-MAY-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 19-MAY-11
channel ORA_DISK_1: finished piece 1 at 19-MAY-11
piece handle=/icm_stage/sshaik/backup_controlfile.ctl tag=TAG20110519T215129 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 19-MAY-11

RMAN> backup tag 'RapidClone_RAC' as copy current controlfile format '/icm_stage/sshaik/backup_controlfile1.ctl';

Starting backup at 19-MAY-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
channel ORA_DISK_1: starting datafile copy
copying current control file

<--- BACKUP NEVER FINISHES AND NEVER RELEASES THE CURSOR------>
<--- HAVE TO USE BREAK OUT OPTIONS CTRL C TO COME OUT OF THE SESSION--->

No comments: