Oracle DBA Manual 4: Data Security Alerts

Source: Internet
Author: User
Oracle DBA Manual 4: Data Security Alerts
Basic Information
Author: Gao Guoqiang [Translator's introduction]
Press: Electronic Industry Press
ISBN: 978712117206
Mounting time:
Published on: February 1, July 2012
Start: 16
Page number: 404
Version: 1-1
Category: computer more about, Oracle DBA Manual 4: Data Security Alerts
Introduction
Computer books
Oracle DBA Manual 4: Data Security Alerts is a data security book for everyone. It is not only for technical staff, but also for enterprise data managers, if you don't look at these cases, you may never understand why the database has encountered a disaster. You may never understand why the treasure of a thousand miles has crashed into the ant nest.
Of course, this is still a very in-depth technical book. The author records the rescue process in many cases, including some in-depth technical discussions, these technical discussions can help readers deepen their understanding of Oracle Database technology, and help you make the same rescue work in the case of similar cases.
Directory
Oracle DBA Manual 4: Data Security Alerts
There is no beginning, fresh grams have end 1
Case study of space-accidental deletion of data files for restoration
Disaster description 3
Case alert 4
Technical playback 5
Recovery Process-restore data through file descriptors 7
Technical difficulties 21
Get file number 21 through bbed
Obtain file number information by using the OD command 24
To save the cause -- force recovery causes ora-600 4000 error case 29
Disaster description 29
Case alert 30
Technical playback 31
Recovery Process 35
Ora-600 4000 error details 36
Eliminate SCN exception 41 Through _ minimum_giga_scn
Ora-600 4194 error undo troubleshooting 45
Optimize the table space by storage optimization case 49
Disaster description 49
Case alert 50
Technical playback 51
Security period 57
Validate implements backup verification 57
Database Backup encryption 60
Password mode 61
Transparent mode 63
Hybrid mode 66
TDE technology 66
Hold the wood, starting at the end of 73
Oracle Database software release sequence 75
A disaster caused by a logical bad block 79
Case warning 79
Technical playback 80
A disaster caused by bad hard disk Block 81
Disaster description 81
Case warning 81
Technical playback 83
Introduction to the AIX system ODM 83
ASM header block backup mechanism 84
Kfed tool compilation and use 87
Manual repair of ASM case 1 91
Disaster description 91
Technical playback 91
Provisioned disk Status Analysis 92
Use kfed to modify ASM disk header information 94
ASM data extraction and recovery-restore data through amdu Case 1: 101
Disaster 101
Case alert 101
Technical playback 102
Amdu tool 102
File Analysis 105
Restore the amdu file by 106
Plan ahead, and prevent 109
Four major DBA Rules 111
Two rules outside the DBA code: 113
Various painful cases 117
Case study of system-level accidental deletion 117
Database accidental deletion case 122
DDL monitoring 123 using triggers
Case Study of Primary/backup environment error 132
Case study of misoperations during business peaks: 136
Backup misoperation case 139
Case study of process-level misoperations 142
Data File misoperations case 143
Case study of accidentally shutting down the production database 145
Case study of system storage-level accidental deletion 148
Make up for it. If it's not too late, it's 151.
Case Study of Data tampering 153
Case 153
Case alert 153
Technical playback 154
Fault analysis process 155
Log File dumping 157
Logmnr parsing 162
In-depth analysis of Cases 164
Technical difficulties 176
Password security and encryption 185
207
Disaster caused by a collision-failure caused by ASM protected files offline: 209
Disaster 209
Case alert 209
Technical playback 210
Recovery 214
Disaster caused by another collision-Case Study of missing offline and archive files 217
Disaster 217
Case alert 217
Technical playback 219
Recovery 224
Offline space and file -- offline tablespace loading and restoration 239
Disaster 239
Case alert 239
Technical playback 240
Recovery 248
Technical tips 254
About archive space settings 254
Check Point consistency adjusted by 258
Think twice, think twice
Truncate-core dictionary table misoperation truncate 267
Disaster 267
Case alert 267
Technical playback 268
Recovery 274
Disaster Caused by script errors-database overall deletion failure 281
Disaster 281
Case alert 281
Technical playback 282
Recovery 283
The treasure of a thousand miles breaks through the ant cave 291
Disaster caused by one character-maintenance failure caused by case-insensitive characters 293
Disaster 293
Case alert 293
Case study 294
Technical playback 302
Disaster caused by a drive letter-error formatting error 315
Disaster 315
Case alert 315
Technical playback 316
Make the best use of all things, only 319 people
Database shutdown and shutdown-write loss failure caused by forced shutdown 321
Disaster 321
Case alert 321
Recovery 322
Technical tips 351
From minor fault to disaster-reconstruction of 353 of failures caused by control document errors
Disaster 353
Case alert 353
Technical playback 354
All in all, and there are deficiencies in things-a 365 disaster caused by hardware faults
Disaster 365
Case alert 365
Technical playback 366
Appendix 1 Description of bbed 369
Appendix 2 function f_get_from_dump 372
References 377

Source of this book: China Interactive publishing network

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.