Home » RDBMS Server » Backup & Recovery » RMAN BACKUP (9i,Windows 2003)
RMAN BACKUP [message #328454] Fri, 20 June 2008 04:32 Go to next message
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? Confused
Re: RMAN BACKUP [message #328457 is a reply to message #328454] Fri, 20 June 2008 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN does not backup blocks that were never used.

Regards
Michel
Re: RMAN BACKUP [message #328469 is a reply to message #328457] Fri, 20 June 2008 05:07 Go to previous messageGo to next message
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?
Re: RMAN BACKUP [message #328477 is a reply to message #328469] Fri, 20 June 2008 05:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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


Re: RMAN BACKUP [message #328522 is a reply to message #328454] Fri, 20 June 2008 06:49 Go to previous message
Mahesh Rajendran
Messages: 10672
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.

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


Current Time: Sun Dec 04 13:02:34 CST 2016

Total time taken to generate the page: 0.09142 seconds