| RMAN backup&dbms_scheduler [message #191033] |
Mon, 04 September 2006 04:27  |
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 #195647 is a reply to message #191033] |
Sat, 30 September 2006 01:21  |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
