-
Restauration RMAN après des sauvegardes différentilles et cumulati
Procédure de restauration après une sauvegarde incrémentale niveau 0 (full) + une suvegarde cumulative (niveau 1)
Est-ce que cette procédure est correcte pour restaurer une sauvegarde incrémentale de niveau 0 plus une sauvegarde cumulative
RMAN> alter database mount ;
RMAN> restore database tag='sauvegarde_incrémentale niveau 0';
RMAN> restore database tag='sauvegarde_incrémentale cumulative niveau 1';
RMAN> recover database
RMAN> alter database open resetlogs ;
-
im guessing as you wrote in french - but you dont restore a level 0 then a level 1 - you set the time you want to restore to using set until an then just issue a restore and the recover
-
OK thank you for your answer, but I tried this already but this brings me back to the status of the base that does not include my backup cumulatively.
-
That's pretty interesting, it looks like your level=1 is not merged with your level=0.
I have two follow up questions.
1- What's your Oracle version? is it Ora10g?
2- Could you please show us the command you used to take incremental level=1 backup?
In regards to question #2 - if you are running on Ora10g it should look something like:
RMAN> backup incremental level_1 for recover of copy with tag level_0 database;
Last edited by PAVB; 01-03-2009 at 10:09 AM.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
I have two follow up questions.
1- What's your Oracle version? is it Ora10g?
Yes It's Oracle 10G
2- Could you please show us the command you used to take incremental level=1 backup?
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE with TAG .....;
3.
RMAN> backup incremental level_1 for recover of copy with tag level_0 database
After this command, is it necessary to restore ?
-
RMAN> backup incremental level_1 for recover of copy with tag level_0 database; is this command mandatory for 10G?
Cant we use
RMAN>backup incremental level 1 database with tag='level_0'; ?
-
Mohit -
If you use that command your level 1 backup is just tagged as level_0 (tag='level_0'). If you want to recover your base level 0 backup every time with level 1 you have to use
RMAN> backup incremental level_1 for recover of copy with tag level_0 database;
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Ok, after this command is it necessary
to realise this step
RMAN> recover database
RMAN> alter database open resetlogs
Thanks
-
Davis -
That command is to recover your base backup. If you want to recover your database from the backup then you need to follow the regular restore / recover process.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
sorry for syntactical error in the previous post...what i meant was
MAN> backup incremental level1 database tag='level1';
Wont this command work?
The command 'for recover of copy' is especially used fro incrementally updated backups where we continuously update the base backup(level 0) by applying the incremental backup...
So i think the command which i mentioned should also work...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|