بسم الله الرحمن الرحيم

Can Anybody help me on this matter

i want the best backup and recovery script using RMAN
and i want this script to be implemented using Incremental method

thanc ya shabab
and sorry about my english since my pc doesnt support arabic


jazakom allah 7'eer

what did you mean by Rman\
????????

if you are an oracle DBA and u dont know what is RMAN

sorry to say that u know nothing about oracle DBA

RMAN : Recovery Manager

السلام عليكم ورحمة الله

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
sql "alter system switch logfile";
backup
incremental level 0
format '$HOME/BACKUP/%d_%t_%s_%p.bus'
filesperset 5 (database include current controlfile);
sql "alter system archive log current";
backup
format '$HOME/BACKUP/%d_%t_%s_%p.bus'
(archivelog all delete input);
backup
format '$HOME/BACKUP/%d_%t_%s_%p.bus'
(current controlfile);
release channel d1;
release channel d2;
release channel d3;
}

تحياتى

enrique2k

i dont waiting you to exam me if you i dba or not i just ask becuase some one ask the same quation like you ? when i answer him he tell he is mean other somthing
so dont write to me or answer me like that way and thanks for this answer
thats mean what you are ?? and what in your mind???

شكرا يا وليد على الscript الرائع
but there is one question

is that script for incremental only and if it is what is the fileperset and how can we backup the database fully?
thanx in advanced and thanx for every thing

note to admin05: i dont mean to heart ur feelings im really sorry but all i know there is one RMAN in oracle thats all
and soory again

can u explan the script plz
أخوكم بالله الجزار

تم تعديل 9 أغسطس 200520 سنة بواسطة enrique2k

موضوع هام ورد سهل وجميل من وليد وشكرا لك جميعا...

جزاكم الله خيرا يا شباب و اكثر الله من امثالكم
و بارك فيكم

Backup & Recovery Strategy

الScript أدناه ينفذ يوم الجمعة
create script Fri_Backup
}
allocate channel ch1 type disk format '/home2/oracle/backup/%u'; backup incremental level 0 database;
allocate channel ch2 type disk format '/home2/oracle/backup/%ctl';
backup current controlfile tag='Friday_Backup';
allocate channel ch3 type disk format '/home2/oracle/backup/%arc';
backup archivelog all delete input;

{
الScript أدناه ينفذ أيام السبت , الأحد, الثلاثاء , الأربعاء
create script SatSunTueWed_Backup
}
allocate channel ch1 type disk format '/home2/oracle/backup/%u';
backup incremental level 2 database;
backup current controlfile tag='SatSun_Backup';
{
الScript أدناه ينفذ يومي الإثنين والخميس

create script MonThu_Backup
}
allocate channel ch1 type disk format '/home2/oracle/backup/%u';
backup incremental level 1 database;
backup current controlfile tag='MonThu_Backup';
{


Alaa Ali
OCP DBA ORACLE 9I