Skip to main content
pdf?stylesheet=default
Blackboard Help

Export the Database in an Oracle Environment

If you are a Managed Hosting customer, this topic doesn't apply to you.
 

The first step in moving the Blackboard Learn is to export the source databases. This must be done before exporting the content management databases.

Before exporting a database, place the source application server in maintenance mode and verify there is not any type of database activity. Backup and export both the file system, and the database during the same maintenance session to avoid data corruption.


Export Blackboard Learn databases

  1. Perform a schema level export for the databases using the system account and the information in the following table.
    Learn Databases to Export
    Database Name Command Dump Name
    bblearn_admin exp userid=system/manager owner=bblearn_admin buffer=2048000 file=bblearn_admin.dmp consistent=y bblearn_admin.dmp
    bblearn exp userid=system/manager owner=bblearn buffer=2048000 file=bblearn.dmp consistent=y bblearn.dmp
    bblearn_stats exp userid=system/manager owner=bblearn_stats buffer=2048000 file=bblearn_stats.dmp consistent=y bblearn_stats.dmp
  2. Compress the Blackboard Learn dump files on the source application server using any compression option. For the purposes of this document, a zipped tar ball is the compression option. Compress the dump files as follows:

    tar zcvf bblearn_admin_export.tgz bblearn_admin.dmp
    tar zcvf bblearn_export.tgz bblearn.dmp
    tar zcvf bblearn_stats_export.tgz bblearn_stats.dmp

  3. Transfer the compressed files to the target server using binary mode.

Export content management databases

  1. Perform a schema level export for the databases using the system account and the following table:
    Content Management Databases to Export
    Database Name Command Dump Name
    bblearn_cms exp userid=system/manager owner=bblearn_cms buffer=2048000 file=bblearn_cms.dmp consistent=y bblearn_cms.dmp
    bblearn_cms_doc exp userid=system/manager owner=bblearn_cms_doc buffer=2048000 file=bblearn_cms_doc.dmp consistent=y bblearn_cms_doc.dmp
  2. Compress the content management dump files on the source application server using any compression option. For the purposes of this document, a zipped tar ball is the compression option. Compress the dump files as follows:

    tar zcvf bblearn_cms_export.tgz bblearn_cms.dmp
    tar zcvf bblearn_cms_doc_export.tgz bblearn_cms_doc.dmp

  3. Transfer the compressed files to the target server using binary mode.