Re: help me resolve this hot backup failure !!

  • From: mkb <mkb125@xxxxxxxxx>
  • To: premjhere@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 1 Aug 2005 08:08:51 -0700 (PDT)

--- Prem <premjhere@xxxxxxxxx> wrote:

> Hi All ,
> 
> the ENV is oracle 9.2.0.1 on SunOS 5.8.
> recently .... my hot backup log shows the following
> error .
> 
>
************************************************************************************
> Altering tablespace MARKETFIRST_LIDX out of backup
> mode...
> ERROR:
> ORA-09925: Unable to create audit trail file
> SVR4 Error: 13: Permission denied
> Additional information: 9925
> ORA-01075: you are currently logged on
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> where <logon> ::=
> <username>[/<password>][@<connect_string>] | /
> ERROR:
> ORA-01005: null password given; logon denied
> SP2-0157: unable to CONNECT to ORACLE after 3
> attempts, exiting SQL*Plus
> Altering tablespace FCCUST_DATA into backup mode...
> Tablespace altered
>
************************************************************************************
> 
> The directory mentioned as in AUDIT_TRAIL_DEST
> exists with proper permission
> and free space.I am able to create files in that
> directory.So i'm not
> run out of inodes ... i hope.
> 
> i am able conn to DB as 
> 
> $sqlplus /nolog
> SQL > conn / as sysdba
> 
> This works fine without any issues.
> but i don't know why the backup fails.
> 
> Can someone please help me sort it out ?
> 
> Regards,
> Prem.
> --
> //www.freelists.org/webpage/oracle-l
> 
Hi Prem,

Check out metalink note 1056988.6 ORA-09925 During Hot
Backups.  Specifically mentions disk space which you
say you have enough or shortage of inodes.  Looks like
a possible inode issue then.

--
mohammed




        
                
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 
http://promotions.yahoo.com/new_mail
--
//www.freelists.org/webpage/oracle-l

Other related posts: