If we issue alter database begin backup. What happens to database?
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
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you enable flashback feature?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what are the differences of where and if in SAS?
What is the default fill factor value? : sql server DBA
what do you understand by flashback feature of oracle?
How would you best determine why your MVIEW couldn't FAST REFRESH?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is the diffrence between core dba and apps dba?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What the different types of replication and why are they used? : sql server DBA
how can you find out if a table can be redefined?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?