Re: delete a database
- From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 25 Jun 2014 12:48:35 -0600
On 25/06/2014 11:21 AM, Zelli, Brian wrote:
Installed 11g clean, exported and imported from 10g database.
If the 10g database is 'down', the database files and redo log files
should show the last activity being when you took it down. In that
case, you have a reasonable grounds for removing the files.
The reason we are so hesitant is that a common (perhaps 'the normal) way
of upgrading while staying on the same host is to install the new
software and tell it to 'take over' the database. That would mean, copy
the init files and possibly password files to the new s/w home and then
run 'catupgrade.sql' to make the appropriate adjustments to the data
dictionary, and then open the database using the new software. In that
case, the 'database' would be the original files and removing them would
cause an un-smiley to appear.
Remember which files make up the database: password,
init.ora/spfile.ora, control file(s), database files, redo log files,
archive log files, flashback log files, rman backup files, alert log, to
name a few.
HTH/Hans
Other related posts:
