Verify that the target databases have sufficient space before restoring Blackboard Learn and the content management data.
Execute the following SQL query to determine the space used by Blackboard Learn in each tablespace:
SELECT tablespace_name, SUM (bytes) FROM dba_segments WHERE tablespace_name LIKE 'BB%' GROUP BY tablespace_name;
SELECT tablespace_name, SUM(bytes) FROM dba_segments WHERE tablespace_name LIKE 'BBLEARN_CMS%' GROUP BY tablespace_name;
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:
SELECT tablespace_name, maxbytes FROM dba_data_files WHERE tablespace_name LIKE 'BB%';
SELECT tablespace_name, maxbytes FROM dba_data_files WHERE tablespace_name LIKE 'BBLEARN_CMS%';
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.
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;
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;