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
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you implement fine-grained auditing?
What is transparent data encryption? : sql server DBA
when does an alert gets signaled?
What is replication? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you enable flashback feature?
How would you best determine why your MVIEW couldn't FAST REFRESH?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the default port no on which sql server listens? : sql server DBA
what is the diffrence between core dba and apps dba?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is the use of ocr?