If you're a Managed Hosting (SaaS) customer, this topic doesn't apply to you.
Verify that the target databases have sufficient space before restoring Blackboard Learn and the content management data.
Check the tablespace sizes in the source database
Execute the following SQL query to determine the space used by Blackboard Learn in each tablespace:
Blackboard Learn
SELECT tablespace_name, SUM (bytes) FROM dba_segments WHERE tablespace_name LIKE 'BB%' GROUP BY tablespace_name;
Example of output
TABLESPACE_NAME SUM(BYTES)
BBLEARN_ADMIN_DATA 1179648
BBLEARN_ADMIN_INDX 1572864
BBLEARN_DATA 178388992
BBLEARN_INDX 53608448
BBLEARN_STATS_DATA 1966080
BBLEARN_STATS_INDX 6553600
Content management
SELECT tablespace_name, SUM(bytes) FROM dba_segments WHERE tablespace_name LIKE 'BBLEARN_CMS%' GROUP BY tablespace_name;
Example of output
TABLESPACE_NAME SUM(BYTES)
BBLEARN_CMS_DATA 3801088
BBLEARN_CMS_DOC 87425024
BBLEARN_CMS_INDX 1966080
Verify that the corresponding target tablespaces have sufficient space
The following query can return two or more rows for each tablespace. Each row shows the maximum size of each file that belongs to that tablespace. If the maxbytes equals 0, the maximum is unlimited. Some operating systems limit the file size to 2GB. Therefore, Blackboard recommends limiting the file size to 2GB even though the operating system may be capable of handling larger sizes.
To determine the total size of each tablespace, add all the maxbytes together. If the maxbytes of a tablespace equals 0, substitute with 2GB before adding the maxbytes together. Execute the following SQL query to determine maximum space to which each tablespace can grow:
Blackboard Learn
SELECT tablespace_name, maxbytes FROM dba_data_files WHERE tablespace_name LIKE 'BB%';
Example output
TABLESPACE_NAME MAXBYTES
BBLEARN_ADMIN_DATA 2097152000
BBLEARN_ADMIN_INDX 2097152000
BBLEARN_STATS_DATA 2097152000
BBLEARN_STATS_INDX 2097152000
BBLEARN_DATA 2097152000
BBLEARN_INDX 2097152000
Content management
SELECT tablespace_name, maxbytes FROM dba_data_files WHERE tablespace_name LIKE 'BBLEARN_CMS%';
Example output
TABLESPACE_NAME MAXBYTES
BBLEARN_CMS_DATA 2097152000
BBLEARN_CMS_INDX 2097152000
BBLEARN_CMS_DOC 2097152000
Insufficient available space
If the maximum available is not sufficient, there are two options available for increasing the space. Both options apply to Blackboard Learn and content management. The first option is to increase the file size (which is recommended), and the second option is to add one or more files.
Increase the file size
If the required space in any tablespace is less than 2GB and the maximum available space is not sufficient, the size of the file may be increased up to 2GB. For example, if BBLEARN_DATA tablespace requires 700MB, but the maximum available space is only 500MB, increase the file size to 2GB. Before increasing the file size, locate the file name that belongs to the BBLEARN_DATA tablespace.
- Locate the file name and note the file naming convention. The file naming convention should be tablespace_name_filesequential_number.dbf , where the first sequential number is '1'.
SELECT file_name FROM dba_data_files WHERE tablespace_name='BBLEARN_DATA';
- Resize the file.
ALTER DATABASE datafile 'path_to_file/bblearn_data_file1.dbf' RESIZE 2000M;
Add one or more files
If the required space in any tablespace is greater than 2GB and the maximum available space is not sufficient, one or more files must be added to increase the available space. For example, if BBLEARN_INDX tablespace requires 5GB, but the maximum available space is only 2GB, another two files of 2GB each must be added to result in a total of 6GB. Additional space which is not currently in use does not have a negative impact; and is recommended for scaling. Use the following steps to add the files.
- Find the existing file and its path:
SELECT file_name FROM dba_data_files WHERE tablespace_name='BBLEARN_INDX';
- Add two files to increase the available space:
ALTER TABLESPACE BBLEARN_INDX ADD datafile 'path_to_file/bblearn_indx_file2.dbf' SIZE 2000M;
ALTER TABLESPACE BBLEARN_INDX ADD datafile 'path_to_file/bblearn_indx_file3.dbf' SIZE 2000M;