NAV: SLTechnology News&Howtos > Database >

• 

  Treatment of RMAN-06054 problem of RMAN duplicate recovery Database error

  Recently, if you want to make a big move in production, you need to restore the backup of the production library to another machine every day for testing. So thought of using the way of DUPLIDATE, simple and convenient, early configuration of the directory, and then a command can restore the library. So I wrote a recovery script and passed the test.

  2022-06-01 15:09:32 Views: 272
• 

  Manage ORACLE instances

  Initialization parameter file:-PFILE:Static parameter file,PFILE-SPFILE:Persistent server parameter file,SPFILEPFILE-- ini

  2022-06-01 15:09:05 Views: 254
• 

  The most practical Construction method of cdh4 Cloud Storage

  What is cdh? CDH is Cloudera's 100% open source Hadoop distribution, built specifically to meet enterpris

  2022-06-01 15:09:05 Views: 206
• 

  Nosql redis-2.8.10 source code installation

  Redis introduction: redis is currently one of the more popular NOSQL systems, it is a key-value storage system. Similar to Memcached, but largely compensates for the shortcomings of memcached, which supports relatively more value types of storage

  2022-06-01 15:09:04 Views: 240
• 

  Quickly create a personal forum

  Environment preparation: system: centos 7 required packages: lamp environment (httpd, PHP, php-mysql, mariadb-server), discuz] # yum install-y httpd php p

  2022-06-01 15:09:01 Views: 259
• 

  Mysql creates users and databases

  Query the current db:1 select database () 2 status 3 show tablesCREATE USER 'pig'@'%' IDENTIFIED BY'; use mysqlcre

  2022-06-01 15:09:01 Views: 224
• 

  SqlServer series notes-query filtering, grouping and sorting

  DISTINCTDISTINCT repeats data for the entire result set, not for each column, so the following statement does not leave only Fdepartment for duplicate value processing: SELECT DISTINCT FDepartme

  2022-06-01 15:09:00 Views: 277
• 

  Oracle creates users, assigns permissions, and imports data

  Oracle has been using it for some time to create users, assign permissions, and import initial data, so take the time today to sort out the SQL statements used in this process. Step1: log in to sqlplusC:\ Users\ Administrator > s using the DBA user

  2022-06-01 15:09:00 Views: 268
• 

  How to open the SQL database service

  It is necessary to open the service when using the database. I would like to introduce several ways to turn on the service. I will show you all of these in the form of picture and text in three open ways. For friends who can't open the service, you can learn. These prerequisites are that your computer has installed SQL database, otherwise the database cannot be used.

  2022-06-01 15:08:47 Views: 239
• 

  Mongodb backup and recovery

  Mongodb provides two commands to back up (mongodump) and restore (mongorestore) data. The format of the data dump is BSON's 1.mongodump backup usage: bin/mongodump [op

  2022-06-01 15:08:47 Views: 258
• 

  Mysql5.7.21 installation documentation

  -- 1. Create a user group mysql, create a user mysql and add it to the user group mysql, and grant read and write access to groupadd mysql-- create a mysql user group useradd-r-g mysql mysql

  2022-06-01 15:08:46 Views: 267
• 

  Windows server 2012 uses sysdba to log in and report an error ORA-01031

  Error display: C:\ Users\ Administrator > sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Wednesday April 24

  2022-06-01 15:08:46 Views: 287
• 

  11g expdp+dblink backup database error

  11.2.0.4 Database. Remote backup database using expdp+dblink reports errors as follows: ORA-31679: Table data object "HIS". "AQULED_COM_SQL" has long

  2022-06-01 15:08:46 Views: 245
• 

  Oracle 11g R2 ADG operation and maintenance

  -- = Oracle ADG operation and maintenance =-- = test log transfer = 1. On primary, view the last archived log and force log cutting

  2022-06-01 15:08:46 Views: 285
• 

  Oracle views all table information

  Select tabschema,tabname,tabspace,numrow,tabsize (size in bytes), CREATED,LAST_DDL_TIME,tabtype- (1 for normal table, 2

  2022-06-01 15:08:45 Views: 249
• 

  Mysql multi-table deletion instance

  Mysql multiple table deletion while deleting a student's basic information, delete all the student's scores mysql > select * from stu_inf;+----+-

  2022-06-01 15:08:45 Views: 287
• 

  Oracle Cpu 100 us

  Yesterday's Mid-Autumn Festival was supposed to be a good day for reunion. I had to be on duty for the bitter operation and maintenance staff (, complain). I thought there would be nothing wrong. Who knew that a more important Oracle server suddenly called the police, and the two core of CPU soared to 100%. Load average is also better than that.

  2022-06-01 15:08:39 Views: 256
• 

  Ora-01017 no message file for product=RDBMS

  Windows server 2008 R2 RAC environment, which installed oracle version 11.2.0.1, and then upgraded to oracle version 11.2.0.4. Restart the computer and found that the database could not be started. The analysis steps are as follows: 1 enter cm

  2022-06-01 15:08:38 Views: 245
• 

  What's New in oracle12c Index Compression COMPRESS ADVANCED LOW

  Starting with oracle 12.1.0.2, index can be compressed through COMPRESS ADVANCED LOW when creating an index, create index index_name on table_name (

  2022-06-01 15:08:38 Views: 211
• 

  Say GTID-clear the execution history of GTID

  RESET MASTER can be used to clear the execution history of GTID. If you want to add a node that has performed local transactions to the Group Replication, you need to execute the RESET MASTER. Executive RESET MASTER meeting

  2022-06-01 15:08:38 Views: 204