Database Administrator

RMAN recovery steps and troubleshooting1. Install OS + Oracle Software on the testing machine, including configuring oracle users, groups, and environment variables (omitted). 2. Start recovery from different machines. copy the latest backup set,

How can I avoid resetlogs from opening the database after the control file is restored? After the control file is restored, the database is opened using resetlogs, and the sequence of online logs is reset. SYS @ practice> select group #, sequence #,

Performance impact of Delete on table data deletionAs mentioned in the previous article (), when we use delete to delete data, because the high water level cannot be lowered, a full table scan will cause database performance problems, the truncate

Oracle index tablespace data file loss and Reconstruction Re-create index:Use the following options to shorten the time required to create an index: PARALLEL NOLOGGING PARALLEL (NOPARALLEL is the default value): multiple processes can work together

The period for changing the Oracle password is unlimited. Oracle error message ORA-28001: the password has expired, due to new features of Oracle11G, the default password expiration limit for Oracle 11g User Creation is 180 days (6 months ), if the

Oracle cancel-based Incomplete recovery Experiment: Oracle cancel-based Incomplete recovery View lab environment Lsnrctl statusSelect open_mode from v $ database;-- Monitoring and database status Show parameter recovery;Select flashback_on from v $

Mysql generates a complete Stored Procedure Definition Statement. mysql Stored Procedure Select concat ('pr _ ', p. db ,'. ', p. name) FileName, CONCAT ('delimi', 'TER $ USE '', p. db, ''$ drop procedure if exists'', p. name, ''$ create definer = ',

ORA-38760: This database instance failed to turn on flashback database, ora-38760flashbackORA-38760: This database instance failed to turn on flashback databaseProblem Background:Test the database to execute shutdown immediate, the log reports an

Cocould not drop object 'student 'because it is referenced by a foreign key constraint, constraint 1. Find foreign keys SELECT * FROM sys. foreign_keysWHERE referenced_object_id = object_id ('student ') 2. Delete foreign keys SELECT 'alter table' +

WAS7 adds the "Login Password Authentication" method, was7 Login Password Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

Difference in the usage of in/not in and exists/not exists in SQL, sqlexists 1; first, the usage of in/not in In/not in is used to determine whether a single attribute value matches a given value or a subquery value; Select * from Student s where s.

Redis source code analysis () --- create and release a redisObject object, redisredisobject Today's learning efficiency is relatively high. After analyzing Rio, I learned the RedisObject file, which is about converting and creating RedisObject. Most

Solution for modifying uuid in Vboxmanage: vboxmanageuuid My environment: Virtualbox 4.3.10 r93012 Operating System: win7   Problem: a uuid conflict is prompted when Virtualbox uses the copied Virtual Disk: Because a hard disk with uuid ''already

Oracle ceil rounded up and ceil rounded upSelect ceil (3.05/0.5), 3.05/0.5 from dual;Ceil (3.05/0.5) = 73.05/0.5 = 6.1Ceil (3.55/0.5) = 83.55/0.5 = 7.1Oracle integer Functions Ceil (x) rounded upFloor (x) rounded downRound (x, n) is an integer when

DbVisualizer Personal: a common solution to Chinese Garbled text, dbvisualizerIn SQL Commander, if the SQL statement contains Chinese characters, the display is a port. The solution is as follows: In Tools> Tool Properties> General> Appearance>

First understanding of MySQL stored procedures, mysql stored proceduresStored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database, you can call and execute a stored procedure by specifying its name

Shell to export each mysql stored procedure as a single file, # Shell implementation: export the Stored Procedure Code in mysql as the file dbcn = "mysql-h172.16.1.194-uroot-p123456"; db = BCReport_Sync_Executor; ii = 0; ct = '$ dbcn-N-e "select

Analysis of paradigm graphics and Paradigm First, I would like to summarize the problems solved by the five normal patterns that need to be analyzed in one sentence: 1NF: attribute atomicity 2NF: partially dependent 3NF: Pass dependency (key

The use of rownum In the result set sorting in Oracle, using lerownumUse of rownum in Oracle for sorting in result setsFor the rownum problem in Oracle, many documents do not support>, >=, =, between... and. The preceding symbols can only be used (,>

GoldenGate Lag For Huge Insert, goldengatelagThe customer's ogg was delayed for about 8 hours the other day, so I tracked it with logdump: View the Process status:Send extsa staus EXTRACT ZBDBA (PID 2269368) Current status: Recovery complete: