Home » RDBMS Server » Backup & Recovery » RMAN script query
RMAN script query [message #527514] Tue, 18 October 2011 07:59 Go to next message
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;
}
Re: RMAN script query [message #527515 is a reply to message #527514] Tue, 18 October 2011 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The best practice is not in a single script but in the overall policy.

Regards
Michel
Re: RMAN script query [message #527517 is a reply to message #527515] Tue, 18 October 2011 08:12 Go to previous messageGo to next message
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?
Re: RMAN script query [message #527522 is a reply to message #527517] Tue, 18 October 2011 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no need to more channels to delete but maybe you need more channels to back up.
It depends only on your hardware.

Regards
Michel
Re: RMAN script query [message #527525 is a reply to message #527522] Tue, 18 October 2011 09:55 Go to previous message
Kwisatz78
Messages: 24
Registered: October 2011
Junior Member
Ok thats great thanks
Previous Topic: adding DBID to rman backup definition
Next Topic: RMAN-06100: no channel to restore a backup or copy of datafile
Goto Forum:
  


Current Time: Sat Aug 30 23:56:45 CDT 2014

Total time taken to generate the page: 0.04768 seconds