Home » RDBMS Server » Backup & Recovery » RMAN Backups Schedule
RMAN Backups Schedule [message #195644] Sat, 30 September 2006 00:02 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
i am using 8.1.7
i didn't create any recovery catalog
i have the following script to backup the whole database

RMAN> run {allocate channel c1 type disk
format 'c:\backup\%U';
backup database inlude current controlfile;


Every time i have to run this script manually
1-C:\rman target sys/gateway@testdb /nocatalog
2-Write the script manually each time i want to take backup

I want to create a batch file which includes the script which i have to run manaully
So by creating a batch file we can schedule the task of Backup

For example look at the batch file which i had for export
exp.bat
exp 'sys/gateway@testdb as sysdba' owner=hr log=c:\log1.log

Like that batch file how can we create the batch file for rman backup
Can anybody help me in this regard?
Thanx in advance
Re: RMAN Backups Schedule [message #195657 is a reply to message #195644] Sat, 30 September 2006 07:37 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
you already posted new question which has all details on batch file.
I think you know how to write batch file.

Sandeep
Re: RMAN Backups Schedule [message #310270 is a reply to message #195644] Mon, 31 March 2008 15:45 Go to previous message
mah_06
Messages: 1
Registered: February 2008
Location: Jordan
Junior Member
put in the batch file:
rman target sys/pass cmdfile='C:\tt.txt'

tt.txt
contains Rman Commands.
Previous Topic: Log_Archive_dest setting to remote standby server
Next Topic: Starting Database from archive log files
Goto Forum:
  


Current Time: Sun May 12 01:48:47 CDT 2024