ITPub博客

sys用户下的对象不支持导出[@more@]SQL> select owner,segment_name,tablespace_name from dba_segments where tablespace_name='USERS';OWNER SEGMENT_NAME TABLESPACE_NAME---------- -------------------- ------------------------------SYS REPAIR_TABLE USERSSYS TT USERSTEST1 TT USERSSYS T1 USERSTEST T USERSTEST TT USERS已选择6行。SQL>C:>expdp 'sys/system@test as sysdba' DIRECTORY=temp_dir dumpfile=users.dmp tablespaces=usersExport: Release 10.2.0.1.0 - Production on 星期一, 01 6月, 2009 9:47:44Copy

讲课时发现的所以随手记录一下。[@more@]SQL> alter tablespace users offline;表空间已更改。SQL> select * from t2;select * from t2 *第 1 行出现错误:ORA-00376: 此时无法读取文件 4ORA-01110: 数据文件 4: 'C:ORADATATESTUSERS01.DBF'--备份表空间users对应的数据文件SQL> alter tablespace users online;表空间已更改。SQL> select group#,sequence#,archived,status,first_change# from v$log; GROUP# SEQUENCE# ARC STATUS FIRST_CHANGE#---------- ---------- --- ---------------- ----

没有实质性的结论，暂时记个过程吧。[@more@]RMAN> backup database;启动 backup 于 26-3月 -09使用通道 ORA_DISK_1通道 ORA_DISK_1: 启动全部数据文件备份集通道 ORA_DISK_1: 正在指定备份集中的数据文件输入数据文件 fno=00001 name=E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF输入数据文件 fno=00003 name=E:ORACLEPRODUCT10.2.0ORADATAORCLSYSAUX01.DBF输入数据文件 fno=00004 name=E:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBF输入数据文件 fno=00007 name=E:ORACLEPRODUCT10.2.0ORADATAORCLUNDOTBS02.DBF通道 ORA_DISK_1: 正

doc上解释的格外清楚，还是看doc吧[@more@]Detection of Fractured Blocks During Open BackupsOne danger in making online backups is the possibility of inconsistent data within a block. For example, assume that you are backing up block 100 in datafile users.dbf. Also, assume that the copy utility reads the entire block while DBWR is in the middle of updating the block. In this case, the copy utility may read the old data in the top half of the block and the new data in the bottom top half of the bloc

doc的原话，随手记录一下！[@more@]Tuning FAST_START_MTTR_TARGET and Using MTTR AdvisorTo determine the appropriate value for FAST_START_MTTR_TARGET for your database, use the following four step process:Calibrate the FAST_START_MTTR_TARGETDetermine the Practical Range for FAST_START_MTTR_TARGETEvaluate Different Target Values with MTTR AdvisorDetermine Optimal Size for Redo LogsCalibrate the FAST_START_MTTR_TARGETThe FAST_START_MTTR_TARGET initialization parameter causes the database to calculate

详细解释了备份恢复的原理！[@more@]--controlfile中记录的checkpoint_change#其实一句话就可以说明白：那就是数据文件的头上不仅仅包含了checkpoint_change#,更重要的是它包含了这个checkpoint_change#所在的logfile的sequence＃，准确的说是rba。结果花了很大篇幅，只想以试验的方式做个简单的验证，便于大家理解。欢迎拍砖！另外提个问题：是否存在一些view它是源于redo的？SQL> select checkpoint_change# from v$database;CHECKPOINT_CHANGE#------------------ 1951985--datafile中记录的checkpoint_change#SQL> se

记录一下！http://blog.csdn.net/fjmingyang/archive/2006/06/07/778379.aspx[@more@]http://blog.csdn.net/fjmingyang/archive/2006/06/07/778379.aspx

讲课讲到不完全恢复（找回drop table）时，经常需要确定drop table的确切时间，所以经常需要用到dbms_logmner，记录一下大致过程，备查！[@more@]SQL> desc dbms_logmnr_dPROCEDURE BUILD参数名称 类型 输入/输出默认值?------------------------------ ----------------------- ------ -------- DICTIONARY_FILENAME VARCHAR2 IN DEFAULT DICTIONARY_LOCATION VARCHAR2 IN DEFAULT OPTIONS NUMBER

If the change tracking file was stored in the database area, then it is deleted when you disable change tracking.[@more@]SQL> alter database enable block change tracking using file 2 'C:block_changerman_change_track.txt' ;数据库已更改。SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;数据库已更改。--block change tracking文件可以放在flash_recovery_area,如果放在flash_recovery_area里面，则tracking文件会被自动删除，否则不会If the change tracking file was stored in the database area, then it

讲课时随手记录的大致过程！[@more@]SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startup mountORACLE 例程已经启动。Total System Global Area 163577856 bytesFixed Size 1247876 bytesVariable Size 83887484 bytesDatabase Buffers 75497472 bytesRedo Buffers 2945024 bytes数据库装载完毕。SQL> select checkpoint_change# from v$database;CHECKPOINT_CHANGE#------------------ 727692SQL> select file#

讲课时随手记录的过程！[@more@]session 1:SQL> alter tablespace users offline;表空间已更改。SQL> select *from t2;select *from t2*第 1 行出现错误:ORA-00376: 此时无法读取文件 11ORA-01110: 数据文件 11: 'E:ORACLEPRODUCT10.2.0ORADATATESTUSERS02.DBF'SQL> alter tablespace users online;表空间已更改。SQL> select *from t2;ID----------123456已选择6行。SQL> select group#,status,sequence# ,archived,thread#,first_change# from v$log;GROUP# STATUS SEQUENCE# ARC THREAD# FIRST_CHANGE#---------- -----

