This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

Backups

Difference Between Backup and Archive

By | April 12th, 2013|Backups, Database, Oracle DBA|

Backup vs Archive  The process of creating lots of data is common all the small and large businesses around the world. It is estimated that the amount of data are doubled by some companies each year. The biggest challenge the companies have with this rapid growth of data is the reliable protection of data. Data [...]

Difference Between Backup and Recovery

By | April 11th, 2013|Backups, Database, Oracle DBA|

Backup vs Recovery   The process of creating lots of data is common in all the small and large businesses around the world. It is estimated that data are doubled by some companies each year. The biggest challenge the companies have with this rapid growth of data is the reliable protection of data. Data should be [...]

Objects Exported by Type of Export

By | April 16th, 2012|Backups, Oracle DBA|

Table Mode: Table definitions  Table data  Owner's table grants  Owner's table indexes  Table constraints  Table triggers  User Mode: Table definitions  Table data  Owner's grants  Owner's indexes  Table constraints  Table triggers  Clusters  Database links  Job queues  Refresh groups  Sequences  Snapshots  Snapshot logs  Stored procedures  Private synonyms  Views  Full Database Mode: Table definitions  Table data  Grants  Indexes  [...]

General export & import Questions & Answers

By | April 16th, 2012|Backups, Oracle DBA|

Q: During an Export I receive an ORA-00904, EXP-00024 or EXP-00037 error. How do I resolve the errors? (Or, during my Import, I receive an ORA-00904 or IMP-00023 error. How do I resolve this?)  A: The views required for the export utility are either not installed or are incompatible with the version of Export =being used. [...]

Order Used When Importing Objects

By | April 16th, 2012|Backups, Oracle DBA|

There is a specific order used when exporting and importing objects. This order has been changed more than once as Oracle versions are released, and may again, but currently Oracle uses the following steps: 1. Tablespaces 2. Profiles 3. Users 4. Roles 5. System Privilege Grants 6. Role Grants 7. Default Roles 8. Tablespace Quotas 9. Resource [...]

HOT BACKUP FILE RECOVERY

By | June 12th, 2011|Backups, Oracle DBA|

Data files are not synchronized if in “hot backup” mode at time of failure. Recover the database using one of the methods already discussed. Determine what file (s) were in “hot backup” mode at the time of failure End the backup on the data files Open the DB Clearing Redo log files: - Using the [...]

Oracle Export Utility

By | June 10th, 2011|Backups, Oracle DBA|

Exports can be of three categories: 1).  Incremental Exports 2). Cumulative Exports 3). Complete Exports Incremental Exports - An incremental export backs up only the tables that have changed since the last incremental, cumulative, or complete export. For example if one row is added or updated to a table since the last incremental, cumulative, or [...]

Oracle DB – Data Pump

By | April 11th, 2011|Backups, Oracle DBA|

Introduction: The Data pump facility runs on the server side. Oracle Data pump technology enables very high-speed movement of data and metadata from one DB to another. Dump files generated by the new Data Pump Export utility  are not compatible with dump files generated by the original Export utility. Therefore, files generated by the original [...]

Oracle Database 10g New Feature: Data Pump

By | April 6th, 2011|Backups, Oracle DBA|

Introduction: Oracle 10g offers several new features, one of which is Data Pump technology for fast data movement between databases. Most Oracle shops still use their traditional export and import utility scripts rather this new technology. Data Pump technology is entirely different from the export/import utility, although they have a similar look and feel. Data [...]