Home » RDBMS Server » Backup & Recovery » RMAN backup&dbms_scheduler
RMAN backup&dbms_scheduler [message #191033] Mon, 04 September 2006 04:27 Go to next message
linyumin
Messages: 13
Registered: August 2006
Location: Taiwan Taipei
Junior Member

Hi all~ I used dbms_scheduler and RMAN stored script to complete scheduler-backup~~

I had a job as below
--------------------------------------------------------------------------------
BEGIN
dbms_scheduler.create_job(job_name => 'sys.whole_db_backup',
job_type => 'executable',
job_action => 'F:\whole_db_backup.bat',
start_date => to_date('2006-08-05 00:00:00',
'yyyy-mm-dd hh24:mi:ss'),
repeat_interval => 'freq=daily;interval=7',
enabled => TRUE);

END;
--------------------------------------------------------------------------------
and my whole_db_backup.bat as below

rman target xxx/xxx@mydb catalog xxx/xxx@catadb script 'whole_db_backup'
log F:\rman_backup\rman_output.log

it worked well in the past time!!
But now the rman_output.log show the error message as below

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12154: TNS:could not resolve the connect identifier specified
----------------------------------------------------------------------------
if I manually run the job~~it show the error message as below
ORA-27369 job of type EXECUTABLE failed with exit code:?\???~?C

and if I manually run whole_db_backup.bat on db server~~it can work!!!!!


I've checked the tnsnames.ora and it's correct
my oracle_sid also set to "mydb"

tnsping can resolve "mydb"~~lsnrctl status and service all can see "mydb"~~

I think the error's not caused by database~~maybe the OS~~who can give me an idea???

[Updated on: Mon, 04 September 2006 04:29]

Report message to a moderator

Re: RMAN backup&dbms_scheduler [message #191291 is a reply to message #191033] Tue, 05 September 2006 08:51 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
batch job can be run directly via scheduler..

try executing cmd and then run batch job
c:\windows\cmd.exe /q /c F:\whole_db_backup.bat

Sandeep
Re: RMAN backup&dbms_scheduler [message #195647 is a reply to message #191033] Sat, 30 September 2006 01:21 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
i have created the batch for rman backup which have contens like
rman_backup.bat
rman target sys/gateway@wizmen catalog rman/rman@catdb script 'week_backup'
log c:\backup\rman_output.log

The script week_backup is working fine when i execute this from rman prompt
RMAN >run{execute script week_backup;}

When i run this batch file manually it did not work
it did not create any log file either,it also didn't generate any error
can u pinpoint that where i am having a problem?
Re: RMAN backup&dbms_scheduler [message #195672 is a reply to message #195647] Sat, 30 September 2006 21:06 Go to previous messageGo to next message
linyumin
Messages: 13
Registered: August 2006
Location: Taiwan Taipei
Junior Member

does you has multi-databases on your server???

check your RMAN execute path on the operating system

if RMAN's version don't match your database's version~
it can't work~~

it will don't show any message and any log when you manually execute the batch file~~

Maybe you should point the correct RMAN's execute path like as below~if it's your correct path and right RMAN's version

C:\rman target sys/gateway@wizmen catalog rman/rman@catdb script 'week_backup'
log c:\backup\rman_output.log
Re: RMAN backup&dbms_scheduler [message #195736 is a reply to message #195672] Mon, 02 October 2006 01:26 Go to previous message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
linyumin wrote on Sat, 30 September 2006 21:06

does you has multi-databases on your server???

check your RMAN execute path on the operating system

if RMAN's version don't match your database's version~
it can't work~~

it will don't show any message and any log when you manually execute the batch file~~

Maybe you should point the correct RMAN's execute path like as below~if it's your correct path and right RMAN's version

C:\rman target sys/gateway@wizmen catalog rman/rman@catdb script 'week_backup'
log c:\backup\rman_output.log



1- i don't have any other database on server except
production database and recovery catalog database
2- we have the same RMAN and Database version
3- What does it means to enter the correct path
and how can we determine the correct rman path

Prompt response will be appreciated
thanx in advance
Previous Topic: RMAN Backup using batch file
Next Topic: Scheduling of RMAN Backup Script Stored in Recovery Catalog
Goto Forum:
  


Current Time: Sun Dec 04 12:34:45 CST 2016

Total time taken to generate the page: 0.09677 seconds