| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN Restore problem
Hi Robert,
Thanks for your note on the RMAN restore.
I finally analyzed(compute statistics) the catalog schema and was able to restore within 10 mts instead of 6 hours.
Ashoke
-----Original Message-----
Sent: Friday, July 12, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
If you are using a MML, check the settings there. They can have significant
impacts on performance.
We just got done chasing a restore problem where our database was taking
about 15 hours to restore
(if at all). Finally discovered that the tapes we were using were "vaulted"
tapes. These were tapes
created after our backup for off-site purposes. When they created these
tapes, the program that
created them would interleave several tapes into the vault set. So, out 2
tape backup set becomes
a 7 tape backup set That 7 tape backupset would have the backup pieces
segmented all over the place,
and the way the MMManager was working, it would read one backup piece, and
then have to rewind
the entire tape before it could read the next.
We redid the recovery with non-interleaved tapes in 5 hours.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy.
-----Original Message-----
Sent: Wednesday, July 10, 2002 3:35 PM
To: Multiple recipients of list ORACLE-L
Ashoke - I received something like that when attempting a similar RMAN restore. This was the only thing on the target server and the server usage went to zero.
Bruce Reardon was nice enough to offer the following suggestions:
-----Original Message-----
Sent: Wednesday, July 10, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L
Greetings,
I am trying to restore a database into a new host.
The database called dsdn is originally located on dndev, catalog database is located on catserver1.
I have copied the catalog to a database called trmanrfd, which is also located on the new host server2.
Now I am trying to restore this database into a new host called server2.
It is taking 6-7 hours to restore. Ideally it should take few mintes(may be 30 mts.).
Do you have any idea, what could be the problem for slowness.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jul 12 2002 - 15:13:42 CDT
 |
 |