What is a logical backup? Logical backups are backups in which the export utility (for example Exp) uses SQL to read database data and then export it into a binary file at the operating system level. You can then import the data back into a database using the import utility (Imp).The Oracle Export Utility can […]
Monthly Archives: May 2017
Backup
In the 24/7 working environment, any organization requires database available all time. In business world, there are three type of users (Top Management(C.E.O, Board of Directors etc), Technical user(DBA, Developers etc.)/Non -Technical user(Hr , C.A, Market department etc.), End Users(Customers) )who interact with database any organization according to their roles and privileges. N number of activity done by them […]
raccli create backup
The create backup subcommand of the raccli creates a backup of the configuration files, inventory configuration files, Grid Infrastructure and Oracle Database home, database, and tooling metadata of an Oracle Database Cloud Service database deployment that uses Oracle Real Application Clusters (RAC). raccli create backup [-tag tag-name] -tag tag-name : The name of the backup […]
raccli clean backup
The clean backup subcommand of the raccli utility deletes any unnecessary backups or backup pieces as determined by the backup configuration’s recovery windows for local and cloud backups. raccli clean backup [-force]
raccli Utility
The raccli utility is provided on Oracle Database Cloud Service deployments that use Oracle Real Application Clusters (RAC) to perform a variety of life-cycle and administration operations. Using the raccli utility, you can perform operations like: Backing up the database Recovering the database from a backup Changing configuration of automatic backups Patching the Oracle Database, […]
Index (B-tree)
B-tree Index B-tree stands for Balanced Tree in RDBMS. It is commonly used in database and filesystem.The B-tree enables the database to find a leaf node quickly. It is a good example of a data structure for external memory. Telephone directory, library are the best example of B-tree index. Why do we use B-tree? keeps keys in […]
IOT
IOT Index IOT stands for Index Organised Table in oracle database.The idea behind an IOT is simple. You hold all the data for the table in the ordered structure of an index. Why do we use IOT? An IOT has the structure of an index and stores all the columns of the row, accesses via […]
Index In Oracle
We are living on the planet with the seven billion population.Each and every human being’s have some information. Data is an important factor in the business’s world. Every day in business’s operation we deal with data. It can be structure and un-structure data. All the report of business prepare with the help of data. We take a […]