Subject | Re: restore trouble |
---|---|
Author | fabrice.aeschbacher@khe.siemens.de |
Post date | 2001-05-17T13:22:13Z |
--- In ib-support@y..., Paul Reeves <paul@f...> wrote:
able to replace the old db with the new restored one. I don't want
the user to shutdown the db & replace the files himself.
I'll try with another user, and hope the gfix -shut will work.
Thanks
Fabrice
>there is a
> I wouldn't recommend using the -r switch to do the restore. If
> problem with the backup you will have over-written the originaldatabase before
> you discover the problem.If the
>
> Use the -c option to create a new database with a different name.
> creation is successful you can then worry about your main question -shutting
> down the database and replacing it.OK, let's use gbak -c. But once the restore is successfull, I must be
able to replace the old db with the new restored one. I don't want
the user to shutdown the db & replace the files himself.
> Are you aware that shutting down a database does not disconnectusers logged in
> as SYSDBA?No, it's a good info. All users are actually logged on as SYSDBA.
I'll try with another user, and hope the gfix -shut will work.
Thanks
Fabrice
> Paul