OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN BACKUP (9i,Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN BACKUP [message #328454]

Fri, 20 June 2008 04:32

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

Hi Friends,
I decided to test incremental backups ie., level 0 and level 1 on the test server. The size of the test server was 45 gb. When i ran the RMAN script which took incremental level 0 backup and archivelog backup, i found the total size of the backups being taken to be only around 18GB.
I was confused because the DB size is 45 Gb but the size of backups taken is only 18 GB(thought that level 0 amounts to full DB backup). Please clarify this.
Also I want to know whether it is required to take the full backup using Backup Database command, before going for the level 0 backups?

Report message to a moderator

Re: RMAN BACKUP [message #328457 is a reply to message #328454]

Fri, 20 June 2008 04:38

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

RMAN does not backup blocks that were never used.

Regards
Michel

Report message to a moderator

Re: RMAN BACKUP [message #328469 is a reply to message #328457]

Fri, 20 June 2008 05:07

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

Thanks Michel. I also want to know if the level 0 backup is same as taking the full database backup?

Report message to a moderator

Re: RMAN BACKUP [message #328477 is a reply to message #328469]

Fri, 20 June 2008 05:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In 10g, yes.
In 9i, iirc, you can only do incremental backup on level 0 and not on full.

Regards
Michel

Report message to a moderator

Re: RMAN BACKUP [message #328522 is a reply to message #328454]

Fri, 20 June 2008 06:49

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

To add,
the size of backupsets generated will depend on the activities on
the databases.
Operations like insert/update/delete may generate more redo ending as more archived logs.

Report message to a moderator

Previous Topic:	set sbt_tape to none?
Next Topic:	recovery of correpted block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:27:16 CST 2024