Differential backup [message #350427] |
Thu, 25 September 2008 00:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Mimas
Messages: 40 Registered: September 2008 Location: Athens
|
Member |
|
|
hello all,
I have created a script for taking a full backup together with archive logs using RMAN.
Now I wish to take differential backup as well.
How do I do that? Is there any command from RMAN to take differential backup such us
RMAN> backup database with differential;
thanks
|
|
|
|
Re: Differential backup [message #350448 is a reply to message #350427] |
Thu, 25 September 2008 01:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Mimas
Messages: 40 Registered: September 2008 Location: Athens
|
Member |
|
|
I have tried :
RMAN> backup database with differential;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, backup, backupset, channel, controlfilecopy, current, database, datafile, datafilecopy, delete, diskratio, filesperset, format, force, include, keep, (, maxsetsize, noexclude, nokeep, not, parms, pool, plus, ;, skip, spfile, setsize, tablespace, tag"
RMAN-01008: the bad identifier was: with
RMAN-01007: at line 1 column 17 file: standard input
WITH is not correct.
Does anyone knows the syntax of this command?
|
|
|
|
Re: Differential backup [message #350471 is a reply to message #350427] |
Thu, 25 September 2008 03:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Mimas
Messages: 40 Registered: September 2008 Location: Athens
|
Member |
|
|
Weekly full backup
backup incremental level 0 database plus archivelog delete all input;
-- Daily backup --
backup incremental level 1 cumulative database plus archvielog delete all inputs;
|
|
|
|
Re: Differential backup [message #350501 is a reply to message #350427] |
Thu, 25 September 2008 04:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Mimas
Messages: 40 Registered: September 2008 Location: Athens
|
Member |
|
|
--Weekly full backup--
backup incremental level 0 database plus archivelog delete all input;
-- Daily backup --
backup incremental level 1 database plus archvielog delete all input;
By having the above backups all the archivelogs after the backup will be deleted.
What about when I will need to do a restore, don't I need the archivelogs as well.
|
|
|
Re: Differential backup [message #350518 is a reply to message #350427] |
Thu, 25 September 2008 04:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Mimas
Messages: 40 Registered: September 2008 Location: Athens
|
Member |
|
|
Something else, If you take a incremental backup level 0 and level 1 how do your restore is it like:
RMAN> shutdown immediate;
RMAN> startup mount;
RMAN> restore database;
Will that is correct or you need to restore from a incremental backup?
thank you
|
|
|
|
|
|
Re: Differential backup [message #350898 is a reply to message #350882] |
Sat, 27 September 2008 01:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Did you read the whole topic before posting this answer?
Obviously not otherwise you would understand that I didn't say that this command exists but just implies that OP should refer to the documentation which he did and found himself the answer.
Regards
Michel
|
|
|