| Home | Current Systems | Former STK Products | EOL Systems | Components | General Info | Search | Feedback |
| Oracle System Handbook - ISO 7.0 May 2018 Internal/Partner Edition | ||
|
|
||
 |
||||||||||||
Solution Type Technical Instruction Sure Solution 1568662.1 : How to Move a Database to Another Home Directory on ODA
ODA has it's own tools to create Oracle Home and Oracle Database. So this is the way to move Oracle Databases between the same version Oracle Home Created from <SR 3-7184408661> Applies to:Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]Oracle Database Appliance Software - Version 2.1.0.1 and later Information in this document applies to any platform. GoalMove databases between existing Oracle_homes that are exactly at the same patch level. SolutionIn this example we move a database movedb from OraDb11203_home6 to OraDb11203_home2. Step 1 - Check the patch level of the Oracle_Homes: # oakcli show dbhomes Oracle Home Name Oracle Home version Home Location We must ensure both Oracle_homes are at exactly the same patched version. Otherwise stop as you cannot move database between different version Oracle Homes.
Step 2 - Verify the database version and current home: # oakcli show databases
movedb RAC OraDb11203_home6 /u01/app/oracle/product/11.2.0.3/dbhome_6 11.2.0.3.5(14727310,14727347) (so we verify movedb is hosted out of home 6 and double check the version is the same as home 2)
Step 3 - Using srvctl move the database: srvctl modify database -d movedb -o /u01/app/oracle/product/11.2.0.3/dbhome_2
Step 4 - Restart related database: $srvctl stop database -d movedb
$srvctl start database -d movedb Step 5 - Double check the Oracle_Home has moved: # oakcli show databases
movedb RAC OraDb11203_home2 /u01/app/oracle/product/11.2.0.3/dbhome_2 11.2.0.3.5(14727310,14727347)
Attachments This solution has no attachment |
||||||||||||
|
||||||||||||