lunes, 30 de abril de 2018

Backing Up in NOARCHIVELOG Mode: Example

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP FORCE DBA;
SQL> SHUTDOWN IMMEDIATE;

RMAN> STARTUP MOUNT;
RMAN> BACKUP COPIES 2 INCREMENTAL LEVEL 0 MAXSETSIZE 10M DATABASE; RMAN> ALTER DATABASE OPEN;
 

miércoles, 4 de abril de 2018

.PROFILE ORACLE SINGLE

export AWT_TOOLKIT=XToolkit
export ORACLE_BASE=/u01/app/oracledb
export ORACLE_HOME=/u01/app/oracledb/product/11.2.0/db_1
export ORACLE_SID=USCS90TS
export TZ=America/Bogota
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/sbin:/bin:/usr/X11/bin:/usr/dt/bin:/usr/openwin/bin:/usr/ccs/bin:/usr/local/bin::/usr/local/bin:/home/oracle:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib
export CLASSPATH=$ORACLE_HOME/jdbc:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib$ORACLE_HOME/network/jlib
export NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS'
export TNS_ADMIN=/u01/app/oracledb/product/11.2.0/db_1/network/admin
export TEMP=/tmp
export TMPDIR=/tmp
ulimit -n 65536
# Alias
alias sql='sqlplus / as sysdba'