Interested to Buy Any Domain ? << Click Here >> for more details...
by issuing "alter tablespace begin backup;" what happens to
tablespace?
- 5 Answers
- 9284 Views
- CSC, Logica CMG, I also Faced
- E-Mail Answers
Answer Posted / ravindra
When alter tablespace begin backup?
Ans:Oracle will write all changes to the datafile by rising
checkpoint and freezes the datafile header with latest SCN.
and backup will take upto latest SCN and transactions are
updating to datafiles also changes will be generate many
archivelogs because all changed transactions information
written to Redologs.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
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?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Explain about your sql server dba experience? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is a correlated sub-query? : sql server DBA
how can you enable flashback feature?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Explain materialized views and how they are used.
how to restore files with rman?
What is dcl? : sql server DBA
Query processing is slow(eg select query)how will u solve that
how can you get actual data change values from previous transactions in oracle?
