Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create an new instance from Hot Backup
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
![]() |
![]() |