Discover oracle database audit logs, include the articles, news, trends, analysis and practical advice about oracle database audit logs on alibabacloud.com
Some Oracle database query optimization suggestions are comprehensive, oracle Database
1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.2. Try to avoid null value determination on the field in the where clause. Otherwise, the engine
Oracle Database full recovery and Incomplete recovery, and perform user management for multiple generations recovery, oracle user management
Comparison between full recovery and Incomplete recovery:
1. Full recovery: restores the database to the latest status, including all submitted data changes until the request is r
database?Oracle users are very familiar with SCN, while MSSQL users use the mongoing_failover_lsn mechanism (roughly speaking, it is a log serial number ). Unlike Oracle, MSSQL separates transactions (two transactions are on two machines), rather than a distributed transaction (you need to wait for the transaction to be committed remotely before committing itsel
, update, delete, and so on) Statements for database operations. In addition, it can analyze and obtain some necessary SQL statements for rollback. This tool is especially suitable for debugging, auditing, or rolling back a specific transaction. Currently, many applications use LogMiner to obtain Database Change Events.
Compared with the previous technologies, LogMiner has the advantage of capturing
Oracle Database Upgrade has always been a complex project. DBAs need to spend a lot of time and effort on preparation for Product Database Upgrade because of its high complexity, therefore, even if you are fully prepared, unexpected problems may still occur during the upgrade process. In order to complete the upgrade task more efficiently and reduce the downtime,
these files to restore the database.
The following additional files are important to the successful running of the database:Parameter file: Defines the configuration when an instance is started.Password File: Allows sysdba, sysoper, and sysasm to remotely connect to the instance and perform management tasks.Backup File: Used for database recovery. If the original file is damaged or deleted when a media fau
replication, the synchronization program automatically records the status when the network is disconnected. After the network is reconnected, the synchronization program continues to transmit data. Data backed up will not be lost due to network and other communication faults. This ensures reliable hot data backup in unreliable networks.
4. actiontrail records all data operation logs of the master database
#, status from v $ Log;
GROUP # arc sequence # STATUS---------------------------------------1 YES 67 INACTIVE2 YES 68 INACTIVE3 NO 69 CURRENT
Note: here we can infer that if the database needs to be restored to the current state, all archives archived from 59 to 66 must be effectively restored. We only need to initiate the restore database preview command, Oracle
db_recovery_file_dest= '/oracle/app/oracle/oradata/'#SET sga_max_size 200M#SET Sga_target 185MNofilenamecheck;}These storage directories: Flash back directory, ADR directory, audit log directory, oracle-managed data file directory and so on, must pay attention to AH------------here to explain the principle of initiali
1 Introduction Oracle Official network: http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10727/strmover.htm
Oracle Stream functionality is designed to improve the high availability of the database, which is known as Advance Replication in Oracle 9i and prior ver
changes made to the database are recorded in the log.If you cannot permanently write the modified data to a data file when a fault occurs, you can obtain the modified log,This ensures that the operation results are not lost.The main function of log files is to prevent data loss when a database fails. To prevent Log File faults,Oracle allows the use of image
Related indicators
1. Database Hot Backup in seconds and transactions (cross-operating system platform supported)
Monitors the database in real time and backs up the changed data to the standby database in seconds. At the same time, only the successful transactions of the primary database are backed up.
2. the standby
, and find the appropriate workaround.
(3). Look for opportunities for database Performance tuning
Compare monitoring reports for database performance on a daily basis to determine if database performance needs to be adjusted
(4). Database Performance Tuning
If necessary, perform performance tuning
(5). Proposed Nex
Tags: tool transfer evaluation limit user ACK Oracle database user management storage space Database auditDirectory + 1. Overview of database Security control policies + 2. User Management + 3. Resource Restriction and password management + 4. Rights Management + 5. Role Management + 6.
log document in the Oracle read control document. This method is often used in database maintenance operations, such as renaming data documents, changing duplicate logs, and opening and archiving methods. In this way, in addition to the SGA system list, the system will also prompt "database load is complete.
STARTUP
T
installation problems
Document 1549168.1 most common 11gR2 RAC installation problems
Document 1602038.1: five most common problems that cause Scan VIP and Scan Listener faults
Document 1602033.1 RACcheck-RAC configuration audit tool
Document 1602035.1 top five common CRS Cluster patching problems
Document 1602076.1 five most common database and/or instance performance problems in the RAC environment
Docume
database silently[Oracle]#安装# #会出现密码不规范的警告, ignore/home/oracle/database/runinstaller-silent-ignoreprereq-responsefile/home/oracle/database/response/db_ Install.rsp# #查看安装过程 Open another shell, wait a minute.Tail-f/home/
audit tool
Document 1602035.1 top five common CRS Cluster patching Problems
Document 1602076.1 five most common database and/or instance performance problems in the RAC Environment
Document 1602417.1 10g and 11gR1 ASM Best Practices
Document 1602450.1 ASM 11gR2: how to upgrade the ASM instance to version 11gR2 (11.2.0.X )?
Document 1602048.1 common 11gR2 Grid Infrastructure upgrade ProblemsHigh Availabilit
The ORACLE tutorial is about Oracle database backup. I. significance:When we use a database, we always hope that the database content is reliable and correct. However, due to computer system faults (hardware faults, network faults, processes)Faults and system faults) affect
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.