Backup & Recovery Strategy
(By Sherif Fahmy OCP DBA)
(Alaa Ali OCP DBA)

--------------------------------------
1.Multiplexing Control Files (5 times) using pfile follow these
steps
•Shutdown immediate
•Copy from existing control file using OS to new location
cp /home/oracle/oradata/xxxxxxx/control01.ctl /home2/oracle/oradata/ xxxxxxx /control04.ctl
cp /home/oracle/oradata/ xxxxxxx /control01.ctl /home2/oracle/oradata/ xxxxxxx /control05.ctl

•In pfile add the following:-
control_files = ("/home/oracle/oradata/Khartoum/control01.ctl", "/home/oracle/or
adata/Khartoum/control02.ctl", "/home/oracle/oradata/Khartoum/control3.ctl",
"/home2/oracle/oradata/ xxxxxxx /control04.ctl",
"/home2/oracle/oradata/ xxxxxxx /control05.ctl)
•Startup

---------------------------------------------------------
2.Multiplexing Redo Groups (4 groups with 2 Members) using pfile follow these steps

•Creating Group
cp /home/oracle/oradata/ xxxxxxx /redo01.log' /home/oracle/oradata/ xxxxxxx /redo04.log'
cp /home/oracle/oradata/ xxxxxxx /redo01.log' /home/oracle/oradata/ xxxxxxx /redo14.log'
Alter database add logfile group 4
('/home/oracle/oradata/ xxxxxxx/redo04.log','/home/oracle/oradata/ xxxxxxx /redo14.log');

•Creating Members
Alter database add logfile member '/home/oracle/oradata/xxxxxxx/redo11.log' to group 1, '/home/oracle/oradata/xxxxxxx/redo12.log' to group 2, '/home/oracle/oradata/xxxxxxx/redo13.log' to group 3;

-----------------------------------------------------------
3.View Datafiles using the Following Commands

Select file_name,tablespace_name from dba_data_files;

--------------------------------------------------------
4.Change the Database to Archive Log Mode

•Shutdown immediate
•Change the parameters in pfile
1.log_archive_start = true
2.log_archive_dest_1 = "location=/home/oracle/admin/xxxxxx/arch"
3.log_archive_format = arch_%t_%s.arc
4.log_archive_max_processes = 3
•Startup mount
•Alter database archivelog
•Alter database open

--------------------------------------------------------
5.Create Recovery Catalog

•create tablespace rman_ts
Datafile '/home2/oradata/rman01.dbf'
Size 200m;
•create user rman identified by rman
Default tablespace rman_ts
Temporary tablespace temp
Quota unlimited on rman_ts;
•grant recovery_catalog_owner,connect,resource to rman
•rman catalog rman/rman
•create catalog tablespace rman_ts;
•exit;
•rman target sys/change_on_install
•connect catalog rman/rman
•register database;
•resync catalog;
On UNIX shell prompt type:-
rman target rman/rman
connect catalog rman/rman;

*Note new feature in 9i
configure channel device type disk format = '/home2/oracle/backup/%u';

--------------------------------------------------
6.RMAN Scripts
ال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';
}

-------------------------------

In Addition :

-Export your database in weekly basis , preferable not the same day as the incremental level 0 day , make it WED or THR.
-Take OS User Manager Full Cold Backup whenever possible , but at least take one after you change your database to ArchiveLog Mode.
-Use a Backup Testing and Validation Strategy .
-If Possible : take 2 copies of each backup file , because one of them might be corrupted .


Note: xxxxxx = database name

-----------------------
thank's
alaa ali
OCP DBA 9i

مرسي كتير

اخي يمكن شرح الScript أدناه ينفذ يوم الجمعة
وتفاصيل الScript لان في احتياج اليها جدا
ويكتب فين حتي يتم عمل الRun له ولك جزيل الشكر

تسلم م م م م م م م م م م

السلام عليكم

اخي الكريم koky9i

1-عمل pack up لكل ال database يعني full packup
2-يحتوي ايضا على ال control fils
3-يحتوي على archive log files ويمسح القديم

هذا السكربت تتم كتلبته في شاشة ال RMAN
ويوجد شرح عن كيفية الدخول ال RMAN في نفس الموضوع


وشكرا

ALAA ALI
OCP DBA 9i

جزاك الله كل خير اللهم انفعنا مما علمتنا وزدنا علما مما ينفعنا
هل يوجد طريقة حتي لا يمسح القديم

شكرا

السلام عليكم

اخي الكريم koky9i


use

backup archivelog

without

delete input

وشكرا

ALAA ALI
OCP DBA 9i

جزاك الله كل خير ع كل اللى بتعمله معانا وربنا يكرمك