Label:1. Environment Readiness 1.1 Confirm database version1.2 Confirming database archiving1.3 Backing Up Database files2 The database recovery after the analog control file is lost (Full recovery).2.1 Viewing Control file Locations2.2 Deleting a control file after performing an action2.3 Starting the databaseStart the database when the database error occurred, prompted unable to confirm the control file,
Operation Steps:
Factory pre-installed dos for Windows 8 hidden partition One-click Recovery 8.0 You can set up an initial backup to restore the initial backup state system use.
The specific actions are as follows:
1. The first time to get the machine, install the operating system Windows 8 system and factory random drive disc;
2. Boot Press F2 appear rescue System 4.0 interface Select one key recovery;
One, example demo Bacula Full recovery function
1. Full recovery via differential backup
Action steps are as follows:
*status status Available for:1: Director 2:storage 3:client 4:all Select daemon Type For status (1-4): 1 f10-64-build-dir version:3.0.2 (July 2009) X86_64-unknown-linux-gnu Redhat Daemon started 21-
Aug-09 15:01, 1 Job run since started. heap:heap=253,952 smbytes=84,808 max_bytes=
Oracle 11g restart uard undo restore environment: OS: centos5.5db: oracle11g datauardversion: 11.2.0.2.0 shrink data file size in primary ALTER DATABASE DATAFILE '/oracle/oradata/skatedb/undotbs03.dbf 'resize 1024 M; www.2cto.com will receive an alert message later. log on to the standby database and find it in alert. the following error occurs in logl ...... media Recovery Waiting for thread 1 sequence 17248 (in transit)
Recovery of. net unmanaged resources and recovery of. net managed resources
There are two ways to release unmanaged Resources
1. destructor
2. Implement the System. IDisposable Interface
I. destructor
The constructor can specify certain operations that must be performed when the class instance is created. When the Garbage Collector deletes an object, it can also call the destructor. At the beginning of th
Recovery of. net unmanaged resources and recovery of. net managed resources
There are two ways to release unmanaged Resources
1. destructor
2. Implement the System. IDisposable Interface
I. destructor
The constructor can specify certain operations that must be performed when the class instance is created. When the Garbage Collector deletes an object, it can also call the destructor. At the beginning of th
It is believed that many people have encountered the accidental deletion of data and asked the DBA to restore the data, but the user only knows the approximate time of occurrence. At this time, you may see that there are two backups at the same time as the error occurs. If you restore to the last one, you may have to check the data and find that something went wrong. If there are many logs, it takes a lot of time. Today, we see the Oracle recovery pri
Mysql common operations: mysql backup and recovery, mysql backup and recoveryLog on to mysql = mysql-uroot-p to view the database version select version ();
View DatabasesShow datases; view the current database select database (); view the current logon user select user (); View tables under a database; use db; show tables; view table fields; desc dong; create database db1; create table tb1 ('id' int (4), 'name' char (40) ENGINE = myisam default chars
MySQL5.6 backup and recovery command, mysql5.6 backup and recoveryBackup
Mysqldump-P 3010-h 130.51.2.24-uroot-proot zplatdb> backup. SQL
Restore
Recover to my local machine, because I have not set a password for this machine, the password is blank,-p there do not know fill in the token
Mysql-u root-p *** zplatdb
In fact, you can:
Mysql-u root zplatdb
In addition, you can also use the source command, which is simpler, but the time is much
Method 1: The original method is the built-in method of the Android system.After the phone is shut down, press "volume down key" + "power supply key". After seeing the power-on sign, we immediately release the power button, but the "volume down key" cannot be relaxed, in a few seconds, you can enter the Recovery mode.SecondIf master Zhuo is installed on the computer, we can connect the mobile phone to the computer, and th
When the iOS corruption in router needs to be restored, Ctrl+break (Packettrace is CTRL + C) When the router starts, enters Rommon mode, and the command prompt changes to: Rommon 1>Then enter the following command:Rommon 1>IP_ADDRESS=A.B.C.D//router's current IP addressRommon Subnet mask for 2>ip_subnet_mask:x.x.x.x//routerRommon 3>default_gateway=y.y.y.y//Router Default gatewayRommon 4>tftp_server=a.b.c.d//tftp Server IP AddressRommon 5>tftp_file=c2800nm-advipservicesk9-mz.124-15.t1.bin//iOS fi
Tags: SQL version data type Java Build database nbsp ERP software MDFData type SQL2008R2 database data capacity GB fault type in the Ransomware virus,. The extension was changed to arrow repair result client sent to encrypt database, using excellent SQL database repair Master 10.0 Direct scan ransomware virus database, generate new database MDF LDF directly by ER P software use. This extension arrow and Java Artea, and so on a few ransomware virus is encrypted 0-31 blocks, for the database file
Label:Recovering archived log filesIf you simply apply the archive after recovering the data file, you do not need to manually restore the archive file, and Rman automatically recovers the appropriate archive when recover.Recovering an archive separately is typically a special requirement, such as creating a data guard environment. Some archived files are missing from the standby side and need to be retrieved from the primary side.1. Recover all archived log filesRman> RESTORE ARCHIVELOG All;2.
to find the file from the TM, you can copy the file from the TM, but you want to recover the entire system (that is, including the system), you need to boot from the system disk to go in, speaking of system disks, they can be attached to a USB flash drive or a partition of a mobile hard disk. I like pure installation, so before the TM restoration, I formatted it and then restored it. This problem occurs.
Cause: There is a lack of recovery partitions
can restore the control file based on the text file of the control file backed up earlier.
Createcontrolfile reuse database "ORCL2" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
# MAXLOGHISTORY 292
LOGFILE
GROUP 1'/u01/tiger/oradata/orcl2/redo01.log' SIZE 50 M,
GROUP 2'/u01/tiger/oradata/orcl2/redo02.log 'SIZE 50 M,
GROUP 3 '/u01/tiger/oradata/orcl2/redo03.log' SIZE50M
DATAFILE
'/U01/tiger/oradata/orcl2/system01.dbf ',
'/U01/tiger/oradata/orcl2/tiger. dbf
to back up the control file to the trace fileTwo methods are available to control file recovery.1) Use recover database using backup controlfile in the mount status2) in the mount status, the trace file is generated and restored.
2-2 example:[Oracle @ localhost ~] $ Rlsqlplus/as sysdba
SQL * Plus: Release 10.2.0.1.0-Production on Monday August 1 21:40:03 2011
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected to an idle instance.
SQ
Case 3--A partial archive log was lost while doing a full recovery (recover database until cancel;)
1. Incomplete recovery based on cancel
--Simulation environment
Sql> Col table_name for A20
Sql> Col Tablespace_name for A10
Sql> select Table_name,tablespace_name from User_tables;
TABLE_NAME Tablespace
-------------------- ----------
DEPT USERS
EMP USERS
BONUS USERS
Salgrade USERS
EMPLOYEES USER
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.