OraFAQ Forum: Backup & Recovery » Export backup Error as sys user in Batch file execution

Home » RDBMS Server » Backup & Recovery » Export backup Error as sys user in Batch file execution

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export backup Error as sys user in Batch file execution [message #168377]

Thu, 20 April 2006 02:30

gururaajaan
Messages: 5
Registered: December 2005

Junior Member

Dear Sir's,
I am executing batch files for Exporting whole database as sys user.

My batch file looks as Below which is getting executed once in 2hrs...

D:\oracle\ora92\bin\exp.exe SYS/KuBaR as sysdba@KUBER owner=sys Full=y file=D:\DATABASE_HRLY_BKP\SYS_BKP.dmp compress=y grants=y indexes=y triggers=y rows=y consistent=y constraints=y statistics=none log=D:\DATABASE_HRLY_BKP\SYS_BKP_LOG.log

Issue : I was not able to export the full database dump.

When we executed the batch through commend prompt , we are getting the below mentioned error..

Please help in solving the above issue..

my error message is as below:

D:\Backup script>FullDBBkp.bat

D:\Backup script>D:\oracle\ora92\bin\exp.exe SYS/KuBaR as sysdba@KUBER owner=sys Full=y file=D:\DATABASE_HRLY_BKP\SYS_B
KP.dmp compress=y grants=y indexes=y triggers=y rows=y consistent=y constraints=y statistics=none log=D:\DATABASE_HRLY_B
KP\SYS_BKP_LOG.log
LRM-00108: invalid positional parameter value 'as'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

I can able to take backup for other users.. on hourly basis..

Help in this issues..

Regards

Gururajan R

Report message to a moderator

Re: Export backup Error as sys user in Batch file execution [message #168404 is a reply to message #168377]

Thu, 20 April 2006 04:34

madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india

Member

sys is sysdba you don't need "as" try to use service name directly

Thanks
Madhu

Report message to a moderator

Re: Export backup Error as sys user in Batch file execution [message #168405 is a reply to message #168377]

Thu, 20 April 2006 04:35

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Your syntax is wrong. Change

exp.exe SYS/KuBaR as sysdba@KUBER

exp.exe "SYS/KuBaR@KUBER as sysdba"

If it still doesn't work, try exporting with the system user.

Report message to a moderator

Re: Export backup Error as sys user in Batch file execution [message #168408 is a reply to message #168405]

Thu, 20 April 2006 04:40

gururaajaan
Messages: 5
Registered: December 2005

Junior Member

Hai,
Thx for ur suggestion. However i tried the same and the following error occured...

D:\Backup script>FullDBBkp.bat

D:\Backup script>D:\oracle\ora92\bin\exp.exe SYS/KuBaR@KUBER as sysdba owner=sys Full=y file=D:\DATABASE_HRLY_BKP\SYS_BK
P.dmp compress=y grants=y indexes=y triggers=y rows=y consistent=y constraints=y statistics=none log=D:\DATABASE_HRLY_BK
P\SYS_BKP_LOG.log
LRM-00108: invalid positional parameter value 'as'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

Regards

Gururajan R

Report message to a moderator

Re: Export backup Error as sys user in Batch file execution [message #169244 is a reply to message #168377]

Tue, 25 April 2006 22:14

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

Try this

exp.exe \"SYS/KuBaR@KUBER as sysdba \" Full=y ...

Note: owner=sys is not needed since there are Full=y

Alex zeng | Skype me: hans9zeng

Report message to a moderator

Re: Export backup Error as sys user in Batch file execution [message #170439 is a reply to message #169244]

Wed, 03 May 2006 19:33

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Looks like you are on a Windoze platform, therefore you'll have to use single-quotes ' instead of double-quotes "

exp.exe 'SYS/KuBaR@KUBER as sysdba'

Report message to a moderator

Previous Topic:	recovering after OPEN RESETLOGS
Next Topic:	recovery catalog incarnation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 21 15:10:57 CDT 2025