Home » RDBMS Server » Backup & Recovery » Restore Performance (Oracle 9i (9.2.0.8) + Red Hat Linux 4 )
Restore Performance [message #447757] Wed, 17 March 2010 14:25 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

On last week i was trying to restore database (9i). It was taking 6-7 days to restore 400g database.

Please advice me why it was taking long time to restore entire database? There are 7 channel i allocated but still taking 6-7 days. Is there any way to increase restore performance?

- Babu
Re: Restore Performance [message #447759 is a reply to message #447757] Wed, 17 March 2010 14:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmtunin.htm#446432

Overallocating the channels could actually make it worse.
What is rationale behind your 7 Channel allocation?
As usual, it depends on factors.
Where are you restoring from? Local disk/tape or from remote disk?
Restore and recover or just restore?
How many datafiles?
32 bit or 64bit?
Large pool size?
How long did it take to backup?

[Updated on: Wed, 17 March 2010 14:42]

Report message to a moderator

Re: Restore Performance [message #447770 is a reply to message #447759] Wed, 17 March 2010 15:39 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Thanks for quick response.

>>Where are you restoring from? Local disk/tape or from remote disk?

Disk

>>Restore and recover or just restore?

Restore & Recover

>>How many datafiles?

58

>>32 bit or 64bit?

64bit

>>Large pool size?

Accidentally large pool size was 0 & sga_max_size 1g

>>How long did it take to backup?

Full backup taken 3:30hrs
Re: Restore Performance [message #447929 is a reply to message #447770] Thu, 18 March 2010 09:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
In URL already specified,
There should be a couple of views that oracle recommends to check to identify the bottlenecks.
Also check in alert.log for any specific memory related errors.
As you already know, applying archive logs could take some time.
May be the restore process is just stuck somewhere.
Can you afford to startover?
I have seen similar issues with SAN mounted disks and issue was related to san buffers. May be not in your case.
Also Metalink has a many writeups on "slow rman" and most of them are bugs.
Re: Restore Performance [message #447939 is a reply to message #447929] Thu, 18 March 2010 10:38 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thanks Mahesh,

Yes as per your link am going to test again restore performance.

In alert log i did not not found any issues. Even after a week restore/recover done

Also i am checking some metalink doc & update you soon once i got.

Babu
Previous Topic: Backup using OEM error
Next Topic: Recover database on the other host
Goto Forum:
  


Current Time: Fri Mar 29 10:14:42 CDT 2024