Home » RDBMS Server » Backup & Recovery » RMAN Level0 Backup (Database 11gR2 RHEL5.564bit )
RMAN Level0 Backup [message #625674] Mon, 13 October 2014 02:39 Go to next message
smunir362
Messages: 305
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,
Re: RMAN Level0 Backup [message #625675 is a reply to message #625674] Mon, 13 October 2014 02:48 Go to previous messageGo to next message
John Watson
Messages: 7262
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?
Re: RMAN Level0 Backup [message #625676 is a reply to message #625675] Mon, 13 October 2014 02:59 Go to previous messageGo to next message
smunir362
Messages: 305
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.
Re: RMAN Level0 Backup [message #625677 is a reply to message #625676] Mon, 13 October 2014 03:01 Go to previous messageGo to next message
John Watson
Messages: 7262
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.
Re: RMAN Level0 Backup [message #625678 is a reply to message #625677] Mon, 13 October 2014 03:05 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
how to use BACKUP VALIDATE command.
please give an example.
Re: RMAN Level0 Backup [message #625681 is a reply to message #625678] Mon, 13 October 2014 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What about the doc?

Re: RMAN Level0 Backup [message #625686 is a reply to message #625681] Mon, 13 October 2014 04:10 Go to previous messageGo to next message
smunir362
Messages: 305
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
Re: RMAN Level0 Backup [message #625691 is a reply to message #625686] Mon, 13 October 2014 05:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

What about the doc?

Re: RMAN Level0 Backup [message #625736 is a reply to message #625691] Mon, 13 October 2014 13:18 Go to previous messageGo to next message
smunir362
Messages: 305
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
Re: RMAN Level0 Backup [message #625738 is a reply to message #625736] Mon, 13 October 2014 13:35 Go to previous messageGo to next message
BlackSwan
Messages: 25856
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
Re: RMAN Level0 Backup [message #625740 is a reply to message #625736] Mon, 13 October 2014 13:45 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
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?

Re: RMAN Level0 Backup [message #625741 is a reply to message #625740] Mon, 13 October 2014 13:49 Go to previous messageGo to next message
smunir362
Messages: 305
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.
Re: RMAN Level0 Backup [message #625743 is a reply to message #625741] Mon, 13 October 2014 13:55 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
John Watson
Messages: 7262
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.
Re: RMAN Level0 Backup [message #625845 is a reply to message #625747] Wed, 15 October 2014 00:53 Go to previous message
smunir362
Messages: 305
Registered: September 2007
Senior Member
Thsnks
I under stand it
Previous Topic: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Next Topic: Rman backup with keep
Goto Forum:
  


Current Time: Wed Feb 21 06:07:40 CST 2018

Total time taken to generate the page: 0.08083 seconds