讲课时随手记录的一个大致过程！[@more@]SQL> create table t2(id int) tablespace users;表已创建。SQL> select current_scn from v$database;CURRENT_SCN----------- 704959SQL> select group#,status,sequence# ,archived,thread#,first_change# from v$log; GROUP# STATUS SEQUENCE# ARC THREAD# FIRST_CHANGE#---------- ---------------- ---------- --- ---------- ------------- 1 ACTIVE 89 YES 1 704431 4 CURRENT 90 NO

Password Encryption of Backups参考doc：http://users.telenet.be/oraguy.be/encryption1.htm[@more@]大致测试过程：RMAN> show all;正在启动全部恢复目录的 resync完成全部 resyncRMAN 配置参数为:CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;CONFIGURE BACKUP OPTIMIZATION OFF;CONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BA

configure exclude不常用，经常忘记语法，简单整理一下，备忘！[@more@]RMAN> configure exclude for tablespace 'USERS';今后的全部数据库备份将排除表空间 USERS已成功存储新的 RMAN 配置参数RMAN> SHOW EXCLUDE;使用目标数据库控制文件替代恢复目录RMAN 配置参数为:CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';SQL> select NAME,INCLUDED_IN_DATABASE_BACKUP from v$tablespace;NAME INC------------------------------ ---SYSTEM YESUNDOTBS1 YESSYSAUX YESTEMP NOUSERS NONCLUDED_IN_DATABASE_BACKUP字段表示backup时对应的表

参考的doc如下：http://www.oracle.com/technology/oramag/oracle/05-sep/o55security.htmlhttp://users.telenet.be/oraguy.be/encryption1.htm[@more@]0.说明wallet的location在sqlnet.ora中增加下面内容说明wallet的location:ENCRYPTION_WALLET_LOCATION =(SOURCE=(METHOD=file)(METHOD_DATA=(DIRECTORY=/orawall)))1.察看备份加密特性是否激活RMAN> show all;RMAN 配置参数为:CONFIGURE RETENTION POLICY TO REDUNDANCY 1;CONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE

1 cp /home/oracle/.bash_profile dbbak1.sh之所以要拷贝这个文件，是因为它是oracle用户的环境变量文件，里面包含了oracle用户所需要的所有环境变量2. 在dbbak1.sh文件中加入如下语句：sqlplus sys/password@tns @/home/oracle/dbbak1.sql3. 编写dbbak1.sql如下：alter tablespace users begin backup;copy path...../users.dbf /home/oraclealter tablespace users end backup;--这里只是用来测试！4. chmod +x dbbak1.sh5. 利用crontab来调用dbbak1.sh[@more@]大致的思路和过程，使用时根据实际应用调整！

仅仅是思路和过程，根据自己的需求调整：1 cp /home/oracle/.bash_profile dbbak.sh之所以要拷贝这个文件，是因为它是oracle用户的环境变量文件，里面包含了oracle用户所需要的所有环境变量2. 在dbbak.sh文件中加入如下语句：rman target sys/password@tns cmdfile=/home/oracle/dbbak.sql3. 编写dbbak.sql如下：backup tablespace 'TEST';这里只是用来测试！4. chmod +x dbbak.sh5. 利用crontab来调用dbbak.sh脚本实现自动备份db,假如想每天晚上21：38分自动备份db，那么可以通过crontab -e来编辑root用户的自动定时任务：[root@xys orac

c:dbbak.batdbbak.bat内容如下：sqlplus / as sysdba @ dbbak.sql把批处理文件dbbak.bat放到任务计划里或者通过at命令调用就可以实现自动备份db[@more@]--================================select 'alter tablespace '||tablespace_name||' begin backup;' from dba_data_files;select 'host copy '||file_name||' C:oracleproduct10.2.0oradataonline;' from dba_data_filesselect 'alter tablespace '||tablespace_name||' end backup;' from dba_data_files;dbbak.sql脚本内容可以通过上面语句构造dbbak.sql内容如下：alter tablespace

当存在read only或者offline表空间时，重建控制文件分两种情况：1、重建controlfile的script中包含read only或者offline所对应的datafile；这种情况比较简单，datafile不需要rename，如果是offline的表空间，那么重建controlfile之后只需要online tbs即可；如果是read only tbs那么重建controlfile之后需要对其对应的daafile进行恢复。2、重建controlfile的script中不包含read only或者offline所对应的datafile；重建controlfile之后需要rename datafile到正确的位置，之后如果是offline的表空间，那么重建controlfile之后只需要online tb

1. 对read only tbs进行热备份时不需要执行begin backup；2.从9i开始通过备份的controlfile对只读表空间进行恢复时不再需要把read only tbs对应的数据文件设置为offline[@more@]http://www.hackhome.com/InfoView/Article_164468.html也可以参考这个，写的更周全详细一些！1.SQL> alter tablespace users read only;表空间已更改。SQL> alter tablespace users begin backup;alter tablespace users begin backup*第 1 行出现错误:ORA-01642: 只读表空间 'USERS' 无需开始备份SQL> alter database backup controlfile to trace;数