by issuing "alter tablespace begin backup;" what happens to
tablespace?
- 5 Answers
- 7564 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 grd?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How do you open a cluster administrator? : sql server DBA
what is a user-defined lock?
how can you implement fine-grained auditing?
how does an oracle clusterware manage crs resources?
what functionality does oracle provide to secure sensitive information?
what are the benefits of flashback feature?
what is ora 24313?what is the procedure to exclude that error?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Query processing is slow(eg select query)how will u solve that
What the different types of replication and why are they used? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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.
