The faster Oracle method to export on Sun Enterprise Servers, contain information about very fast Oracle database exports by taking advantage of parallel processing on SMP machines. At QUALCOMM, the IT staff routinely runs this script on Sun Enterprise servers to perform an export of a 250 GB database in about two hours. Oracle provides features that support physical backup/restore as well as logical backup/restore. The physical backup/restore features are the normal hot and cold backups, where you simply take static images of the database files (although the hot backups are not quite static). xport all of the data, one table at a time. There might be thousands of tables in the database. The list_tbls Script This SQL*Plus script serves as an example of how to create a file of commands that can be used by the paresh script. There are many different approaches. This code is executed by the top level process only. It # parses the arguments and spawns the appropriate number # of slaves. Note that the slaves run this same shell file, # but the slaves execute different code, based on the # exported variable PARESH.
Tags : sun enterprise servers, cold backups, logical backup, oracle data, data migration, smp machines, oracle database, static images, parallel processing, database files, qualcomm, slaves, oracle, sql, shell
If you see unrelated pdf files with the description or copyrighted material published, please report to us, we'll correct/delete it it as soon as possible.NONE OF THOSE MATERIALS ARE HOSTED IN THIS SERVER NOR UPLOADED BY ME IN SOMEONE'S SERVERS. Read our DISCLAIMER for more detail.
We are neither affiliated with authors and brands nor responsible for its content and change of content.
Information contained herein is provided "as is" without warranty of any kind, either expressed or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall ANYONE be held liable for any loss of profit, special, incidental, consequential, or other similar claims.