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 |