Answer / kittu

by issuing above statement it freezes tablespace it won't
allow single transaction to datafile. by this time redologs are generated & excessive redologs also

Answer / 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.

Answer / 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.

Answer / suman

alter tablespace begin backup; it means we can take the
backup of tablespace in hotbackup begin backup mode will be
start

Answer / kittu

by issuing above statement it freezes tablespace it won't
allow single transaction to datafile

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

What are the recovery models for a database? : sql server DBA

0 Answers  

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

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?

0 Answers  

Why would you use sql agent? : sql server DBA

0 Answers  

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers