BACKUP FROM DAILY INCREMENTAL COPY WITH FULL WEEKLY BACKUP [message #376621] |
Thu, 18 December 2008 01:05 |
alogator
Messages: 2 Registered: December 2008
|
Junior Member |
|
|
Hi!!
I'm trying to make a good backup
I put some code in RMAN:
BACKUP INCREMENTAL
LEVEL 0 TAG = WEEKLY DATABASE;
Backup Incremental LEVEL 1 TAG = MON DATABASE;
Backup Incremental LEVEL 1 TAG = TUE DATABASE;
Backup Incremental LEVEL 1 TAG = WED DATABASE;
Backup Incremental LEVEL 1 TAG = THU DATABASE;
Backup Incremental LEVEL 1 TAG = FRI DATABASE;
Backup Incremental LEVEL 1 TAG = SAT DATABASE;
Backup Incremental LEVEL 1 TAG = SUN DATABASE;
BACKUP INCREMENTAL LEVEL 1
FOR RECOVER OF COPY
WITH TAG WEEKLY DATABASE;
RECOVER COPY OF DATABASE
WITH TAG WEEKLY;
My questions are:
1) Is that scripts are all right? I mean if copies have been made every day? Iwould like to make this this proccess automatically.
2) how can I restore my whole database after formating my OS (Win 2003) - what another files do I need? ctl files, archivelog, init ora? ?
Please help me I'm fresh in it!!
|
|
|
|
|