| Control file [message #507268] |
Fri, 13 May 2011 07:31  |
 |
orashi
Messages: 8
Registered: May 2011
|
Junior Member |
|
|
hi friends
i have an question that is While my database is up and running i want to delete one copy of control file. After that i want to recover the lost control file and bring up the database.
please give some step for that.especially control file editing i know that is seriously damage my database if it is not in the correct way.please help me
i am using oracle 11gR1
Thank you
|
|
|
|
| Re: Control file [message #507274 is a reply to message #507268] |
Fri, 13 May 2011 07:47  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
This is a useful exercise, and everyone should become familiar with the various techniques for recovery. But it can be hard to simulate.
If you are working on Unix (or Linux), it can be impossible to simulate: you can use rm to delete the file, and your database will probably remain open. This is because all rm did was delete the directory entry; the file still exists. You will get an error only after a shutdown, when you try to start up.
If you are working on WIndows, the del command will refuse to delete it because it is open. So you'll have to find some utility that will delete an open file.
An alternative approach is to try to corrupt the file. On Unix, perhaps use vi to insert a load of rubbish, and save. On Windows, I think you may be able to edit and save with notepad.exe.
|
|
|
|
|
|
|
|
|
|
| Re: Control file [message #507291 is a reply to message #507282] |
Fri, 13 May 2011 08:34 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
Oh, I see! We thought you wanted to simulate the problem. The steps for recovering afterwards are all in your Backup and Recvory User Guide, there are several techniques depending on the nature iof the damage and whether you have either an RMAN backup or a ser managed backup.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
