Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Table of Contents

 

Overview

...

Code Block
..Omitted
MEM_DB_DIR          = /home/cheol2/altibase_home/dbs # Memory DB Directory
 
DEFAULT_DISK_DB_DIR =/home/cheol2/altibase_home/dbs # Disk   DB Directory
 
LOGANCHOR_DIR       =/home/cheol2/altibase_home/logs # LOGANCHOR_DIR1  // 로그앵커
LOGANCHOR_DIR       = /home/cheol2/altibase_home/logs # LOGANCHOR_DIR2
LOGANCHOR_DIR       = /home/cheol2/altibase_home/logs # LOGANCHOR_DIR3
 
LOG_DIR = /home/cheol2/altibase_home/logs # 리두로그Redo 파일log 디렉토리file directory
ARCHIVE_DIR   =  /home/cheol2/altibase_home/logs # 아카이브Archive 디렉토리directory
..Omitted

3. Startup at the Control stage.

...

Code Block
iSQL(sysdba)>alter database rename datafile '/home/cheol2/altibase_home/dbs2/system001.dbf'  to '/home/cheol2/altibase_home/dbs/system001.dbf'; 
iSQL(sysdba)>alter database rename datafile '/home/cheol2/altibase_home/dbs2/system002.dbf'  to '/home/cheol2/altibase_home/dbs/system002.dbf';
iSQL(sysdba)>alter database rename datafile '/home/cheol2/altibase_home/dbs2/temp001.dbf'  to '/home/cheol2/altibase_home/dbs/temp001.dbf';  
iSQL(sysdba)>alter database rename datafile '/home/cheol2/altibase_home/dbs2/undo001.dbf'  to '/home/cheol2/altibase_home/dbs/undo001.dbf';  
iSQL(sysdba)>alter database rename datafile '/home/cheol2/altibase_home/dbs2/system001.dbf'  to '/home/cheol2/altibase_home/dbs/system001.dbf'; 
iSQL(sysdba)>alter database rename  datafile '/home/cheol2/altibase_home/dbs2/system002.dbf'  to '/home/cheol2/altibase_home/dbs/system002.dbf'; 
iSQL(sysdba)>alter database rename datafile '/home/cheol2/altibase_home/dbs2/temp001.dbf'  to '/home/cheol2/altibase_home/dbs/temp001.dbf'; 
iSQL(sysdba)>alter database rename datafile '/home/cheol2/altibase_home/dbs2/undo001.dbf'  to '/home/cheol2/altibase_home/dbs/undo001.dbf';  

5. Start up Startup in ISQL.

Code Block
iSQL(sysdba)> startup service;ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 33889
[ERR-910FB : Connected to idle instance]
Connecting to the DB server... Connected.
 
TRANSITION TO PHASE : PROCESS
 
TRANSITION TO PHASE : CONTROL
 
TRANSITION TO PHASE : META
  [SM] Recovery Phase - 1 : Preparing Database
                          : Dynamic Memory Version => Parallel Loading
  [SM] Recovery Phase - 2 : Loading Database
  [SM] Recovery Phase - 3 : Skipping Recovery & Starting Threads...
                            Refining Disk Table
  [SM] Refine Memory Table : ............................................................................................................ [SUCCESS]
  [SM] Rebuilding Indices [Total Count:117] ........................................................................................................... [SUCCESS]
 
TRANSITION TO PHASE : SERVICE
  [CM] Listener started : TCP on port 33889 [IPV4]
  [CM] Listener started : UNIX
  [CM] Listener started : IPC
  [RP] Initialization : [PASS]
 
--- STARTUP Process SUCCESS ---  
Command executed successfully.

...

More detailed information can be found in the Table of Contents of the General Reference Manual.

 

...