- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Restoration 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 09:46 PM
тАО07-12-2004 09:46 PM
here is the scenario.
1. I've made a cold backup of web prod, using ftp, cause my server does not have a tape drive.
2. When i tried restoring my prod db to test db, oracle started. I use this command
"startup nomount pfile=/ids/ora/initdmxtest.ora;"
statement was processed.
2nd command"@/ids/ora/ccfdmxtest.sql;
where ccfdmxtest.sql is my create controlfile.
statement was processed
3alter dataabse open resetlogs;
statement processed.
4.try to log on to sqlnav.
execute a select command, I'view a table.
but when i tried using my browser i can't access the files.
when i look into dba_data_files table in oracle
one file was missing. so i tried restoring the db again and at this point i add the missing file in my create controfile.
Then i start again the db with the above command. When I'm going to execute the @ccffile, it prompts a error 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: '/dbs1/ora/data01.dbf'
the data01.dbf is the one the i forgot to add in my first replication. I add that file in my second replication and that error pops up.
thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 09:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 09:52 PM
тАО07-12-2004 09:52 PM
Re: Restoration error
Are they same and do the same thing?
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 10:04 PM
тАО07-12-2004 10:04 PM
Re: Restoration error
Oracle needs all the datafiles, redo files, control files at their proper location (as saved in the control file) to start.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 10:16 PM
тАО07-12-2004 10:16 PM
Re: Restoration error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 10:33 PM
тАО07-12-2004 10:33 PM
Re: Restoration error
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 12:07 AM
тАО07-13-2004 12:07 AM
Re: Restoration error
After copying all the db, redo and log files to the correct destination, you must do STARTUP NOMOUNT first. See the follwing:
# WHERE THERE IS /.../ SPECIFY THE CORRECT PATH...
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE SET DATABASE "dmxtest" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 150
MAXINSTANCES 1
MAXLOGHISTORY 680
LOGFILE
GROUP 1 (
'/.../DMXTEST/log01a.dbf',
'/.../DMXTEST/log01b.dbf'
) SIZE 10M,
GROUP 2 (
'/.../DMXTEST/log02a.dbf',
'/.../DMXTEST/log02b.dbf'
) SIZE 10M
DATAFILE
'/.../DMXTEST/system01.dbf',
'/.../DMXTEST/rbs01.dbf',
'/.../DMXTEST/temp01.dbf',
...
;
# THE RECOVER COMMAND MAY RETURN AN ERROR BUT YOU SHOULD CONTINUE ANYWAY...
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
Hope this will help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 12:11 AM
тАО07-13-2004 12:11 AM
Re: Restoration error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 12:45 AM
тАО07-13-2004 12:45 AM
Re: Restoration error
very important that you backup and restore the same "snapshot" of data files.
I would still prefer to use RMAN to do such operations...
good luck
regards
Yogeeraj