Interested to Buy Any Domain ? << Click Here >> for more details...
by issuing "alter tablespace begin backup;" what happens to
tablespace?
- 5 Answers
- 9306 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 is dcl? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
internal architecture
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is the importance of a recovery model? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How to start SQL Server in minimal configuration mode?
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.
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.
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
Why would you use sql agent? : sql server DBA
what are the benefits of flashback feature?
