| Prabir |
Posted: Feb 21, 2006 04:50:35 AM |
Total Post: 4
Joined: Feb, 2006
|
When a tablespace is under backup mode, what happens to the users who have already logged in trying to run a select quary.
Can new user login to the database when any tablespace is in backup mode ?
Can we reade any trace file using wordpad in windows ?
|
|
|
 Ravindra |
| Posted: Feb 24, 2006 11:28:47 AM |  |
|
Total Post: 60
Joined: May, 2005
|
Hi
There is no impact on user connections when a ts is in begin backup mode. They can do all DML with comfort.
Ravindra Nookala
|
|
|
|
|
| asu |
| Posted: Jan 03, 2007 07:53:15 AM | |
|
Total Post: 9
Joined: Sep, 2006
|
There is no problem to users who are logged in they can select and perform DML operations also .
The only problem is that there will be excessive redo so the performance will go down .
New users can log in .
Regards asu
|
|
|
|
|
| mani |
| Posted: Jan 16, 2008 03:58:10 AM | |
|
Total Post: 6
Joined: Jan, 2008
|
No problem........to the users...
only more redos generated. performance will be slow.
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:41:54 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
Users who are establishing fresh connections wont be affected.Backup is inconsistent.
incrmental backups is used for this purpose.
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
