Avatar of johanntagle
johanntagleFlag for Philippines

asked on 

Scripting RMAN 8i for Windows 2000

So in my previous question on RMAN 8i and Windows (https://www.experts-exchange.com/questions/27005850/RMAN-Recipes-for-Oracle-8i-on-Windows.html) I was told I can use the task scheduler to automate backups.  The recipes given to me by mrjoltcola were excellent but I find myself still stumped re how to transform it into a batch file that will be called by the task scheduler as I've got zero experience in Windows server administration.  Any help would be greatly appreciated.  Thanks.
Oracle DatabaseWindows 2000

Avatar of undefined
Last Comment
johanntagle
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

hi johanntagle,
- i've wrote a step on how to schedule rman backup on Windows few week back. however kindly noted that, the script is for RMAN 10g therefore you should use your script instead. you might also need to chage the $Rman target syntax that i specify in the "YourDB.rcv" script:

- look for the step ID: 35509632 from thy link below:
https://www.experts-exchange.com/questions/26986479/automated-backup.html
Avatar of johanntagle
johanntagle
Flag of Philippines image

ASKER

Was able to figure it out.  I moved the recipe into an .rcv file, then created a batch file that has

rman target sys/change_on_install@test catalog rman/rman@rcat cmdfile=e:\rman_scripts\full_backup.rcv

(obviously using a test database here so didn't bother mask passwords).

My follow-up question would be, is it a good practice, assuming that you have multiple target databases which are identical (i.e. same target location for backup files), to just have multiple lines on the batch file, i.e.

rman target sys/change_on_install@db1 catalog rman/rman@rcat cmdfile=e:\rman_scripts\full_backup.rcv
rman target sys/change_on_install@db2 catalog rman/rman@rcat cmdfile=e:\rman_scripts\full_backup.rcv
rman target sys/change_on_install@db3 catalog rman/rman@rcat cmdfile=e:\rman_scripts\full_backup.rcv

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

- i actually can't remember why i didn't run my rman backup all in one script but there must be reason for it that time that i cannot recall.
SOLUTION
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of johanntagle
johanntagle
Flag of Philippines image

ASKER

I'm getting a "could not start" message in scheduled tasks - it worked for my test instance on Windows XP, but on the Windows 2000 server I can't make it work.  What can I check?  Thanks.
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

this is from memory. i will confirmed this setting tomorrow at office. however you need to test the settings which work best on your environment:
- on Task tab, preferable that you set admin user. then checked the Enabled option
- on Settings, uncheck wake computer to run this task (due to uncertainty of windows, on another server i have to set it to wake)
- on Security, make sure that Full Control-Modify-Read&Execute-Read-Write is check for the user that you select to run the script.

: to understand more on task scheduler, read the doc: http://technet.microsoft.com/en-us/library/bb742547.aspx
SOLUTION
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of johanntagle
johanntagle
Flag of Philippines image

ASKER

Thanks OP!  Will try them out later.
Avatar of johanntagle
johanntagle
Flag of Philippines image

ASKER

Thanks again to OP and MrJoltCola!
Oracle Database
Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo