Home » RDBMS Server » Backup & Recovery » Differential backup
Differential backup [message #350427] Thu, 25 September 2008 00:58 Go to next message
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 #350445 is a reply to message #350427] Thu, 25 September 2008 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes there is something like that.

Regards
Michel
Re: Differential backup [message #350448 is a reply to message #350427] Thu, 25 September 2008 01:55 Go to previous messageGo to next message
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 #350456 is a reply to message #350448] Thu, 25 September 2008 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I said "something like that" not "this is that".
Maybe if you look at the documentation instead of trying to find the correct syntax you have a better chance to get it.

Regards
Michel
Re: Differential backup [message #350471 is a reply to message #350427] Thu, 25 September 2008 03:10 Go to previous messageGo to next message
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 #350478 is a reply to message #350471] Thu, 25 September 2008 03:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good! Easy with the documentation isn't it?

Regards
Michel
Re: Differential backup [message #350501 is a reply to message #350427] Thu, 25 September 2008 04:17 Go to previous messageGo to next message
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 messageGo to next message
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 #350524 is a reply to message #350501] Thu, 25 September 2008 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What about when I will need to do a restore, don't I need the archivelogs as well.

Yes but you backed up them so RMAN will retrieve them.

Regards
Michel
Re: Differential backup [message #350526 is a reply to message #350518] Thu, 25 September 2008 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Will that is correct or you need to restore from a incremental backup?

You have not to know where is the backup, RMAN knows it for you.
Just use restore/recover command.

Regards
Michel
Re: Differential backup [message #350882 is a reply to message #350445] Fri, 26 September 2008 16:32 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

Michel Cadot wrote on Thu, 25 September 2008 01:29
Yes there is something like that.



The command what he fired is worng, there is no command like that.
Incremental backups are differential by default.So he need to take a normal incremental backup.

check this link...
http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm
Re: Differential backup [message #350898 is a reply to message #350882] Sat, 27 September 2008 01:03 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: ADMINISTER RESOURCE MANAGER in EXP_FULL_DATABASE
Next Topic: RMAN Backup
Goto Forum:
  


Current Time: Sun Dec 04 00:17:41 CST 2016

Total time taken to generate the page: 0.04381 seconds