Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create an new instance from Hot Backup

Re: Create an new instance from Hot Backup

From: Wolfgang Breitling <breitliw_nospam_at_centrexcc.com>
Date: Tue, 18 May 1999 14:50:23 GMT
Message-ID: <T0g03.39291$134.362758@tor-nn1.netcom.ca>


In article <o47Y2.117$03.3637_at_weber.videotron.net>, <stephane_bouchard_at_videotron.ca> wrote:
>Hi,
>
>We are currently using Oracle on Windows Nt, and i have a scheduled job that
>run every day and take an online backup of the database and the control
>files. We want to create a TEST environmenent from the hot backup, and it
>has to be created on the same server. Can someone point me on how to do this
>( a procedure to follow or a web site which contains informations), i did it
>several time with a cold backup and everything worked fine, but now it
>always give me an error of
>'ORA-01503 Create Control file failed'
>'ORA-01200 actual file size of 7040 is smaller than correct size of 93440
>blocks.' I did looked everywhere but it is not documented so please i need
>help.
>

I had the same problem. Oracle seems to be unable to reuse an existing controlfile on NT. Try deleting (or renaming) the controlfiles and remove the reuse from the create controlfile command. Received on Tue May 18 1999 - 09:50:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US