We help IT Professionals succeed at work.
Get Started

Allocate channel for maintenance in RMAN through scripts

ODOTServer
ODOTServer asked
on
3,290 Views
Last Modified: 2012-05-08
I am trying to allocate a channel for maintenance to crosscheck and delete expired and obsolete files.
I cannot find the correct syntax though to schedule this through scripts.
I keep receiving the "no channel allocated for maintenance" error. However, when I set my script to "allocate for maintenance" rman throws an error that it expects a channel_id etc.
I have tried several different syntax commands such as:
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK;
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
ALLOCATE CHANNEL CH1 FOR MAINTENANCE DEVICE TYPE DISK;
...
However, in each case RMAN throws a syntax error when I specify "FOR MAINTENANCE"

Could you review my script and tell me the proper syntax?
OS: win2k3 64
DB: Oracle 11.1.0.7
Thanks
cleanup.txt
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE