primary database, once confirmed by the business, it can be discarded. Or you can use other methods to find the data. But it is imperative to restore the database immediately.3. Check the backup and time point on the slave database of the backup:
Crontab-l
#0 3 ***/data/opdir/mysqlbak/backup_mysqldump.sh 6084>/data/opdir/mysqlbak/6084/mysql-bakup.log 2> amp; 1
The backup task was commented out.
View the backup file:
[root@localhost 6084]# lltotal 128drwxr-xr-x 2 root root 4096 Aug 25 03:13 2
These days have often been on top of the OEM. I have just solved an OEM problem a few days ago and I have encountered it again today.
Oracle Installation OEM error: cannot unlock all em-related accounts Solution
Http://blog.csdn.net/tianlesoftware/article/details/6816938
I was planning to install Oracle 11gr2. Then upgrade it to 0.3. The final installation error is returned. Em cannot work.
Prepare to check the EM status. Run the command to prompt that the environment variable is not configur
Linux Command exercise:[Root @ CentOS4 OK _008] # cat mytestHello world!Hello world 1Hello world 2Hello world 3[Root @ CentOS4 OK _008] # cat-n mytestHello world!Hello world 1Hello world 2Hello world 3[Root @ CentOS4 OK _008] # cat-B mytest1 Hello world!2 Hello world 13 Hello world 24 hello world 3 from the above Linux commands we can verify the difference between-n and-B.[Root @ CentOS4 OK _008] # cat-B-E mytest1 Hello world! $2 Hello world 1 $3 Hello world 2 $4 hello world 3 $Each line ends w
Why Choose FreeRTOSUcos more information, especially Chinese information. FreeRTOS information is small, and most are in English. The reasons are as follows:
1.FreeRTOS free. Ucos charges. That's the main reason.2. Many semiconductor manufacturers, using FreeRTOS as their operating systemLow number of 3.FreeRTOS files
Download Addresshttp://www.freertos.org/
directory Structure
# ls-l Total
drwx------5 pi pi 4096 Sep 04:17 freertos
drwx------4 pi pi 4
This article will introduce you to your experience. When using ipve, rac hang is suspended due to the mistaken killing process, next, I will analyze the cause and provide a reference for the solution.
If the customer feedback system hang is in place and cannot be archived, we need urgent intervention for analysis.Node 1 logWhen redo logs are not archived, the redo logs are fully written, and the alter system archive log current is manually executed, the database starts to ARCHIVE all the redo lo
lucovsky 16-feb-1989\ Ntos \ ex \ zone. C mark lucovsky (Markl) 13-may-1989\ Ntos \ Inc \ dbgk. h mark lucovsky (Markl) 19-Jan-1990\ Ntos \ Inc \ ex. h mark lucovsky (Markl) 23-feb-1989\ Ntos \ Inc \ ps. h mark lucovsky 16-feb-1989\ Ntos \ KD \ Alpha \ kdcpuapi. C mark lucovsky (Markl) 04-sep-1990\ Ntos \ KD \ Alpha \ kdpcpu. h mark lucovsky (Markl) 29-aug-1990\ Ntos \ KD \ i386 \ kdcpuapi. C mark lucovsky (Markl) 04-
Customer feedback system Hang live, can not be archived, we need urgent intervention analysisNode 1st logRedo cannot be archived, redo logs have been filled, and the database has been manually executing alter SYSTEM ARCHIVE log current, but the subsequent redo cannot be archived, and when redo is fully written, Database has a large number of log file switch (archiving needed) waiting
The code is as follows
Copy Code
Tue Sep
A friend came to me and said they couldn't start the database, the database started Ora-600[k2vcbk_2] Error, the database version is 11.2.0.2 RAC, the operating system is AIX 6.1sql> Recover database;Media recovery complete.sql> ALTER DATABASE open;ALTER DATABASE Open*ERROR at line 1:Ora-01092:oracle instance terminated. Disconnection forcedOra-00600:internal error code, arguments: [K2vcbk_2], [], [], [], [], [], [],[], [], [], [], []Process id:7930020Session id:49 Serial number:14761Database no
too early. Let's analyze it and make a decision.Check the redo switching frequency of the database. In the last few days, the redo switching frequency is extremely high, which is a very high load for An OLTP system, I have encountered this frequent log switching only in some data migration scenarios.
However, the strange thing is to view the database time, but it seems that this value is not very high. It seems that there are some contradictions. From this point of view, the frequency of dat
Because there are not many flash areas, select * from v $ flash_recovery_area_usage and find that the backup set occupies too much space.So delete obsolete; found the error ORA-19606: Cannot copy or restore to snapshot control file
RMAN> delete obsolete;
RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1Allocated channel: ORA_DISK_1Channel ORA_DISK_1: SID = 174 device type = DISKDeleting the following obsolete backups and copies:Type Key Completion T
installationThe specific installation process does not describe too much, only a few ASM parts.The second option, Configure ASM on NFS, is used here, and when this option is used, the system automatically creates the shared disk.Specify the location of OCR, next. When the grid component is installed and configured, the default is to create a 30G size disk ocrvfdgdisk0 for the OCRVFDG disk group, as follows:[[emailprotected] ~]# la /u02/asmrac/total 33Gdrwxr-xr-x 2 grid oinstall 40
Because flasharea is not much, select * fromv $ flash_recovery_area_usage and find that the backup set occupies too much space. So deleteobsolet
Because there are not many flash areas, select * from v $ flash_recovery_area_usage and find that the backup set occupies too much space. So delete obsolet
Because there are not many flash areas, select * from v $ flash_recovery_area_usage and find that the backup set occupies too much space.So delete obsolete; found the error ORA-19606: Cannot cop
"OCR_VOTE01" is a valid ASM disk on device [8,21][Root@tysy1 disks]#/etc/init.d/oracleasm querydisk-d ocr_vote02Disk "OCR_VOTE02" is a valid ASM disk on device [8,22][Root@tysy1 disks]#/etc/init.d/oracleasm querydisk-d ocr_vote03Disk "Ocr_vote03" is a valid ASM disk on device [8,23][Root@tysy1 disks]# ls-ltr/dev/sdb*BRW-RW----1 root disk 8, Sep 1 20:23/dev/sdbBRW-RW----1 root disk 8, Sep 1 20:23/dev/sdb1BR
Lftp is a tool that supports downloading, uploading, and screen usage. It is equivalent to an ftp client that supports file access.Protocols include ftp, ftps, http, https, hftp, and fish.
1. login method:
Lftp User name: password @ IP Address
[root@zhu2 ~]# lftp zhu:123456@192.168.70.137lftp zhu@192.168.70.137:~> ls -ldrwxr-xr-x 9 500 500 4096 Sep 09 16:02 LVS-rw-r--r-- 1 500 500 0
2016-01-30 Mount Failure Problem resolution[Email protected] ~]# MOUNT/DEV/SDC/DTAMount:you must specify the filesystem type[Email protected] ~]#[Email protected] ~]# mount-t ext4/dev/sdc1/dataMount:wrong fs type, bad option, bad Superblock ON/DEV/SDC1,Missing codepage or helper program, or other errorIn some cases useful info are found in Syslog-tryDMESG | Tail or so[[emailprotected] ~]# cat/proc/filesystemsnodev sysfsnodev rootfsnodev bdevnodev procnodev Cgroupnodev Cpusetnodev tmpfsnodev de
"/y
Net stop "NAVAPSVC"/y
Net stop "NISUM"/y
Net stop "SYMPROXYSVC"/y
Net stop "RESCUE32"/y
Net stop "NISSERV"/y
Net stop "ATRACK"/y
Net stop "IAMAPP"/y
Net stop "LUCOMSERVER"/y
Net stop "LUALL"/y
Net stop "NMAIN"/y
Net stop "NAVW32"/y
Net stop "NAVAPW32"/y
Net stop "VSSTAT"/y
Net stop "VSHWIN32"/y
Net stop "AVSYNMGR"/y
Net stop "AVCONSOL"/y
Net stop "WEBTRAP"/y
Net stop "POP3TRAP"/y
Net stop "PCCMAIN"/y
Net stop "PCCIOMON"/y
Net stop "Virtual CD v4 Security service (SDK-Version)"/y
Net stop "No
/logs/1001. log and path/home/aircom/mongodb-linux-i686-2.0.6/bin/logs/1002.log
Tag mongo. apache to facilitate match.
Type forward
# Dumping ServerHost 192.168.19.201
Host 192.168.19.201
The two machines can be added as backup machines. The IP addresses of the master and slave machines are the same, and different IP addresses can be added in the production environment.
2. Configure fluent. conf on Server201
To facilitate the test, we directly modify and open the comment, which
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.