Oracle Query 基础知识
汇总Oracle查询基础知识
什么是子查询？
Oracle Recovery 04 - How to dump the control file?
Oracle Recovery 03 - Recover the delete/truncate/drop action
Recovering the database/datafile/block is easy if there was rman backup. However it is pretty hard when delete/truncate/drop are happened due to human miss or bussiness bug. I have summaried some ways to recovery the delete/truncate/drop action and list some steps.
Oracle Problem about UNDO Tablespace - ORA-01548 ORA-01157 ORA-01110
I want to replace this UNDO tablespace with new UNDO tablespace ( UNDOTBSN01) and drop this existing tablespace i.e (UNDOTBS1).And I met the error-ORA-01548. How to fixed this error?
Oracle - Recovery 02 - Controlfile
All of controlfiles are removed. —-> How to recovery?
Oracle - Recovery 01 - BBED
BBED stands for Block Brower and EDitor BBED is a tool just like ultraEdit. After we understand the Block format in Oracle, we can use BBED to test a lot of casestudies！
Oracle - Study UNDO
undo回滚段作用:
事务回滚
实例恢复(利用回滚段来恢复未提交的数据)
构造CR块，读一致性
数据库闪回查询
数据库闪回恢复逻辑错误
Oracle 12c - Study PDB$SEED
###
Oracle 12c - Study Resetlogs
Backup and recover is the important toipc in Database area. the resetlogs knowledge is important in Backup&Recover.
The VagrantBox list from Oracle
Unitl now, Oracle have provide the vagrantbox in the following link in Github.
How to remove file while happening “Text file busy”?
How to install Redis3.0 in Linux 7?