Entering content frameObject documentation SAPDBA Main Menu Locate the document in its SAP Library structure

Definition

When you start SAPDBA for Oracle with the graphical user interface (GUI), you see the SAPDBA main menu.

Structure

The main menu looks as follows:

ORACLE version:

8.0.3.2.0

ORACLE_SID:

C11

ORACLE_HOME:

/oracle/C11

DATABASE:

shut down

SAPR3:

not connected

a

Startup/Shutdown instance

h

Backup database

b

Instance information

i

Backup offline redo logs

c

Tablespace administration

j

Restore/Recovery

d

Reorganization

k

DB check/verification

e

Export/import

l

Show/Cleanup

f

Archive Mode

m

User and Security

g

Additional functions

   
       

q

Quit

   

 

SAPDBA Commands on the Main Menu

Command

See

Startup/Shutdown instance, Instance information

Startup and Shutdown of the Oracle Database with SAPDBA

Tablespace administration

Tablespace Administration with SAPDBA

Reorganization

Database Reorganization with SAPDBA

Export/import

Export and Import of Database Objects with SAPDBA

Archive mode

Setting Archive and Database Mode with SAPDBA

Additional functions

Starting Individual SQL Scripts with SAPDBA

Updating Statistics using Optimizer Control with SAPDBA

Checking SAPDBA Release Information

Backup database

Database Backup with SAPDBA

Backup offline redo logs

Backup of the Offline Redo Log Files with SAPDBA

Restore/Recovery

Performing a Full Restore and Point-in-Time Recovery with SAPDBA

DB check/verification

Partial Restore and Complete Recovery with SAPDBA

Show/Cleanup

Management of SAPDBA Logs and Profiles

User and Security

Users and Roles

Changing Database User Passwords

Switching to Restricted Session Mode

UNIX User Configurations

Leaving content frame