Database Administrator

Environment: Linux Version: 2.6.9-22. ELsmp Data Protecter Version: A.06.00 DP Server: Installed in Windows 2003 The following is a brief introduction to the installation process. 1. Attach the installation disc to the optical drive and mount

The undo tablespace cannot be opened because it is damaged. When the undo tablespace file in the database is corrupted or the undo tablespace file is missing, the database cannot be opened. Both cases can be considered as one case, and the solution

As we all know, undo is designed to ensure consistent read. That is to say, if you are not submitting the changed data, other sessions cannot view the changed content, if the other party reads the data, the data is still the previous data, and the

Note: It is well known that spfileSID will be searched under $ ORACLE_HOME/dbsx when the Oracle database is started. the ora file starts the system based on the parameters configured above. I believe many shoes have been opened, configured, and

Lab requirement: Configure mysql-mmm to achieve high availability of mysql MySQL-MMM for MySQL High Availability MySQL-MMM switching demonstration Mysql proxy and MySQL-MMM achieve high availability of read/write splitting Restore the MySQL-MMM

Prerequisites: we should make a statement in advance to ensure security. You cannot remotely log on to the initialized MySQL instance. To achieve logon, we strongly recommend that you create a user with a lower permission to log on remotely. Direct

10.2.0.5 on windows 64 bit Phenomenon: Copy backupset from server A to server B. Recover from server B. First, use 'catalog start with' to catalog backupset. When restoring the database, the following error occurs: RMAN> restore database

Example of Oracle analysis function OVER --- Create a test table SQL> desc t_test;Is the name empty? Type--------------------------------------------------------------------------- T_ID NUMBERT_GROUP NUMBERT_NUM NUMBER  SQL> select * from

Connect to the SUSE Linux service through ssh. Command for setting system time:, January 1 Date -- set = "04/01/14" Step 1: Start the listener;Su-Oracle -- "switch to oracle user"Lsnrctl start -- "enable listener"Step 2: Start the database instance.

Database is 10.2.0.4 operating system is aix, when executing expdp export multiple scheme objects times ORA-39014, ORA-39029, ORA-31671, ORA-39079, ORA-06512, ORA-04031: error message is as follows:Export: Release 10.2.0.4.0-64bit Production on

MySQL management-backup and recovery You must be aware of the importance of data. Here we have to briefly introduce the importance of backup: Backup is a means to ensure availability, but it cannot be guaranteed. For scenarios with high data

I. Environment Information 1) master database (Single Instance) Host platform: AIX6.1 Database Version: 11.2.0.3 (psu5) 2) slave database (crs deployed) Host platform: AIX6.1 Database Version: 11.2.0.3 (psu5) Ii. Background As the business volume

When exp exports data, the output log reports the EXP-00091: Exporting questionable statistics error, especially for some exp scripts executed in crontab. The cause of this error is that the export end nls_lang parameter is not set, or the setting

Use expdp When the EXPDP tool is used, its dump file can only be stored in the OS directory corresponding to the DIRECTORY object, rather than directly specifying the OS DIRECTORY where the dump file is located. Therefore, when using the EXPDP tool,

1. The master database encountered a ORA-01093 error while converting the role of the physical master/Slave Database SQL> select switchover_status from v $ database;SWITCHOVER_STATUS--------------------Sessions active ---------- there is an ACTIVE

I/o throughput is a factor that affects data redo. Oracle media recovery depends on I/o. If I/o has a bottleneck, this will inevitably affect the recovery of the standby database media. I/o stack contains hbas, storage related switches, and storage

Commands of the Oracle dump File Include exp/imp and expdp/impdp. For dump files, we cannot extract data directly, but we can extract the corresponding DDL statements from the dump file through relevant parameters. Description of how Oracle extracts

1. Modify the/etc/oratab FileChange the number of databases that need to be started with the operating system from N to Y.Lis:/u01/app/Oracle/product/11.2.0/db_1: NTo:Lis:/u01/app/oracle/product/11.2.0/db_1: Y 2. Edit the dbstart and dbshut scripts

In Versions later than 11.2, crs is called gi. It is very convenient to use crsctl stop cluster to shut down the resources of the entire instance, but the database instance needs to be closed separately, stop cluster ends an instance in an abnormal

1. Environment Description and precautions Operating System: Oracle Linux 5.4 (32-bit) Object: Install Grid Infrastructure on an independent server and install Oracle Database (data files are stored in the ASM disk group) Completion Time: 1 H