Recently, the company needs to switch the Oracle database to another server and use EXP and IMP to export the import tool. After a long period of time, an error is returned... All kinds of tangle... Therefore, a simple cold Backup recovery mechanism is adopted. However, because the original database version is 10.2.0.1, the server to be switched is 10.2.0.5, and the company has a uniform database version of
Win8 permanent activation tool _ Windows 8 activation backup and restoration tool v1.0 free version
Based on the principle of the batchcompute version of Windows 8 Backup Recovery activation information tool, a Windows 8 Backup Recovery
password: ALTER user SYS identified by Ninestar123;Oracle failure, error file deletion: Alter DATABASE datafile '/u01/app/oracle/oradata/g6.ora ' offlinedrop; ALTER DATABASE datafile '/u01/app/oracle/oradata/g6a02.ora ' offline drop;Query database for lock table: SELECT * FROM Fw_lockresource R where R.isfree = 0;Delete Oracle User: Drop user ees2 cascade;Delete Table space: Drop tablespace ees2 including contents and datafiles cascade constraint;Modify user default tablespace: Alter users ees2
;/tmp/ Myserver.1.sql3. Analog failureProcess crashes[Email protected] ~]# killall mysqld mysqld_safeAll library files are missing[Email protected] ~]# rm-rf/var/lib/mysql/*4. Restoring a backupStart the service first[Email protected] ~]# systemctl start mariadbTo view the library files that have been built for repair[Email protected] ~]# ls/var/lib/mysql/aria_log.00000001 ibdata1 ib_logfile1 mysql.sock testAria_log_control IB_LOGFILE0 MySQL Performance_schemaBecause the process of
[Oracle] export and import of OCR backup and recovery
Back up and restore OCR using exported import:
Before adjusting the cluster, for example, adding or deleting nodes, you should back up OCR once. You can use export to back up to the specified file.
Lab environment:
OS: OEL5.6
RAC: 10.2.0.1.0
(1) Disable CRS for all nodes
Node 1:
[Root @ rac1 crsd] # crsctl stop crs
Stopping resources.
Successfully stoppe
count=1 2>/dev/null stty-raw stty echo stty $SAVEDSTTY} echo "" E Cho "Press any key to Start...or press CTRL + C to cancel" char= ' Get_char ' # Initialize the installation related conte NT. function Initinstall () {cat/etc/issue uname-a memtotal= ' free-m | grep Mem | awk ' {print $} ' E Cho-e "\ Nand Memory is: ${memtotal} MB" #Set timezone #rm-rf/etc/localtime #ln-S/usr/share/zoneinfo/asia/sh Anghai/etc/localtime #Delete old MySQL program rpm-qa|
1Database ' Hos ' has a consistency error in sysobjects, sysindexes, syscolumns, or systypes, which hinders further CHECKDB processing.DBCC execution is complete. If DBCC outputs an error message, contact your system administrator.DBCC detects a corrupted sysindexes,sysobjects,sysclocms system table that belongs to a serious damage! caused by a power outage, power failure, or forcibly shutting down the host, accidentally unplugging the plug, etc., resulting in a high-speed disk file system dama
Software Name: One-click Ghost Software version: 8.3 Operating environment: WINDOWS98/ME/2000/XP Software Size: 5194KB licensing mode: Free software
Download Address: http://www.xdowns.com/soft/6/145/2006/Soft_29836.html Now everyone computer installation is generally Windows XP system, and most do not have a floppy drive, due to the inability to enter pure DOS, And the previous version of the Ghost can not be run under NTFS, coupled with ghost opera
Discusses MySQL backup and recovery mechanisms, and how to maintain data tables, including the two most important types of tables: MyISAM and Innodb, the version of MySQL designed in this article is 5.0.22.
This article describes the use of MySQL with a free backup tool backup
This article discusses MySQL's backup and recovery mechanism, and how to maintain data tables, including the two most important types of tables: MyISAM and Innodb, and the MySQL version in this article is 5.0.22.
The free backup tools currently supported by MySQL are: mysqldump, mysqlhotcopy, and can be backed up with
your Oracle learning, and when you learn it, it's recommended to take notes, practice, and experiment.
################################################################### 1, Oracle industry introduction must SEE: oracle DBA Database Senior Engineer Career Learning guide and career Planning Video Course (free) Http://edu.51cto.com/course/course_id-7015.html2. Oracle Employment High-paying courses:Oracle DBA Database
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.