Database Administrator

1. Complete table creation syntaxCreate table [schema.] table(Column datatype [, column datatype]… )[TABLESPACE tablespace][PCTFREE integer][PCTUSED integer][INITRANS integer][MAXTRANS integer][STORAGE storage-clause][LOGGING | NOLOGGING][CACHE |

When the control file is lost in Oracle, sometimes we can only recreate the control file. The specific syntax is as follows: Create controlfile reuse database "SQUAN" NORESETLOGS ARCHIVELOGMAXLOGFILES 16MAXLOGMEMBERS 3MAXDATAFILES 100MAXINSTANCES 8#

The following error occurs when rman backs up archivelog: RMAN> backup archivelog all delete input; Starting backup at 14-APR-14 Current log archived Using channel ORA_DISK_1 Using channel ORA_DISK_2 RMAN-00571: ======================================

I found that Oracle's service and listener services started normally today, but the sqlplus logon prompt is as follows: ERROR: A ORA-01034: ORACLE not available ORA-27101: shared memory realm does notexist Most of the solutions to this problem

When logging on to the Oracle Management Server according to the document, the first login is successful. If you log on again after shutdown, the following error may occur: domain name resolution error or login denied error. The error is because the

I accidentally found that my DB2 test environment could not be used. I always reported an error when I opened it. I always thought it was db2audit and reported an error. DB2 database performance adjustment and optimization (1st and 2) PDF DB2

Scenario: Some colleagues need to synchronize data from the database to the new environment. However, they find that the execution of the count Statement on the master database is different from the execution of the count Statement on the slave

MongoDB has been widely used as a NoSQL Database in recent years. More and more enterprises are trying to use MongoDB instead of the original Database. MongoDB also performs well in clusters, sharding, and replication. I will introduce various

Determine the data file, log file, and tempfile information of the original database. Select group #, status, type, member from v $ logfile;Col name format a65Select file #, name, bytes/1024/1024 MB from v $ datafile;Select name from v $ controlfile;

-- Test environment:OS: RedHat linux (64)Primary:IP: 192.168.94.198SID: dgdb1Hostname: dg1DB_UNIQUE_NAME: dgdb1Database: 10.2.0.1 (64)Standby:IP: 192.168.94.199SID: dgdb1Hostname: dg2DB_UNIQUE_NAME: dgdb1_sDatabase: 10.2.0.1 (64)  -- Preparations

Error message in ALERT Log: Mon Jan 20 15:03:22 2014Incremental checkpoint up to RBA [0x442f. abd.0], current log tail at RBA [0x442f. 338a. 0]Mon Jan 20 15:08:13 2014Errors in

The following error is reported: Mon Mar 31 18:45:59 2014Errors in file/Oracle/app/oracle/diag/rdbms/zscims/zscims2/trace/zscims2_ora_11403518.trc (incident = 28382 ):ORA-00600: Internal error code, parameter: [kqlnrc_1], [0x7000003F55C3B60], [], [],

Start an Oracle database instance in Linux: Step 1: Start the listener; Step 2: Start the database instance.I. How to start a database instance1. Go to sqlplus to start the instanceSu-oracle -- "switch to oracle user"Lsnrctl start -- "enable

There is no way in the world, and when there are more people, the road will become. Why can't I create a MongoDB on ipvs? After taking a series of actions in NoSQL, The Postgres community is not waiting. Postgres has been making progress:

Oracle ASH (Active Session History) is a fine-grained AWR Report, which is often applied in our performance tuning process. Like all monitoring methods, ASH is based on regular performance data sampling and collection, and finally centralized

Verify the validity of RMAN backup 1. restore preview commandThis command is used to check which backup set is used for restoration to perform specific restoration.Restore database preview;2. Use the restore command of the validate and check

Oracle Database is developing to this day, and I/O is king. One of the important features of the ExtraData all-in-one machine is to maximize the I/O capability and increase the I/O throughput. Compared with CPU and memory, IO Storage has its own

With the continuous development and increase of the technical environment, the O & M department is facing two trends: large-scale and complex. One or two O & M personnel can manage hundreds of servers in the company in the future. At this time, the

Full recovery: only the corrupted data file is restored, and the file is restored independently. The log Sequence starting from the backup to the current log sequence cannot be reduced. Passive Incomplete recovery: one or more log sequences

Generally, DBA and SA must maintain a correspondence between the OS disk and the disk in the Oracle database ASM Group when managing the disk.If SA is uncertain or DBA cannot be found, use the following method to find the corresponding relationship.