Re: help me resolve this hot backup failure !!
- From: Surya Vempati <suryavempati@xxxxxxxxx>
- To: premjhere@xxxxxxxxx
- Date: Tue, 2 Aug 2005 11:21:42 -0400
Hi,
This is Cause of the .Aud files generated under $ORACLE_HOME/rdbms/audit
directory. Try the following
Before trying , can u try to login as the user with which ur taking
hotbackups. do not use /nolog option , still getting error , then proceed
..with following...
1) Remove the *.aud files or
2) Move the direcotry audit to audit1 & create dir audit
3) Try login again (i mean thru the user with which ur taking hotbackups)
If you are not able to do the step 1 or step2, ask Sys admin to do , if ur
not able to do as Oracle user.
Thanks
VV
On 8/1/05, Surya Vempati <suryavempati@xxxxxxxxx> wrote:
>
> Hi,
> This is Cause of the .Aud files generated under $ORACLE_HOME/rdbms/audit
> directory. Try the following
> Before trying , can u try to login as the user with which ur taking
> hotbackups. do not use /nolog option , still getting error , then proceed
> ..with following...
>
> 1) Remove the *.aud files or
> 2) Move the direcotry audit to audit1 & create dir audit
> 3) Try login again (i mean thru the user with which ur taking hotbackups)
> If you are not able to do the step 1 or step2, ask Sys admin to do , if
> ur not able to do as Oracle user.
> Thanks
> VV
> On 8/1/05, Prem <premjhere@xxxxxxxxx> wrote:
> >
> > Hi All ,
> >
> > the ENV is oracle 9.2.0.1 <http://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
> >
>
>
Other related posts:
