topic Re: Restoration error in Operating System - HP-UX

Restoration error

Allan Palma Faylona — Tue, 13 Jul 2004 04:46:09 GMT

help!!
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

Re: Restoration error

Fred Ruffet — Tue, 13 Jul 2004 04:51:08 GMT

On the second try, did you restore only the missing file or the whole DB files ?

Regards,

Fred

Re: Restoration error

Sanjay Kumar Suri — Tue, 13 Jul 2004 04:52:55 GMT

First time you ran @/ids/ora/ccfdmxtest.sql and now @ccffile.

Are they same and do the same thing?

sks

Re: Restoration error

Sanjay Kumar Suri — Tue, 13 Jul 2004 05:04:35 GMT

My suggestion is that you repeat all the steps (copying everything). Don't miss out anything.

Oracle needs all the datafiles, redo files, control files at their proper location (as saved in the control file) to start.

sks

Re: Restoration error

Allan Palma Faylona — Tue, 13 Jul 2004 05:16:05 GMT

On the 2nd try, I've included the missing file together with all all oracale files such as controlfiles, datafiles, logs, and even arch files, and place them in their right locations.

Re: Restoration error

Sanjay Kumar Suri — Tue, 13 Jul 2004 05:33:23 GMT

Check the create controlfile statement. Are you using this as suggested in your previous thread?

sks

Re: Restoration error

Eric Antunes — Tue, 13 Jul 2004 07:07:08 GMT

Hi,

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!

Re: Restoration error

Eric Antunes — Tue, 13 Jul 2004 07:11:48 GMT

The best way to do this is to put it on a sql script (without the recover and open commands!) and running it as sys user. After that, run the RECOVER DATABASE command and ALTER DATABASE OPEN RESETLOGS...

Re: Restoration error

Yogeeraj_1 — Tue, 13 Jul 2004 07:45:39 GMT

hi,

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