Topic: Database Administration >> Database Switching
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Database Switching |
| Tony |
Posted: Apr 05, 2007 09:00:47 AM |
Total Post: 26
Joined: Dec, 2006
|
Hi There
I nedd a little bit help on database switching
How can one change from one database to the other. I tried using the following command
set ORACLE_SID=Oracle_Cat
in the command prompts of the oracle user and i quearied the v$database to see if the DB name has changed but nothing happened. I have 2 DBs; Traindb and Oracle_Cat which the latter i want it to use as the recovery catalogue database.
Please help
tonygys@yahoo.co.uk |
|
|
 bigPapas |
| Posted: Apr 05, 2007 09:48:56 AM |  |
|
Total Post: 14
Joined: Apr, 2007
|
Create a control file to trace,
alter database backup controlfile to trace;
Then find and rename the trace file to something readable.
Clean up the trace file to delete extra lines with # or REM,
Now add the set command, and change the SID to the new sid you wish to create: example....
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE set DATABASE "NEWSID" RESETLOGS ARCHIVELOG
... data file list ...
CHARACTER SET ...
;
save new control/trace file.
at O.S. level, Change the ORACLE_SID to the sid you wish to create.
then sqlplus '/as sysdba' and run the control/trace file. then alter database open resetlogs.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
