I just wanted to make sure of the process of creating a new database from a full export. We're moving from 8.0.5 to 8.1.6, and since the sysadmins are slow to respond I figured it was easiest to have them just install the software without me, and I can do the rest of the configuring and database creation from the oracle account.
After the software is in it's new ORACLE_HOME, a quick reference of what I need to do is (I'll be laying out exact procedures later today)
1) take a full export of the current database (consistent=y, full=y). actually in my case consistent wouldn't really be required since all apps and users wouldn't be doing any work, but in general i would assume it's important.
2) sysadmins install the software
3) create the new database and all related steps (catalogs, default tablespaces, redo logs, rollbacks, verify init.ora parameters, etc)
4) import the database.
the overview seems simple enough, i'll start working on the exact details. does anyone have any gotchas to watch out for, helpful tips, etc?
our database has a lot of datafiles (from oracle applications). with the straight insert, i understand that they will be recreated with the same path and storage parameters as they were inititally? i suppose that means moving them from their current location, and letting import re-create them?
should i create a large rollback for the import?
thanks for any information.