dba for dummies

online logs. 3: If a table is dropped at 10:30:00, how can we restore it with comprehensive archiving and backup?Manually copy back all backup data filesSQL> startup mount;SQL> alter database recover automatic until time '2017-08-04: 10: 30: 00 ';SQL> alter database open resetlogs; 4: What is rman and what are its characteristics?RMAN is an important DBA tool used to back up, restore, and restore oracle databases,RMAN can be used to back up and resto

Chapter 4 operation and maintenance-routine work of DBA (1) What are the four parts of a complete Oracle network environment? A: A Complete Oracle network environment should include database servers, [Management Servers], Oracle HTTP servers, and management clients. (4) What is a session? A: session is a means for Oracle database servers to record database-connected users. (8) What are the major differences between Oracle Database Upgrade a

Common Oracle DBA operations Modify language environment Change Chinese environment to English environment Alter session set als_language = 'American '; Change the English environment to a Chinese Environment Alter session set nls_language = 'simplified CHINESE '; Queries the tables owned by the user. Select table_name from user_tables; Query the name and purpose of a data dictionary table in oracle Select * from dictionary; Query the number

, and r are sorted by the number of records, time, query time, and number of returned records, ac, at, al, and ar indicate reverse descriptions;*-T indicates the top n, that is, the number of previous data records returned;*-G, followed by a regular expression matching mode, which is case insensitive; For example/Path/mysqldumpslow-s r-t 10/database/mysql/slow-logYou can obtain up to 10 queries from the returned record set./Path/mysqldumpslow-s t-t 10-g "left join"/database/mysql/slow-logObtain

User liuya9and10 Create View Create or replace view statsAs select 'stat... '| A. Name, B. ValueFrom v $ statname A, V $ mystat BWhere a. Statistic # = B. Statistic #Union allSelect 'latch. '| Name, getsFrom v $ LatchUnion allSelect 'stat... elapsed time', hsecs from V $ timer; Reported ORA-01031: insufficient privileges permissions are insufficient, strange that I have granted the user DBA permissions, Does the role not work when creating a view?

1. What is Oracle R12.2R12.2 DefinitionArchitectureAdvantages of R12.2Limitations of R12.2What the benefit business users would get from R12.2 2. Difference between R12.1 and R12.2 ArchitectureArchitectural difference between R12.1 and R12.2Advantages and disadvantages of R12.1 and R12.23. What's online patchingConcept of Online PatchingADV and disadvantage of Online pathing cycleLimitations of Online Patching4. Installation of R12.2Installation of R12.2Installation issues and fixes5. Upgrade of

(2) test data synchronization of the standby nodeFirst insert data in the Master node's DRBD file system, we insert 20 files[[emailprotected] data]# touch ‘seq 10‘[[emailprotected] data]# ls1 10 2 3 4 5 6 7 8 9 lost+found[[emailprotected] data]# touch `seq 10 20`To view the data synchronization of the standby node, we need to mount the DRBD storage device first, and we see that the data has been synchronized.[[emailprotected] ~]# mount/dev/sdb1/mntmount:you must specify the filesystem

establishes enough database connections when it starts and makes these connections a pool of connections that are dynamically applied, used, and released by the program to the connection in the pool.5. Introduction to Storage Engine1. View the storage engine for the table: Show table status like ' table name '.2.innoDB Engine: MySQL5.5 later version, InnoDB is the default engine.Pros: 1. Disaster recovery Good 2. Support for all 4 levels of transactions. 3. Use row-level locks. 4. Implementing

Mainly for Oracle DBA in the growth stage of the positioning, learning methods and other aspects of the classic discussion, the details please refer to the following.First, positioningOracle is divided into two chunks, one for development and one for management. Development is mainly about writing stored procedures, triggers and so on, and using Oracle's develop tool as a form. A bit similar to the programmer, need to have strong logical thinking and

. Also known as the action query language. Specific statements such as:Mysql> Delete from mysql.user where host= ' localhost ';Query OK, 2 rows affected (0.10 sec)Iii. Transaction Processing Language (TRL)Its statement ensures that all rows of the table affected by the DML statement are updated in a timely manner, and the TPL statements include Begin,transaction,commit and rollback. The main understanding of the latter two.Iv. Data Control Language (DCL)DCL Full Name (Data Control Language) It a

