by issuing "alter tablespace begin backup;" what happens to
tablespace?
Answer Posted / naveen
when u place a tablespace/database in backup (restore) mode(usually it's better idea to place only one tablespace at a time, as more logging is written, it should be done during a low activity period. And for the same reason, it is better to place the tablespaces one after one instead of putting all the tablespaces in backup mode)
when u alter the tablespace in begin backup mode - The datafile header is frozen so that whenever tablespace/datafile is copied, it reflects the checkpointSCN that was at the beginning of the backup. Then, when the copy will be restored, Oracle knows that it needs to start recovery at that SCN to apply the archived redo logs.This is to avoid the header inconsistency issue.That means that any further checkpoints do not update the datafile header SCN (but they do update a 'backup' SCN).
Each first modification to a block in buffer cache will write the full block into the redolog (in addition to the default behaviour that writes only the change vector).
At checkpoint the datafile header SCN is not updated - when updating a block, the first time it is updated since it came in the buffer cache,the whole before image of the block is recorded in redo- direct path writes do not go through the buffer cache, but they always write full blocks and then full block is written to redo log (if not in nologging)
This is to avoid the fractured block issue. There may be a fractured block in the copy, but it will be overwritten during the recovery with the full block image.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Why would you use sql agent? : sql server DBA
how can you enable flashback feature?
how can you schedule a job in database?
What is the default fill factor value? : sql server DBA
how can you communicate with operating system files from oracle?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is a user-defined lock?
what do you understand by flashback feature of oracle?
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 are the operating modes in which database mirroring runs? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
You create a private database link and upon
connection, fails with: ORA-2085: connects to
How would you best determine why your MVIEW couldn't FAST REFRESH?