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?
Oralce 12c SP2-0618 and ORA-01919
I met the error SP2-0618 and ORA-01919 while I executed the command “set autot on” to check the execute plan of sql.
HR@PDBPROD1> set autot on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
HR@PDBPROD1>
Oralce 18c New feature - Private Temporary Tables
We use Global Temporary Tables from Oracle 8i and we can use private temporary tables from 18c.
What is Private Temporary Tables? When to use Private Temporary Table ? How to use this?
Vagrant + Oracle Linux 7.4 + Oracle Database 18c + Create DB
How to install Database 18c in Oracle Linux 7.4?
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
How to install GUI in Oracle Linux 7?