-
Backup Mode Redo Generation
Why more redos are generated when the database is in begin backup mode?
ddj1966
- May 28th, 2010
When a user managed Hot backup is executed, the tablespace or database has to be placed in backup mode. This informs the Oracle kernel that SCNs should not be updated on the datafile. i.e. the header ...
dhandapanik
- Dec 30th, 2009
During begin backup mode, the data file headers get freezed and it doesn’t get updated until the end backup. So it causes a checkpoint to the datafile. This causes all dirty blocks to be w...
-
Database size
How to see the Database size and version and RMAN size and version?
aravindhreturns
- Apr 23rd, 2010
To find the ORACLE database size, you need to make a small calculation. The result of these two syntaxes below can be used to find the total allocated size of the database:- select sum(bytes)/10737418...
-
Drop a Datafile
How to drop or delete a datafile which has been miskenly added to a tablespace?
aravindhreturns
- Apr 23rd, 2010
In most environments, this is done using Oracle Import/Export utility since certain privileges are restricted to the DBAs. Steps are below:- 1) Export the data 2) Drop the Tablespace, 3) Import the da...
