[racattack] Re: Create Database Error:"Recover Manager Failed to restore datafiles."

  • From: Alvaro Miranda <kikitux@xxxxxxxxx>
  • To: Hanh Nguyen <hanhnguyen2100@xxxxxxxxx>
  • Date: Thu, 24 Apr 2014 07:01:27 +1200

send the output of the following commands from Both nodes

asmcmd lsdg
asmcmd lsdsk
cat /proc/meminfo
df -h
id grid
id oracle

what user you used for grid and what user where you using for db install?




> On 23/04/2014, at 10:54 pm, Hanh Nguyen <hanhnguyen2100@xxxxxxxxx> wrote:
> 
> Hi Everyone,
> About 2% completed in Step 5 of 5  "Create Database" using dbca, I get this 
> error:
> "Recover Manager Failed to restore datafiles. Refer logs for details." and 
> VNCserver aborted back to the Linux prompt.
> Attached is the zipped trace.log file from  
> /u01/app/oracle/cfgtoollogs/dbca/RAC.
> The followings are the CRS resources, rac.db resources were created but 
> OFFLINE.
> Hanh,
> PS: I'm using racattack automation method
> 
> [root@collabn1 ~]# crsctl stat res -t
> --------------------------------------------------------------------------------
> Name           Target  State        Server                   State details    
>   
> --------------------------------------------------------------------------------
> Local Resources
> --------------------------------------------------------------------------------
> ora.DATA.SHARED.advm
>                ONLINE  ONLINE       collabn1                 Volume device 
> /dev/asm/shared-449 is online,STABLE
>                ONLINE  ONLINE       collabn2                 Volume device 
> /dev/asm/shared-449 is online,STABLE
> ora.DATA.dg
>                ONLINE  ONLINE       collabn1                 STABLE
>                ONLINE  ONLINE       collabn2                 STABLE
> ora.FRA.dg
>                ONLINE  ONLINE       collabn1                 STABLE
>                ONLINE  ONLINE       collabn2                 STABLE
> ora.LISTENER.lsnr
>                ONLINE  ONLINE       collabn1                 STABLE
>                ONLINE  ONLINE       collabn2                 STABLE
> ora.asm
>                ONLINE  ONLINE       collabn1                 Started,STABLE
>                ONLINE  ONLINE       collabn2                 Started,STABLE
> ora.data.shared.acfs
>                ONLINE  ONLINE       collabn1                 mounted on 
> /shared,STABLE
>                ONLINE  ONLINE       collabn2                 mounted on 
> /shared,STABLE
> ora.net1.network
>                ONLINE  ONLINE       collabn1                 STABLE
>                ONLINE  ONLINE       collabn2                 STABLE
> ora.ons
>                ONLINE  ONLINE       collabn1                 STABLE
>                ONLINE  ONLINE       collabn2                 STABLE
> --------------------------------------------------------------------------------
> Cluster Resources
> --------------------------------------------------------------------------------
> ora.LISTENER_SCAN1.lsnr
>       1        ONLINE  ONLINE       collabn1                 STABLE
> ora.LISTENER_SCAN2.lsnr
>       1        ONLINE  ONLINE       collabn2                 STABLE
> ora.LISTENER_SCAN3.lsnr
>       1        ONLINE  ONLINE       collabn2                 STABLE
> ora.collabn1.vip
>       1        ONLINE  ONLINE       collabn1                 STABLE
> ora.collabn2.vip
>       1        ONLINE  ONLINE       collabn2                 STABLE
> ora.cvu
>       1        ONLINE  ONLINE       collabn2                 STABLE
> ora.oc4j
>       1        OFFLINE OFFLINE                                 STABLE
> ora.rac.db
>       1        OFFLINE OFFLINE                                 STABLE
>       2        OFFLINE OFFLINE                                 STABLE
> ora.scan1.vip
>       1        ONLINE  ONLINE       collabn1                 STABLE
> ora.scan2.vip
>       1        ONLINE  ONLINE       collabn2                 STABLE
> ora.scan3.vip
>       1        ONLINE  ONLINE       collabn2                 STABLE
> --------------------------------------------------------------------------------
> [root@collabn1 ~]#
> 
> <trace.zip>

Other related posts: