OraFAQ Forum: Backup & Recovery » RMAN Level0 Backup

Home » RDBMS Server » Backup & Recovery » RMAN Level0 Backup (Database 11gR2 RHEL5.564bit )

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

RMAN Level0 Backup [message #625674]

Mon, 13 October 2014 02:39

smunir362
Messages: 310
Registered: September 2007

Senior Member

Hi,
I am taking level0 backup of my 11g database I am using 4 parallel channels with zlib compression. It takes 5 hours to backup.
Can I reduce this time anyway.

Regards,

Report message to a moderator

Re: RMAN Level0 Backup [message #625675 is a reply to message #625674]

Mon, 13 October 2014 02:48

John Watson
Messages: 8968
Registered: January 2010
Location: Global Village

Senior Member

You need to determine if it is reading the datafile that requires five hours or writing the backupsets. You can test this with commands such as BACKUP VALIDATE....

Are you backing up to disc or to a tape device? What sort? How many discs/tape drives?

Report message to a moderator

Re: RMAN Level0 Backup [message #625676 is a reply to message #625675]

Mon, 13 October 2014 02:59

smunir362
Messages: 310
Registered: September 2007

Senior Member

Thanks,
I am taking backup on disk(SAN).
I do not know either (reading datafiles or writing backupset) takes time.

Report message to a moderator

Re: RMAN Level0 Backup [message #625677 is a reply to message #625676]

Mon, 13 October 2014 03:01

John Watson
Messages: 8968
Registered: January 2010
Location: Global Village

Senior Member

Quote:

I do not know either (reading datafiles or writing backupset) takes time.

I don't know either. The difference between us is that you can find out.

Report message to a moderator

Re: RMAN Level0 Backup [message #625678 is a reply to message #625677]

Mon, 13 October 2014 03:05

smunir362
Messages: 310
Registered: September 2007

Senior Member

how to use BACKUP VALIDATE command.
please give an example.

Report message to a moderator

Re: RMAN Level0 Backup [message #625681 is a reply to message #625678]

Mon, 13 October 2014 03:24

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

Senior Member
Account Moderator

What about the doc?

Report message to a moderator

Re: RMAN Level0 Backup [message #625686 is a reply to message #625681]

Mon, 13 October 2014 04:10

smunir362
Messages: 310
Registered: September 2007

Senior Member

Total backup time 5 hours.
Reading the datafiles takes 5 hours
OR
writing the backup to the backupsets.
How can I test it using BACKUP VALIDATE. Or any command

Report message to a moderator

Re: RMAN Level0 Backup [message #625691 is a reply to message #625686]

Mon, 13 October 2014 05:19

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

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 13 October 2014 10:24

What about the doc?

Report message to a moderator

Re: RMAN Level0 Backup [message #625736 is a reply to message #625691]

Mon, 13 October 2014 13:18

smunir362
Messages: 310
Registered: September 2007

Senior Member

Docs says
It used for corruption either physical or logical
But I want to know backup time
why rman backup take 5 hours
how much time take to read data files
how much time take for writing date to back upsets

Report message to a moderator

Re: RMAN Level0 Backup [message #625738 is a reply to message #625736]

Mon, 13 October 2014 13:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

One way to see where time is be spent is to do as below

ALTER SESSION SET SQL_TRACE=TRUE;

You can then inspect the content of the resultant trace file to see where time is being spent

Report message to a moderator

Re: RMAN Level0 Backup [message #625740 is a reply to message #625736]

Mon, 13 October 2014 13:45

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

Senior Member
Account Moderator

smunir362 wrote on Mon, 13 October 2014 20:18

Docs says
It used for corruption either physical or logical
But I want to know backup time
why rman backup take 5 hours
how much time take to read data files
how much time take for writing date to back upsets

This is irrelevant to your question about BACKUP VALIDATE syntax and example.
what does the doc say about this?

And what does BACKUP VALIDATE do and not do?

Report message to a moderator

Re: RMAN Level0 Backup [message #625741 is a reply to message #625740]

Mon, 13 October 2014 13:49

smunir362
Messages: 310
Registered: September 2007

Senior Member

Sir John Watson
As you comment
--You need to determine if it is reading the datafile that requires five hours or writing the backupsets. You can test this with commands such as BACKUP VALIDATE....
Please explain.

Report message to a moderator

Re: RMAN Level0 Backup [message #625743 is a reply to message #625741]

Mon, 13 October 2014 13:55

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

Senior Member
Account Moderator

Please read the documentation.

Quote:

what does BACKUP VALIDATE do and not do?

[Updated on: Mon, 13 October 2014 13:55]

Report message to a moderator

Re: RMAN Level0 Backup [message #625747 is a reply to message #625741]

Mon, 13 October 2014 14:39

John Watson
Messages: 8968
Registered: January 2010
Location: Global Village

Senior Member

smunir362 wrote on Mon, 13 October 2014 19:49

Sir John Watson
As you comment
--You need to determine if it is reading the datafile that requires five hours or writing the backupsets. You can test this with commands such as BACKUP VALIDATE....
Please explain.

Chapter 22 of the Backup And Recovery Users Guide.

Report message to a moderator

Re: RMAN Level0 Backup [message #625845 is a reply to message #625747]

Wed, 15 October 2014 00:53

smunir362
Messages: 310
Registered: September 2007

Senior Member

Thsnks
I under stand it

Report message to a moderator

Previous Topic:	ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Next Topic:	Rman backup with keep

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 21:40:05 CDT 2025