Database Administrator

1. Check the original undo tablespace: Select file_name, bytes/1024/1024 as MB from dba_data_files where tablespace_name like 'undo % '; 2. Create a New undo tablespace: Create undo tablespace undotbs2 datafile

Restore with rman, current redo log corruption1. Full database backupRMAN> run {Allocate channel c1 type disk maxpiecesize = 500 m;Backup current controlfile format '+ dgasm/backup/haozg/ctl _ % d _ % s ';Backup full database format' +

-- The archive log file of the test database has been accidentally deleted. The solution is as follows: RMAN> backup as compressed backupset database plus archivelog delete input; Start backup from 24-2-12The current log is archived.Use channel

(1) show parameter db_recovery; view the Oracle flash recovery target and recovery zone sizeSQL> show parameter db_recovery;NAME TYPE VALUE-----------------------------------------------------------------------------Db_recovery_file_dest

ORA-07445: exception encountered: core dump [kghalkaline () + 58] [SIGSEGV] [Address not mapped to object] [0x000000068] [] [] DUMP File * ** Service name :( orcl) 2012-07-12 14:18:55. 016 * ** Session id: (258.58198) 14:18:55. 016 Exception signal:

1. Hbase is a subproject of Hadoop. Download the appropriate Hbase version here. Note: versions of Hadoop and Hbase cannot be used randomly. Therefore, you need to know whether to work together before deploying the service. Otherwise, it will be a

In a join SQL statement in Mysql, The ON Clause syntax format is table1.column _ name = table2.column _ name. When the columns in the pattern design couplet join table adopt the same naming style, you can use the USING syntax to simplify the ON

BackupBackup is used as a means of redundancy to prevent errors or downtime.I. Oracle backup can be divided into two types: physical backup and logical backup.1. Physical backup: copy, copy files such as datafile and control file to other

ORA-2020 errors occur when the number of dblinks used by a distributed transaction exceeds the threshold defined by the open_links parameter:Oracle @ ibmvs_a @/oracle $ oerr ora 2020.02020,000 00, "too connected database links in use"// * Cause: The

The order of stopping the Oracle Applications service is: Stop application product services and then stop database services; The sequence for starting Oracle Applications services is to start database-related services and then start application

Under what circumstances does Oracle select generate redo? 1 ') Fast block clearing or commit cleanout. When a transaction is committed, oracle marks the flag in the itl entry of the data block as U 2) sets the commit scn In the Scn/Fsc column.

First, let's talk about the truncate command:Syntax: truncate table;The data in the table is cleared and the storage space is released.After the task is run, the task is automatically submitted, including other uncommitted sessions. Once the task is

1. Uninstall the original mysql: Uninstall 1:Input:# Rpm-qa | grep-I mysqlDisplay:Mysql-libs-5.1.52-1.el6_0.1.i686Uninstall method:Yum-y remove mysql-libs-5.1.52-1.el6_0.1.i686 Uninstall 2:Input:# Rpm-qa | grep-I

During Oracle reading, data is static and there is no dirty read, that is, uncommitted data will never be read. We can understand that at the beginning of Oracle's reading, we took a "photo" for his future content and fixed all the content at a time

1. Restrict access from specific IP addresses. You only need to add the -- bind_ip parameter at startup, and add the -- host parameter at client connection./App/mongo/mongodb/bin/mongod -- dbpath =/app/mongo/mongodb/data/test -- logpath

RMAN is a required management tool for Oracle Database Backup management. There are many ways to operate it. I sorted out some common operation commands and summarized them to facilitate work. 1. database backup operation commands Simplified Version

0. Summary Oracle version: 32-bit Oracle Database 11.2.0.1.0 OS Version: 32-bit WinXP SP3 Primary database SID: primary Slave database SID: standby Advantage: Using RMAN to create a mongouard does not require the master database to go down, which is

The restore node reports an error on DP 6.1 linux Client because the backup node configuration cannot be saved. The following method can be used to solve the problem, it is to rename the upper-case configuration file on the Cell Manager to the lower-

Under normal circumstances, you can change the user password in Oracle EBS in System administrator> Define user form, but sometimes, you need to change the password more quickly during development or implementation, you can use the script below

Oracle rac ocr and voting disk management tips. For more information, see. The Oracle Cluster Registry (OCR) file is a key component of CRS. Used to maintain information about High Availability components in the Cluster. For example, the Cluster