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

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

Describe what redo logs are.

1 Answers  

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers  

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

how can you enable flashback feature?

0 Answers   Oracle,

What is the difference between LMT & DLT?

1 Answers   CTS,

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

how can you process messages in order asynchronously?

0 Answers   Oracle,

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

Datapump backup steps?

1 Answers