Home » RDBMS Server » Backup & Recovery » BACKUP FROM DAILY INCREMENTAL COPY WITH FULL WEEKLY BACKUP (ORACLE, 10.2g , Windows 2003)
BACKUP FROM DAILY INCREMENTAL COPY WITH FULL WEEKLY BACKUP [message #376621] Thu, 18 December 2008 01:05 Go to next message
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!!



Re: BACKUP FROM DAILY INCREMENTAL COPY WITH FULL WEEKLY BACKUP [message #376702 is a reply to message #376621] Thu, 18 December 2008 05:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
A lot of questions there. You really should review the follow docs:

Backup and Recovery Advanced User's Guide
Backup and Recovery Basics
Backup and Recovery Quick Start Guide
Re: BACKUP FROM DAILY INCREMENTAL COPY WITH FULL WEEKLY BACKUP [message #376844 is a reply to message #376702] Thu, 18 December 2008 20:03 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Tell me what happened when you tried to restore/recovery in testing database?
What's your RMAN policy?
What's your backup method - catalog or controlfile?
How about your approach mean time recovery?
How much your testing data?
Previous Topic: rman 'restore validate database' parallelism
Next Topic: oracle - 9.2.0.8.0 o/s: HP-UX:11.23
Goto Forum:
  


Current Time: Fri Nov 22 09:56:43 CST 2024