Oracle管理者用コマンド

(crsctl stat res -t)

crsctl stat res -t

(crsctl start crs)

crsctl start crs

(srvctl start database -db orcl)

srvctl start database -db orcl

(srvctl start instance -db orcl -node node1)

srvctl start instance -db orcl -node node1

(tail -f $ORACLE_BASE/diag/rdbms/orcl/orcl1/trace/alert_orcl1.log)

tail -f $ORACLE_BASE/diag/rdbms/orcl/orcl1/trace/alert_orcl1.log

(vi $ORACLE_HOME/network/admin/tnsnames.ora)

vi $ORACLE_HOME/network/admin/tnsnames.ora

(sqlplus / as sysdba)

sqlplus / as sysdba

(@?/rdbms/admin/awrrpt.sql)

@?/rdbms/admin/awrrpt.sql

(exec dbms_stats.gather_table_stats('test','test_table');)

exec dbms_stats.gather_table_stats('test','test_table');

(select * from v$database;)

select * from v$database;

(select * from v$instance;)

select * from v$instance;

(select * from v$dataguard_stats;)

select * from v$dataguard_stats;

(alter database recover managed standby database disconnect;)

alter database recover managed standby database disconnect;

(alter session set container = orclpdb;)

alter session set container = orclpdb;

(exec dbms_workload_repository.create_snapshot;)

exec dbms_workload_repository.create_snapshot;

(alter user test identified by "password";)

alter user test identified by "password";

(alter session set events '10046 trace name context forever , level 12';)

alter session set events '10046 trace name context forever , level 12';

(rman target /)

rman target /

(alter system archive log current;)

alter system archive log current;

(backup as copy device type disk database;)

backup as copy device type disk database;