- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Relication error
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 06:38 PM
тАО07-12-2004 06:38 PM
I'been trying to restore my web prod db to a dev/t server(with the same specs). I've already have backup. When i'm in the part of restoring the database everythings fine. Oracle is now available, but when i 'tried accessing a it by using a web browser, it doesn't show anything. When i tried searching for errors, I've got an error stating 'ORA-01110: data file 8: '/opt/u01/app/oracle/product/8.1.7/dbs/MISSING00008' .
After getting this message I've tried restoring again the prod db and edit ccfile and add in that directory above. after executing ccffile.sql in svrmgrl, i"ve got a message "CREATE CONTROLFILE REUSE set DATABASE "DMXTEST" RESETLOGS NOARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name DMXPROD in file header does not match given name of DMXTEST
ORA-01110: data file 8: '/opt/u03/oradata/data01.dbf'
Help pls.
thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 06:52 PM
тАО07-12-2004 06:52 PM
SolutionAre you able to start the oracle with
svrmgrl
connect internal
startup;
What is the content of alert_SID.log
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 06:57 PM
тАО07-12-2004 06:57 PM
Re: Relication error
What is ccfile and ccffile.sql and their role? What changes you made?
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 07:10 PM
тАО07-12-2004 07:10 PM
Re: Relication error
even select a v$session, v$database, v$controlfiles.But i've noticed after querying a datafile,I've seen this one on the datfiles table.
"'/opt/u01/app/oracle/product/8.1.7/dbs/MISSING00008'" .
2nd ccf ccfile.sql is the create controfile file of my new DB.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 07:25 PM
тАО07-12-2004 07:25 PM
Re: Relication error
Cause: The database name given at the command line does not match the database name found in the file header.
Action: Chance are good that the database name specified at the command line is incorrect. Resolve the discrepancy, and resubmit the command. If you are attempting to change the database name, be sure to use the SET DATABASE option.
It seems that Oracle database was not open (as you have mentioned). The database was only mounted.
In the mount stage you can query dynamic performance views i.e. v$.. views.
sks