Interested to Buy Any Domain ? << Click Here >> for more details...
by issuing "alter tablespace begin backup;" what happens to
tablespace?
- 5 Answers
- 9466 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 differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
How would you go about verifying the network name that the local_listener is currently using?
how can you implement fine-grained auditing?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you schedule a job in database?
What types of replication are supported in sql server? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is a system database and what is a user database? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are statistics, under what circumstances they go out of date, how do you update them?
what do you understand by flashback feature of oracle?
