Database News You Can Use
A monthly newsletter for Oracle users
You’re invited to submit your Oracle-related questions to us at email@example.com. Include your name and telephone number in your email. If your question is answered in The Specialist next month, you will receive a free copy of our Oracle Wait Events reference poster. (US shipping addresses only).
This month’s question comes to us from Mark in San Jose, CA: We need to replace our database server hardware, and we are considering moving to a different operating system platform as well. Will we be able to move our existing database to the new server by restoring a hot or cold backup? We want to minimize down time.
Roger Schrag of the Database Specialists team responds: A hot or cold backup of an Oracle database may only be restored onto a server where the OS platform and Oracle software version match the original database server exactly. In other words, if your current database is running on HP-UX, you cannot restore a backup onto a server running Linux and expect it to work.
For databases on Oracle 9i and earlier, one supported way to move the database to a different OS platform is by using the export and import utilities. While this method does let you move an Oracle database across platforms and even across Oracle versions, it can be very slow and usually requires a lot of down time.
Oracle 10g includes enhancements to the transportable tablespace feature that allow you to transport tablespaces across OS platforms. This feature allows you to move a large database to a new operating system with much less down time than would be required for the export/import method.
The high-level steps are as follows:
For more information about transportable tablespaces and transporting tablespaces across operating system platforms in Oracle 10g, see Metalink documents 243304.1 and 291024.1.
If you missed last month’s Northern California Oracle Users Group (NoCOUG) meeting, you can still benefit from all the knowledge shared at the full-day conference. Many of the speakers have provided their presentations for viewing and download. In addition, Roger Schrag of Database Specialists held a standing-room-only session on performance tuning. Here’s a short list of what’s available on NoCOUG’s website: Oracle DBA Scripts, Articles, Tools, and More
If you’re looking to add to your library of Oracle-related information, check out Oracle-Base. It’s packed with tons of information, including dozens of DBA scripts, articles on Oracle10g, 9i, and 8i, industry news, tools and utilities, and more. It’s also a great place to find out more about Oracle on Linux. You’ll find Oracle-Base at http://www.oracle-base.com. Here is a quick sampling of a few main topics and sub-topics:
If you are looking for an introductory article on using RMAN for Oracle backup and recovery, check out the resources on orafusion.com. They’ve started a three-part series on the subject: Part one explains how to script RMAN backups, and part two discusses some recovery scenarios in detail. The focus is on Windows servers, but much of the information applies to other platforms as well. In addition, you’ll find the following and more in the Articles section of the website at http://www.orafusion.com/resources.htm:
Oracle 9i Articles