> In previous messages I read this:
> "Helen Borrie" <helebor@...> wrote in message
> news:5.2.0.9.2.20060111082854.08b93ff8@......
> > At 01:49 PM 10/01/2006 -0500, you wrote:
> > At a guess, some user is trying to connect to the database during the
> > restore! When gbak comes to create the foreign key metadata, it can't,
> > because the table is already in use. Ach! this is not a healthy thing!
> My question is:
> If I Shutdown the database before back-up and if some user try to
> connect to
>
> database during restore, this will generate error on restore
> procces or will
>
> error to user and denie this user to connect to database?
>
> TIA
> Paul

good question - you can test it easily, but for I don't even go there.
if you are backing up and restoring in the same cycle (very infrequent
exercise - backup and test restore to another filename is more frequent -
which doesn't require these steps at all).
1. shutdown db if you want - or warn everyone first and stop the server.
2. rename the file to be backed up
3. start server for other processes
4. backup new filename to backup filename
5. restore backup file to new new filename
6. rename restored file (new new filename) to original filename - all users
can connect

much much safer
Alan