Interested to Buy Any Domain ? << Click Here >> for more details...
If we issue alter database begin backup. What happens to database?
- 2 Answers
- 7279 Views
- I also Faced
- E-Mail Answers
Answer Posted / raj
it locks the header #SCN number of the datafiles and
datafiles will be updated continuously.
If the db is coming out from begin backup mode it updates
the header #SCN number.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
Explain about your sql server dba experience? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Where would you look for errors from the database engine?
how can you implement fine-grained auditing?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you enable flashback feature?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what are the benefits of flashback feature?
Where do you find the default index fill factor and how to change it? : sql server DBA
what is a user-defined lock?
how can you get actual data change values from previous transactions in oracle?
