adrci commands

adrci: adrci commands

set base /u01/app/oracle
show home
show alert
show alert -p "message_text like "%incident%"'
show alert -p "message_text like "%ORA%"'
purge -age 43200  --purga diagnostic information de hace un mes
show problem
show incident
show incident -mode detail -p "incident_id=72697"

adrci> ips create package problem 2 correlate all
Created package 1 based on problem id 2, correlation level all

adrci> ips generate package 1 in "/tmp"
Generated package 1 in file /tmp/IPSPKG_20140610100342_COM_1.zip, mode complete

--12c enhancements

Setting the ENABLE_DDL_LOGGING parameter to TRUE activates DDL logging. All DDL statements are logged into a plain text file and an XML file in the ADR location.

CONN / AS SYSDBA
ALTER SESSION SET CONTAINER=pdb1;
ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;

CONN test/test@pdb1

CREATE TABLE test1 (id NUMBER);
ALTER TABLE test1 ADD CONSTRAINT test1_pk PRIMARY KEY (id);
DROP TABLE test1 PURGE;