{"id":2338,"date":"2012-01-06T09:00:49","date_gmt":"2012-01-06T17:00:49","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/2338\/backup-topteam-oracle-database-schema\/"},"modified":"2016-07-26T04:48:06","modified_gmt":"2016-07-26T11:48:06","slug":"backup-topteam-oracle-database-schema","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/2338\/backup-topteam-oracle-database-schema\/","title":{"rendered":"Backup TopTeam Oracle Database Schema"},"content":{"rendered":"
<\/div>\n
\n
\n

Overview<\/h3>\n

TopTeam Database is a critical part of TopTeam Application Server.
\nIt is important that database backups are done regularly and often.
\nIn the event of a System failure, you will be able to restore your database files from the saved backups.<\/p>\n<\/div>\n

\n

What is this article about?<\/h3>\n

In this article, you will learn how to backup TopTeam Oracle database schema.<\/p>\n

There are multiple ways to backup an Oracle database. You will learn how to run a hot backup which means backing up the database while users are still connected and editing within the system.<\/p>\n

Refer to articles on Oracle Backup on the Microsoft website and identify which backup mechanism is best suited for your organization.<\/p>\n<\/div>\n

\n

About Oracle Export Utility<\/h3>\n

Oracle provides multiple ways to Backup your data. One of the techniques that we will elaborate here is through the Export utility:<\/p>\n

Exporting –\u00a0Copying database data to external files for importing into another Oracle database. The files are in a proprietary binary format.
\nImporting –\u00a0Copying data into Oracle database from external files that were created by exporting data from another Oracle database.<\/p>\n

You can use the Export Utility of Oracle to take backups <\/em>of database schema.
\nThe Export utility provides a simple way to take backups or transfer data between Oracle databases.<\/p>\n

Export dump files<\/em> can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the\u00a0Export utility used to create the dump file<\/em>.<\/p>\n

Invoking Export Utility in the Oracle Database –\u00a0You can invoke Export Utility and specify parameters by using the\u00a0Command Line Entries<\/em> methods. It is an\u00a0interactive <\/em>mode of exporting data.<\/p>\n<\/div>\n

\n

Who should read this?<\/h3>\n
\n
\n
    \n
  • System Administrators<\/li>\n
  • Database Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n
    \n

    Preparations<\/h3>\n

    1. Identify which TopTeam Oracle database you want to backup and connect.<\/p>\n

    2. Ensure that you know the TopTeam database schema username and password.<\/p>\n

    3. Ensure that Oracle Client compatible to Oracle Server version is installed on the computer on which the\u00a0Export utility<\/em> will run.<\/p>\n

    4. Ensure that there is a sufficient hard disk space available so that a backup file can be created.<\/p>\n

    5. Ensure that you have write access on the disk on which you want to take a backup.<\/p>\n<\/div>\n

    \n

    Step 1. Start Export Utility from Oracle<\/h3>\n

    \"media_1278312231327.png\"<\/p>\n

    1. Go to Start <\/strong>button on the Taskbar. Select “Run” from the Program menu.<\/p>\n

    2. Enter “exp” in the Run window to start Oracle Export Utility.<\/p>\n<\/div>\n

    \n

    Step 2. Enter Username and Password for Oracle Database Schema<\/h3>\n

    \"media_1278061112909.png\"<\/p>\n

    Enter Username, Password and Host String of Oracle database schema which you wish to backup.<\/p>\n<\/div>\n

    \n

    Step 3. Specify buffer size<\/h3>\n

    \"media_1278061162790.png\"<\/p>\n

    \n
    \n

    Specifies the size in bytes of the buffer, which is used to fetch rows. As a result, this parameter determines the maximum number of rows in an array fetched by Export.
    \nIf you specify zero, the\u00a0Export utility<\/em> fetches only one row at a time.
    \nPress Enter so that the data is exported up to maximum length.
    \nThe FILESIZE parameter has a maximum value equal to the maximum value that can be stored in 64 bits.<\/p>\n

    Maximum Size for Dump Files:<\/em><\/p>\n

      \n
    • For\u00a032-bit<\/em> Operating System, maximum size is\u00a02 gigabytes<\/em>.<\/li>\n
    • For\u00a064-bit <\/em>Operating System, size is\u00a0Unlimited<\/em>.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n
      \n

      Step 4. Specify location to save the Oracle Schema Export<\/h3>\n

      \"media_1278061343931.png\"<\/p>\n

      Specify the destination location to which you wish to save the exported database. It creates a file with “DMP”<\/strong> extension.<\/p>\n<\/div>\n

      \n

      Step 5. Specify option to Export User<\/h3>\n

      \"media_1278061382201.png\"<\/p>\n

      Specify this parameter value as “U”, i.e. you want to export the User Schema.<\/p>\n

      By default, it selects User that means all the tables and its data gets exported.<\/p>\n<\/div>\n

      \n

      Step 6. Access Grant<\/h3>\n

      \"media_1278061593487.png\"<\/p>\n

      Default Value: yes
      \nSpecifies whether or not the Export utility exports object grants. The object grants that are exported depend on whether you use full database mode or user mode.
      \nIn\u00a0full database mode<\/em>, all grants on a table are exported, whereas in\u00a0user mode<\/em>, only those granted by the owner of the table are exported. Note that the\u00a0System privilege grants<\/em> are always exported.<\/p>\n

      Press enter to use default value.<\/p>\n<\/div>\n

      \n

      Step 7. Grant access to Export Table Data<\/h3>\n

      \"media_1278061631103.png\"<\/p>\n

      Press enter to use default value, i.e. “Yes”.<\/p>\n<\/div>\n

      \n

      Step 8. Compress the content<\/h3>\n

      \"media_1278061655546.png\"<\/p>\n

      Specifies <\/strong>how Export and Import manage the initial extent for table data.<\/p>\n

      The default, COMPRESS=y<\/strong>, causes Export to flag table data for consolidation into one initial extent upon import. If extent sizes are large (for example, beacuse of the PCTINCREASE parameter), allocated space will be larger than the space required to hold the data.<\/p>\n

      Default: y<\/strong><\/p>\n

      Enter “yes” to compress data.<\/p>\n<\/div>\n

      \n

      Step 9. Log generated for export on Command Prompt<\/h3>\n

      \"media_1278061675297.png\"<\/p>\n

      \n
      \n

      The oracle database schema is exported to the desired location with\u00a0DMP\u00a0extension.
      \nKeep this backup on a hard disk or write it on any electronic media.<\/p>\n<\/div>\n<\/div>\n

      \n
      \n

      Revised: March 2nd 2015<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

      <\/div>\n","protected":false},"excerpt":{"rendered":"

      Overview TopTeam Database is a critical part of TopTeam Application Server. It is important that database backups are done regularly and often. In the event of a System failure, you will be able to restore your database files from the saved backups. What is this article about? In this article, you will learn how to backup TopTeam Oracle database schema. There are multiple ways to backup an Oracle database. You will learn how to run a hot backup which means backing up the database while users are still connected and editing within the system. Refer to articles on Oracle Backup <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[80,281,7],"class_list":["post-2338","post","type-post","status-publish","format-standard","hentry","category-database","tag-backup","tag-database","tag-oracle"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-BI","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=2338"}],"version-history":[{"count":13,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2338\/revisions"}],"predecessor-version":[{"id":26135,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2338\/revisions\/26135"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2338"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}