| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Starting and stopping listener -fears??
Hi,
In order to do a consistent export, you don't need such drastic action as restart in restricted mode. Specifying consistent=y for exp should work. The database may generate more rollback info and even give users ORA-1555 (Snapshot too old), plus other limitations. But it's better than restart in restricted mode for most shops.
Yong Huang
yong321_at_yahoo.com
you wrote:
The cleanest method is to
"shutdown" the database and startup in the restricted mode to prevent
users from accessing the database while you are doing your exports.
ROR
>>> tzhou_at_border.co.zw 12/18/00 09:25AM >>>
Hie list,
I use export for my back ups. I want to prevent users from connecting to
Oracle while backup is proceeding. I have in mind "stopping Oracle listener"
before backup and "starting it" afterwards using
lsnrctrl stop and lsnrctrl start.
Now my fears are, since some users may be actively connected, if I use this
 |
 |