Logical backup’s reg & incr exports

Screenshot_88

 

  1. logical backup [using export utility] works as an alternative backup method.
  2. The beauty of export is we can be selective [either at export or at import]
  3. We can export from one user and import into another within the same database

 

Screenshot_89

 

  1. We can export from one database and import into another database [both source and target databases are ORACLE datgabases]

 

Screenshot_90

  1. When migrating from one platfarm to another from WINDOWS to SUN SOLARIS then export is the only method to transfer the data [at least up on till 9i] since C/R/D files from the source can not be copied over to the target as file system are different types.

 

Screenshot_91

 

  1. WINDOWS PLATFORM SUN SOLARIS PLATE
  1. When upgrading ORACLE software, as a precaution, we can export of full database before the upgrade. If the upgrade utility able to successfully upgrade software as well as the database then its o.k., but Incase if software upgrading is successful where as data base up gradation has failed then we can still use the exported file which we did before the up gradation, so that we can bring back all the data.
  2. Over a period of time [3 to 4 months] as the data based get fragmentation, being a DBA we used to go for REORG, which includes
    1. Export full database
    2. Drop the existing database
  • Recreate an empty database with all the required table spaces
  1. Import full data

The dump file is 8 to 10 times smaller than database even though we did full export. The reasons are

 

Screenshot_92

 

  1. No base tables are exported into target database.
  2. No control or redo log files rare exported into the target database.
  3. No temp table space is exported
  4. No undo segments since they contain before image.
  5. From user-index only definitions are exported but not the data.
  6. Original data                 10 gbTables are exported with data but they may have 50% free blocks and also 70% pot free

Really used data               2.7 gb [ 10% pot free]Use data                              3 gb [ 50% of occupied]
Occupied data                   6 gb

 

Screenshot_93

 

ddl
+
dml
[uses undo+ lots of log switches
imports takes 6 to 8 times than exports]

advantages of exports

  1. works for an alternative backup solutions.
  2. Selective exports or imports are possible
  3. Can copy objects
    1. One user to another user
    2. From one database to another database
    3. From one OS to another OS export files are platform independent.
    4. From one version to another version
  1. Database reorganization [ every 3 to 4 months]
  2. ORACLE up gradation

 

 

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Logical backup’s reg & incr exports"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please leave a message and we'll get back to you soon.
    Three + 6