Home » RDBMS Server » Backup & Recovery » Creating Backup Job with DBMS_SCHEDULER
Creating Backup Job with DBMS_SCHEDULER [message #282872] Sat, 24 November 2007 07:31 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hello,

Can someone please help me out here:

I'm using Oracle10g release 1 on windowsXP

I'm trying to create a backup job with dbms_scheduler and it's not working.
This is what I did:

I created a job as follows:

BEGIN
dbms_scheduler.create_job (
job_name => 'RMAN_FULL',
job_type => 'EXCUTABLE',
job_action => 'E:\wkdir\rman_bkp',
enabled => TRUE,
start_date => '24-NOV-2007 2:10:00 PM',
repeat_interval => 'FREQ=WEEKLY',
comments => 'Full Database Backup');
END;
/


While rman_bkp is an RMAN command but it wasn't working.
Please where do I get it wrong?

Kindly put me through the EXECUTABLE or should I use PL/SQL_BLOCK and how?

Thanks.


Regards,

Cherish
Re: Creating Backup Job with DBMS_SCHEDULER [message #282873 is a reply to message #282872] Sat, 24 November 2007 07:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

but it wasn't working.
Did you get any error ?
and what is extension of backup file ?
Re: Creating Backup Job with DBMS_SCHEDULER [message #282932 is a reply to message #282872] Sun, 25 November 2007 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"rman_bkp" is not an executable in Windows.

Regards
Michel
Re: Creating Backup Job with DBMS_SCHEDULER [message #282972 is a reply to message #282873] Sun, 25 November 2007 14:18 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
The extension of the file rman_bkp is .sql and later tries .txt but both
ain't working.

Below is the error message I got:

ERROR at line 1:
ORA-06550: line ORA-06550: line 1, column 357:
PLS-00103: Encountered the symbol ":" when expecting one of the following:
:= . ( @ % ;, column :
ORA-06512: at "SYS.DBMS_ISCHED", line 148
ORA-06512: at "SYS.DBMS_SCHEDULER", line 374
ORA-06512: at line 2


Thanks


Cherish
Re: Creating Backup Job with DBMS_SCHEDULER [message #282975 is a reply to message #282972] Sun, 25 November 2007 14:44 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

The extension of the file rman_bkp is .sql and later tries .txt but both
ain't working.

Neither are executable for Windows.
Executables for Windows are .exe, .bat, .cmd... not .sql or .txt

Regards
Michel

[Updated on: Sun, 25 November 2007 14:44]

Report message to a moderator

Previous Topic: tape backup- help required pls
Next Topic: Redo Log File
Goto Forum:
  


Current Time: Tue Dec 06 12:17:05 CST 2016

Total time taken to generate the page: 0.21671 seconds