...
This section describes how to create a database of versions supported according to Altibase's End of Service (EOS) policy. As for this document, the latest Altibase version is 'Altibase ver. 7' and 'Altibase ver 6 or below' are for EOS. Altibase cannot be operated until the database is created, so the database must be created as follows before starting the Altibase.
- Check DB_NAME in altibase.properties
...
- In the case of DB_NAME, it is determined when the database is created.
- In order to change, the database must be recreated, so migration must be performed.
- Therefore, be cautious when creating a database for the first time.
How to drop a database
...
The user can drop the database by deleting all Altiabse configuration files.
Check the files to be dropped
...
- To check whether the database is dropped normally, check before dropping the data files and log files to be deleted.
| Code Block | ||
|---|---|---|
| ||
iSQL> select name, checkpoint_path from v$tablespaces a, v$mem_tablespace_checkpoint_paths b where a.id = b.space_id;
iSQL> select a.name, b.name from v$tablespaces a, v$datafiles b where a.id = b.spaceid;
$ cat $ALTIBASE_HOME/conf/altibase.properties | grep ^LOG | grep DIR |
Dropping a database
...
- After Altibase is shut down, the database is dropped in the process stage.
| Code Block | ||
|---|---|---|
| ||
$ isql -u sys -p manager -sysdba...
iSQL(sysdba)> startup process;
Connecting to the DB server.... Connected.
TRANSITION TO PHASE : PROCESS
Command executed successfully.
iSQL(sysdba)> drop database mydb;
Checking Log Anchor files
[Ok] /home/altibase/altibase_home/logs/loganchor0 Exist.
[Ok] /home/altibase/altibase_home/logs/loganchor1 Exist.
[Ok] /home/altibase/altibase_home/logs/loganchor2 Exist.
Removing DB files
Removing Log files
Removing Log Anchor files
Drop success.
iSQL(sysdba)> exit |