Topic: Backup & Recovery >> COLD BACKUP.....................It`s very urgent
|
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: COLD BACKUP.....................It`s very urgent |
| soku |
Posted: Jul 03, 2009 07:50:47 AM |
Total Post: 35
Joined: Nov, 2007
|
My production database(Oracle 10g) is on RHEL AS 4.0 64bit
My Newiable server is same as Proudction(same directory structure)
I am trying to restore latest Production cold backup in another newiable machine same as production.
When I tried to start Oracle, I got the following error:
ORA-00205: error in identifying controlfile, check alert log for more info.
Actually, there are three control files in the file, spfile$ORACLE_SID.ora. So, I do not know why this error should arise. I also checked the control files in the appropriate directory and they do exist,
In alret log file I have get the following errors
ORA-00202: control file : '/usr/oracle/oracle/product/10.2.0/oradata/proddb/control01.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information : 3
I am a newbie to Oracle and DBA in general.
Here is the procedure I used to connect in detail:
|
|
|
 Gitesh |
| Posted: Jul 11, 2009 02:56:38 PM |  |
|
Total Post: 515
Joined: May, 2005
|
Hi,
Controlfile is missing.Check exact location with same of controlfile on disk. Beware linux is case sensetive for file and directory structure.
Thanks and regards,
Gitesh Trivedi
www.dbametrix.com
|
|
|
|
|
| mann |
| Posted: Jul 29, 2009 04:11:07 AM | |
|
Total Post: 41
Joined: Mar, 2009
|
yes as he rightly said check all the location specially the primary one and check for the controlfile names and in which case its mentioned
|
|
|
|
|
| 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 |
| menon srivalsala kumar | 639 |
| positive fanatic | 615 |
| Gitesh Trivedi | 515 |
| Jayanta Sur | 480 |
| Vinoth Kumar | 436 |
| Vigyan Kaushik | 398 |
| Gopu Gopi | 364 |
| Vishant Sanghavi | 346 |
|
|
