ITPub博客

http://www.askmaclean.com/archives/oracle-exadata-%E5%AD%98%E5%82%A8%E6%9C%8D%E5%8A%A1%E5%99%A8%E5%8E%9F%E7%90%86%E6%8E%A2%E7%A9%B6.html

RMAN -- Frequently Asked Question (FAQ) (Doc ID 469777.1)

记录下, 在rman restore后, guarantee restore points仍然可以使用

V$RMAN_BACKUP_JOB_DETAILS展示了rman备份的相关细节。

Automatic Diagnostic Repository (ADR) in Oracle Database 11g Release 1 (ADRCI)

oracle 临时表空间的增删改查

并行语句执行雇佣PX服务的方式是典型的生产者/消费者模式

Finding Trace Files v$diag_info

从v$diag_info定位trace file

oracle 12c 列式存储 ( In Memory 理论)

http://www.dbaexpert.com/blog/

10046是一个Oracle的内部事件(event)

unix 服务器上可能有10多个数据库，可以用脚本批量启动，停止 ： start_all_dbs.sh， shutdown_all_dbs.sh.[@more@]*****************************************************************************************start_all_dbs.sh*****************************************************************************************#!/bin/kshORATAB=/var/opt/oracle/oratab; export ORATABTEMP_DIR=/tmp ; export TEMP_DIRfunction is_db_up{rm $TEMP_DIR/delme.logsqlplus "/ as sysdba"<< EOF > $TEMP_DIR/delme.log

前面我们用了rman 里的duplicate方法去在本机clone个db, 这里我们用CREATE CONTROLFILE 方法在另一台服务器上Clone. 缺点是用这个方法clone， 需要shutdown 原数据库，传输datafile到另台服务器。1- tar $ORACLE_HOME for 10.2.0 and 11.1.0 on ora6tar –cvf 2- scp them to srv7 (if the file is too large, may face File is too large issue. use ulimit –a to see the limitation). scp jxiaos@EAP-SRV6:/u01/app/oracle/product/ora11g.tar /u01scp jxiaos@EAP-SRV6:/u04/oradata/OLD_DB/*.* /u04/oradata/CLONEDDB/ [@more@]

In AIX, use below command to run installer, but always says jre issue. ./runInstaller -clone -silent -jreloc /usr/java5_64/jre -ignorePreReq ORACLE_HOME="/u01/app/oracle/product/11.1.0" ORACLE_HOME_NAME="OraDb11g_home1" ORACLE_BASE="/u01/app/oracle"[@more@] Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions

How to clone a db on the same server:1. First to determine the existing db's datafiles, controlfiles location. And create these folders. SQL> select DESTINATION from V$ARCHIVE_DEST;SQL> select * from V$CONTROLFILE;SQL> select MEMBER from V$LOGFILE;SQL> select name from V$TEMPFILE;[@more@]2. create these dump destination. mkdir adumpmkdir bdumpmkdir cdumpmkdir createmkdir dpdumpmkdir pflemkdir udump3. create password file.orapwd file=orapwmydb1 password=oracle entries=20;4. copy in

1. first create directories for oradata and core_dump_dest etc, set ORACLE_HOME, ORACLE_SID in .profle and create init.ora file in $ORACLE_HOME/dbsdb_name='mydatabase'memory_target=1Gprocesses = 150control_files='/ora/app/oracle/product/11.2.0/dbs/CONTROL01.CTL','/ora/data/mydatabase/CONTROL02.CTL'audit_file_dest=/ora/app/oracle/admin/mydatabase/adumpaudit_trail ='db'core_dump_dest=/ora/app/oracle/admin/mydatabase/cdump [@more@]#don't specify below 2 parameters, otherwise oracle says ORA-32

https://www.ibm.com/developerworks/mydeveloperworks/blogs/paixperiences/entry/remotex11aix?lang=enForward GUI installer to Windows from Unix. First download Cygwin or X Manager, and enable X11 fowwarding as below in PuTTY. Start X server. [@more@] v:* {behavior:url(#default#VML);} o:* {behavior:url(#default#VML);} w:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Forward GUI installer to Windows from Unix. First download Cygwin or X Manager,

Audit CREATE PROFILE Audit CREATE SESSION ...[@more@]查看哪些privs设置audit了。SQL> select * from DBA_PRIV_AUDIT_OPTS; USER_NAME PROXY_NAME PRIVILEGE SUCCESS FAILURE------------------------------ ------------------------------ ---------------------------------------- ---------- ---------- CREATE EXTERNAL JOB BY ACCESS BY ACCESS

resetlogshttp://blog.csdn.net/tianlesoftware/article/details/7753546[@more@]一．创建控制文件时：Resetlogs和Noresetlogs当我们将控制文件备份到trace 文件时，可以看到里面包含了2部分的重建语句，一个是使用resetlogs，另一个是使用noresetlogs。 备份控制文件的SQL 如下：SQL>alterdatabase backup controlfile to trace 有关控制文件的详细说明，参考：Oracle 控制文件http://blog.csdn.net/tianlesoftware/article/details/4974440 Set #1. NORESETLOGS caseThe followingcommands will create a new control file and use