jueves, 7 de abril de 2011

Create SnapShot

export ORACLE_SID=racdb1
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/rac1
export PATH=/u01/app/oracle/product/11.1.0/rac_1/bin:/usr/java/jdk1.5.0_11/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin

$ORACLE_HOME/bin/sqlplus -s /NOLOG <connect /as sysdba
exec dbms_workload_repository.create_snapshot
EOF


./create_snapshot.sh