1745797 Members
3767 Online
108722 Solutions
New Discussion юеВ

Re: Restoration error

 
SOLVED
Go to solution
Allan Palma Faylona
Contributor

Restoration error

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

8 REPLIES 8
Fred Ruffet
Honored Contributor
Solution

Re: Restoration error

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

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Sanjay Kumar Suri
Honored Contributor

Re: Restoration error

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

Are they same and do the same thing?

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Sanjay Kumar Suri
Honored Contributor

Re: Restoration error

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
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Allan Palma Faylona
Contributor

Re: Restoration error

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.
Sanjay Kumar Suri
Honored Contributor

Re: Restoration error

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

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Eric Antunes
Honored Contributor

Re: Restoration error

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!

Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: Restoration error

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...
Each and every day is a good day to learn.
Yogeeraj_1
Honored Contributor

Re: Restoration error

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)