Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: help me resolve this hot backup failure !!

Re: help me resolve this hot backup failure !!

From: mkb <mkb125_at_yahoo.com>
Date: Mon, 1 Aug 2005 08:08:51 -0700 (PDT)
Message-ID: <20050801150851.67244.qmail@web32806.mail.mud.yahoo.com>

> 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.
> --
> http://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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 01 2005 - 10:10:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US