Recovery24.2 cold and recovery in non-archive modeSteps to 24.2.1 ColdRecovery of 24.2.2 Cold prepared24.2.3 Missing Redo log File recovery method24.3 Archive mode and non-archive mode24.3.1 Setting the archive mode of the database24.3.2 Setting the archive process parameters24.3.3 Managing archive files and archive directories24.4 steps to manually hot-standby a database24.5 How to deal with database crashes during hot standby24.6 Principle of hot preparation24.7 Backup Control files24.8 Princ

of data is too general to have a problem. Mysqldump > linzhongniao.sql Sed –e ‘s#MyISAM#Innodb#g’linzhongniao.sql > linzhongniao2.sql Mysql (3) Method 3, modify with the mysql_convert_table_format command [[emailprotected] bin]# mysql_convert_table_format --user=root --password=123456 --socket=/data/3306/mysql.sock --engin student [[emailprotected] ~]# mysql -uroot -p123456 -S /data/3306/mysql.sock -e "use linzhongniao;show create table student\G" *************************** 1. row **********

maintain the data dictionary of the database?16. Do you have development specifications, if any, how to execute the17, the table has a large paragraph x (for example: Text type), and the field X will not be updated frequently, to read as the main, please(1), you choose to split into a sub-table, or continue to put together;(2), write your reasons for such a choice.18, MySQL in the InnoDB engine is the row lock by adding on what to complete (or called implementation)? Why is that so?19. How to r

row in Set (0.00 sec)MySQL [linuxview]> DescriptionIf you do not want the field to be empty, you can add not null after the field property, and when the data is inserted, a null error will be added.Engine Set Search EnginesCharSet Setting the encoding Second, PHP Build library table Grammar:Mysqli_query (Connection,query,resultmode); {Die (' Create DATABASE failed: '. Mysqli_query ($conn));}echo "Create data table successfully \ n";Mysqli_close ($conn);?>[Email prote

asking questions, and the other is rd with no problem. However, most of the people who ask questions are important people in the company. Ask questions that represent a strong learning mind and good presentation skills.PG (Programmer) yards FarmBasically you have to have a few basic information skills to be able to do most of the information jobs 1. You must have at least one programming language C,c++,java. 2. You must be familiar with the Linux operating system (Management Management Server).

regarded as a bedroom, the entire server is a house, server hardware resources can be regarded as the house of the bathroom, kitchen is the public resources of the house. It's like being in a house in the north, so be sure to share the resources. In fact, many services can be many instances such as Nginx,apache,redias.5.1.2 MySQL multiple instances of the role and problems.5.1.2.1 Efficient use of server resourcesWhen a single server resource is left, you can take advantage of the remaining res

experience and test, in order to more comprehensive test software deficiencies or existing problems.(3) RC versionRC version belongs to a production environment before the release of a small version or a candidate, is the beta version of the test results collected by the bug or defect of the collected information, to repair and improve the product after.(4) GA version:GA version belongs to the release of software products, also known as production version of the product, in general, the product

(); +---------------------+ | now() | +---------------------+ | 2018-01-18 20:14:43 | +---------------------+ 1 row in set (0.01 sec) 9.6 Viewing the table information contained in the current database Switch to the database to view [emailprotected] 08:1630->show tables; Empty set (0.00 sec) 空表，新库还没有建表 [emailprotected] 08:1742->show tables like ‘user‘; Empty set (0.00 sec) [emailprotected] 08:2016->show tables from zbf; 查询指定数据库的表 Empty set (0.00 sec) [emailprotected] 08:2030->show tables in

use this method to specify properties such as Ttc_server. For the C language, these properties can be directly written directly to the DSN file This method only supports C/s connection, performance is inferior to direct connection. It does make sense for Java. This method is extremely useful, and the auto client failover scenario can make the test more concise. This method does not indicate that the client can not install the TimesTen client program* ReferenceHowto:create a tim

-- The above two phrases will intercept the transaction records, as long as they are executed, the transaction record is not successful until the next complete preparation!-- subtract log the size of the file (LOG file name reduced by up to DBCC Shrinkfile (beedb_log,+)/******** The position of the DB ********/-- Check the location of DBSelectname,Physical_name fromSYS.master_fileswheredatabase_id=db_id(' Salepony ')-- swap out the location of the DBAlter Database Salemodify file