RE: Database refresh problem

  • From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
  • To: <nileshkum@xxxxxxxxx>, "Bradd Piontek" <piontekdd@xxxxxxxxx>
  • Date: Mon, 9 Nov 2009 18:29:41 -0000

If you are using RMAN duplicate command to clone from 10203 production database 
backup to 10204 test database. Then it will not work. This is because duplicate 
command at the end issues "alter database open resetlogs", which you can not 
issue on a 10203 database files with 10204 software binaries.
What you need is install 10203 software on test system. DUPLICATE test database 
using 10203 binaries from production 10203 backup. Then upgrade it the usual 
Or, if you are not duplicating, then follow following steps.
using 10204 binaries on test server
restore datababase; -- from 10203 production backup.
recover database ;  -- upto desired point in time
open database in ugprade mode
run catupg.sql
Vishal Gupta   


From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of nilesh kumar
Sent: Mon 09/11/2009 17:43
To: Bradd Piontek
Cc: Mark W. Farnham; ORACLE-L
Subject: Re: Database refresh problem

Yes, I restore the control files and datafiles from tape using RMAN and it is 
not the cold backup. Yes I am using RMAN  for refreshing.

On Mon, Nov 9, 2009 at 8:53 AM, Bradd Piontek <piontekdd@xxxxxxxxx> wrote:

         This is pure speculation, but it looks like you are restoring / 
duplicating using RMAN. (maybe not). you may need to issue a 'recover 
database'. How did you 'restore the controlfile and datafiles'? 
        What is 'compatible' set to in the source database? 

        Bradd Piontek
          "Next to doing a good job yourself, 
                the greatest joy is in having someone 
                else do a first-class job under your  
         -- William Feather 

        On Mon, Nov 9, 2009 at 10:47 AM, nilesh kumar <nileshkum@xxxxxxxxx> 

                Hello Mark,
                I am on solaris box. I restored the control file, datafiles not 
the software ie binaries of 10g and logs also. I am trying to open the database 
in command prompt before to that i have also recovered the database. but when I 
issue the alter database open resetlogs it shows me every time as system 
file(.dbf) needs recovery. Checked the alert log also same message. 
                I got to know the production database was and test 
database was of Do I need to login to database home and then 
try recovering and then do the upgrade to afterwards ??

                On Mon, Nov 9, 2009 at 6:15 AM, Mark W. Farnham <mwf@xxxxxxxx> 

                        Tell us a little more. When you say "I have restored 
every thing from the production to Test" do you mean all the datafiles and 
such, or do you also mean the software?


                        How are you trying to open the database? OEM, sqlplus, 
something else?


                        What operating system are you on?


                        And the big one: Exactly what problem are you having? 
Is there an error message? Does it just hang? Have you looked in the alert log 
or otherwise explored the log and trace files?


                        That would be a good start to help us help you.







                        From: oracle-l-bounce@xxxxxxxxxxxxx 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of nilesh kumar
                        Sent: Monday, November 09, 2009 9:01 AM
                        To: ORACLE-L
                        Subject: Database refresh problem


                        Hello DBA's,


                        Good Morning!!

                        Hoep everyone is doing a great job.


                        I am stuck in middle of database refresh activity. I 
just got to know that the target Production database which I was refreshing was 
of version where as the earlier database on test machine was 
I have restored every thing from the production to Test. But I am facing the 
proble while I open the database. How should I solve this please help.




Other related posts: