Home » RDBMS Server » Server Administration » Decommission of a 9.2.0.8 database (Solaris 10, database is 9.2.0.8)
Decommission of a 9.2.0.8 database [message #322135] Thu, 22 May 2008 10:24 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear All,

We are in the process of taking a database out as it life cycle ended. What are the steps to take a database out.

If any one has done it already or suggest some steps or provide some info, it would be highly appreciated.

Thanks.
Re: Decommission of a 9.2.0.8 database [message #322137 is a reply to message #322135] Thu, 22 May 2008 10:26 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Unplug the system & place it in the trash bin.
Re: Decommission of a 9.2.0.8 database [message #322141 is a reply to message #322135] Thu, 22 May 2008 10:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on your policy, your compliance requirements (SOX etc, if any).
For example, I am obliged to have everything for at least 7 years after the database are put to sleep.
Exact archiving methods depends on your policy.
Re: Decommission of a 9.2.0.8 database [message #322150 is a reply to message #322141] Thu, 22 May 2008 11:09 Go to previous messageGo to next message
rkl1
Messages: 97
Registered: June 2005
Member
Mr. Mahesh,

Thanks for your quick response, and I believe, we like to keep a copy of the database for certain number of years. However I like to know, what the steps are to take it out. use the DBCA or go to mount points to empty the datafiles. what dependency to be followed when taking out it.

Thanks.
Re: Decommission of a 9.2.0.8 database [message #322155 is a reply to message #322150] Thu, 22 May 2008 11:36 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>and I believe, we like to keep a copy of the database for certain number of year
That is where I was coming after and it is the one you really need to worry about. It is easy to takeout a 9.2.0.8 database.
To start with, I would try to answer these questions.
What if you need to bring back the database after 5 years?
Where can you find 9.2.0.8 media?
Will the OS support it (the future version of OS)?
...many more...

Since you are more interested in 'taking out',
using DBCA to remove the database is a simple,clean method and use OUI to remove the Oracle installation.

Previous Topic: user session resources reallocation
Next Topic: Database Connection
Goto Forum:
  


Current Time: Wed Dec 07 20:09:27 CST 2016

Total time taken to generate the page: 0.12318 seconds