Home » RDBMS Server » Backup & Recovery » Export backup Error as sys user in Batch file execution
icon2.gif  Export backup Error as sys user in Batch file execution [message #168377] Thu, 20 April 2006 02:30 Go to next message
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








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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Your syntax is wrong. Change

exp.exe SYS/KuBaR as sysdba@KUBER


to

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


If it still doesn't work, try exporting with the system user.
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 Go to previous messageGo to next message
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

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 Go to previous messageGo to next message
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
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 Go to previous message
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'
Previous Topic: recovering after OPEN RESETLOGS
Next Topic: recovery catalog incarnation
Goto Forum:
  


Current Time: Fri Mar 29 03:35:24 CDT 2024