Database Administrator

RMAN backup and recovery-full recovery and Incomplete recoveryGlossary: As the name suggests, full recovery means that the index data has not been lost. Incomplete recovery refers to the loss of some data after recovery. They are two recovery

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have

Redis (4) for beginners-Sort Redis cache and redis Before implementing the cache sorting function, you must first clarify the rationality of this function. Now that you can sort data in the database, why do you need to put the sorting function in

MonjaDB is a MongoDB GUI client tool that provides intuitive MongoDB data management functions and supports Windows, Mac, and Linux. MonjaDB is an Eclipse plug-in that must be installed first. Main features: Easy to use WYSIWYG edit

Football and oracle series (5): The directX library missing in the voda14 game is similar to the oracle rpm package, fifa 14rpm **************************************** ******************************** ************** Original Works are from the blog

Centos7: The correct command for installing mariadb, centos7mariadb The centos7 System of linode is used, and mariadb is used by default when mysql is installed. However, no matter whether you use the linode official website instructions or the

Sqlite study notes 7: Open the database using sqlite in C language, sqlite Study Notes The basic content of the database has been mentioned earlier. Next, let's take a look at how to use sqlite in the C language. Interface 1 sqlite3_open(const char

Transaction Processing and concurrency control, transaction processing Concurrency Control What is a transaction? Is a mechanism, an operation sequence, it contains a group of database operation commands, and all the commands as a whole, together to

Oracle Database permission management and oracle permission managementPermission management: the default three usernames and passwords in oracle 9: sys change_on_install // the Administrator with the highest permissions: system manager // normal

(1) remote TELNET to back up data to the SHLL script of the tape drive Lgmfcm:/u01/Oracle/CIC/BACKUP] cat TAPE_BACKUP.sh:$ {OK = 0 }$ {FAIL = 1 }$ {CANCEL = 3}: $ {MM = 'date + % m '}: $ {DD = 'date + % d '}: $ {YY = 'date + % y '}: $ {DEVFILn =

SQL statement optimization: optimization of JOIN, LEFT JOIN and RIGHT JOIN statements; sqljoin In database applications, we often need to perform multi-table queries on the database. However, when the data volume is large, multi-table queries have a

Sqoop import data time date type error, sqoop import data date A problem has been plagued for a long time. When sqoop import is used to import data from a mysql database to HDFS, an error is reported until an invalid value of the time and date type

Preface Indexes are one of the most important objects in relational databases. They can significantly reduce disk I/O and logical read consumption and improve the query performance of SELECT statements. However, it is a double-edged sword. Improper

1. Prepared hostNode1: 172.16.133.11Node2: 172.16.133.12MySQL has been installed.MySQL installation see: http://5142926.blog.51cto.com/5132926/9356522. mysql master-slave ReplicationNode1: master serverNode2: slave server(1) node1:Enable binary log (

MongoDB data model and index learning summary, mongodb ModelMongoDB data model and index learning Summary 1. MongoDB Data Model: MongoDB data storage structure:MongoDB uses BSON (binary json, binary encoding) data format for document (large files

DB link migration (the password in dblink is unknown), dbdblinkI don't know if DBAs sometimes encounter such a situation where the Public db link is used for Schema migration. However, the target account password in db link is unknown, therefore,

About Oracle Database shutdown and Oracle Database Shutdown I have talked about Oracle Database startup before. Let's talk about Oracle Database shutdown today. I. Three Phases of database ShutdownThe Oracle Database startup process involves three

In Oracle, table columns are changed from VARCHAR2 to CLOB and varchar2clob.Scenario The columns in the original table are defined as the VARCHAR2 type. As we all know, the maximum length of the VARCHAR2 type is 4000. If you want to convert this

How to deal with the rapid growth of oracle archive logs, oracle archive logs Oracle archive logs are generally generated by dml statements, so the increase speed should be too frequent by dml. First, query the generation of the following daily

I. Introduction Since you and your team have successfully developed and deployed an INTERNET website, this website has attracted thousands of users to register and use in a short period of time, therefore, you have a very satisfied customer.