OraFAQ Forum: Backup & Recovery » RMAN script query

Home » RDBMS Server » Backup & Recovery » RMAN script query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN script query [message #527514]

Tue, 18 October 2011 07:59

Kwisatz78
Messages: 24
Registered: October 2011

Junior Member

Hi all - Can anyone tell me if this script is following best practice for the base backup for an incremental strategy. The reason I ask is that I am confused by channel allocations in particular to the delete.

Thanks

RUN {
allocate channel c1 device type disk;
backup incremental level 0 database;
backup archivelog all delete input;
delete noprompt obsolete device type disk;
release channel c1;
}

Report message to a moderator

Re: RMAN script query [message #527515 is a reply to message #527514]

Tue, 18 October 2011 08:01

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The best practice is not in a single script but in the overall policy.

Regards
Michel

Report message to a moderator

Re: RMAN script query [message #527517 is a reply to message #527515]

Tue, 18 October 2011 08:12

Kwisatz78
Messages: 24
Registered: October 2011

Junior Member

Ok understood perhaps I should have been clearer. I meant will my script work and is it efficient? I mean is there a downside to using a single channel for the tasks in the script or should I create separate channels for the delete?

Report message to a moderator