You _can_ do an online export of a database. Don't expect the data to be reliable, though. But we tested exports on our production systems without, you know, impacting production. Always a "good thing"(tm).
-----Original Message----- From: Linux on 390 Port [mailto:[email protected]] On Behalf Of David Boyes Sent: Thursday, December 18, 2008 10:24 AM To: [email protected] Subject: Re: Slightly OT: Converting Oracle databases to run on Linux for System z I'll add to the voices using export/import. Many table items in Oracle are stored with internal representations of the data. The export/import process converts the internal representation to something portable between systems so that you get the values you expect back when changing system architectures. Restoring a backup doesn't do that. I don't understand their fear of RMAN, though. RMAN has been the recommended backup/restore utility for Oracle for years, and it's pretty much the only supported backup/restore utility for any of the offline storage things. AFAIK, it's the only thing that can take dumps of the database while online. ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
