There is no excerpt because this is a protected post.
Advertisements
2013 Juni Kurs Oracle Performance in München
Hallo nach Amsterdam nun vom 24-28.Juni ein Kurs "Oracle Performance" in München mit einen ehemaligen Arbeitskollege hatte ich ein nettes Abendessen und ein wenig schwelgen in Erinnerungen… Einen Tag danach traf ich aus der selbiger Firma einen anderen Kollegen ganz zufällig in München wieder, was für ein Zufall.... Auch hatte ich ein netten Abend mit... Continue Reading →
Rman Oracle
Infos zu Rman Master Note For Oracle Recovery Manager rman.oracle.pdf
What I learned about shared pool management
a very good explanation: http://coskan.wordpress.com/2007/09/14/what-i-learned-about-shared-pool-management/
rman DUPLICATE DATABASE BACKUP LOCATION
run{ backup as compressed backupset database format '/u80/inc0_%d_%T_p%p_s%s'; backup as compressed backupset archivelog all format '/u80/arc_%d_%T_p%p_s%s'; backup spfile format '/u80/spfile_%d_%T_p%p_s%s'; backup current controlfile format '/u80/ctl_%d_%T_p%p_s%s'; } scp *20110921* oracle@xh002:$PWD cddbs vi initTWINT01.ora db_name=TWINT01 db_unique_name=TWINT01 control_files='/u01/control01.ctl' audit_file_dest='/u01' compatible='11.2.0' diagnostic_dest='/u01' db_create_file_dest='/u01' log_archive_dest_1='LOCATION=/u01' log_archive_format='TWINT01_%t_%s_%r.arc' export ORACLE_SID=TWINT01 sqlplus / as sysdba startup nomount ... Continue Reading →
Audit Trail Management
http://www.oracle.com/technetwork/issue-archive/2010/10-nov/o60security-17606... TECHNOLOGY: Security As Published In November/December 2010 Managing Audit Trails By Arup Nanda Relocate the audit trail to a different tablespace and set up an automatic purge process to keep its size under control. One of the most significant aspects of database security involves setting up auditing to record user activities. The very knowledge... Continue Reading →
