Topic: Database Administration >> begin backup mode
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| vikhardba |
Posted: Nov 28, 2007 02:55:30 PM |
Total Post: 85
Joined: Apr, 2007
|
Once i keep the database in begin backup mode, some 100 transactions are happening and those are belong to XXXX1.dbf,XXXX2.dbf files which are in-turn belong to YY tablespace. So, does this above transactions written to YY tablespace?
If no, can i know the reason? and please let me know the mechanism behind begin backup mode?
Anticipating your response at the earliest!!!
Regards Vikhar. |
|
|
 MOH_DBA |
| Posted: Nov 29, 2007 12:58:10 PM |  |
|
Total Post: 123
Joined: Nov, 2007
|
These Transaction will not go to the tablespace "yy", they will written and archived and after you finish the backup they will be written,
about the machanism i am not sure but you can imagine it as copying a big word file that want no one to access untill you finish.
|
|
|
|
|
| KS |
| Posted: Dec 03, 2007 05:04:22 AM | |
|
Total Post: 60
Joined: Nov, 2006
|
Hi,
Kindly check the following link for more infor about what happens when ALTER BACKUP .... command issued.
http://www.dizwell.com/prod/node/10
The Consequences of putting a tablespace into Hot Backup mode
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
