User Tools

Site Tools


oracle

ORACLE Index

List Tablespaces

select tablespace_name, file_name, bytes, autoextensible from dba_data_files;

Add More Space

alter database datafile '/full/path/to/system01.dbf' autoextend on next 128m maxsize 8192m;
alter tablespace SYSTEM add datafile '/full/path/to/system02.dbf' size 512m;

Check status

select status from v$instance;
select status from v$archive_dest;
list backup;
validate database;

RAC

Resources

crsctl status resource -t

Node Status

crsctl check crs

Cluster Status

crsctl check cluster -all

ASMCMD

$ asmcmd
ASMCMD> help {command}
ASMCMD> ls
ASMCMD> lsdsk
ASMCMD> lsdg
ASMCMD> lsdsk -k
ASMCMD> iostat -t 10

Rename service

alter system set service_names = 'mydb' scope = both;
alter database rename global_name to mydb;
alter system register;

show parameter name;
alter system set db_domain='' scope=spfile; 

Enable disable DB auditing

ALTER SYSTEM SET AUDIT_TRAIL=NONE SCOPE=SPFILE;

Set log archive

alter system set log_archive_dest_1='LOCATION=/ora/arch' scope=SPFILE;

Set Recovery size

alter system set db_recovery_file_dest_size=XG;
oracle.txt · Last modified: 2017/11/21 11:32 by Jan Forman