complete RMAN backup script

[yxez]

Hi Dearest Friends,

What is the simplest RMAN command that will backup everything
that is needed in complete recovery including init.ora,controlfiles,datafiles, redologs,etc,etc ...and output will be located on one folder for ease of transfer to offsite and then clean up all unnecessary old files.

I tried to backup my test tb and move the backup to other server and
restore there and everytime I do it i lack somethin or its incomplete and I have to copy something again manually and some files dafaulted to other
backup dir

Thanks a lot for your kindness

Is this correct?

rman
run
{
allocate channel d1 type disk;
backup
format '/u03/RMAN/%d_al_t%t_s%s_p%p'
database;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
crosscheck backup;
delete obsolete;
delete expired backup;
crosscheck archivelog all;
delete expired archivelog all;
}

[yxez]

Muchas gracias Pando mi querido,usted es muy amable
(Im practising my spanish now coz i'll be employed in Mexico as DBA soon
say good luck to me )

Do you have somthing like this for windows too?
Puedo yo usar este para la versión 9i. Puede u darme también la versión de no estante


Gracias mucho otra vez

[pando]

I dont do Windows hehe, if you want to use it for Windows use Cygwin or something similar

For 9i you just have to get rid of compression part and it should work....

[yxez]

thanks dear ....do you undertand my spanish message? are they grammatically correct