1. Concept? ? REDO Log is a mechanism established by Oracle to ensure that transactions that have been committed are not lost. In fact, the existence of the redo log is prepared for two scenarios:
Instance recovery (INSTANCE RECOVERY);
Medium recovery (media RECOVERY).
? ? The purpose of the instance
I have previously introduced:OracleDatabaseRMAN Incomplete recoveryThis document describes how to restore an Oracle database based on SCN.Log serial number recoveryTo help you.
Log serial number recovery refers to restoring the database to the status of the specified log serial number.
-- View archived log information
SQL> select * from t_user;
TEXT
--------------------
Java _
Spring _
Spring mvc _
SQL> insert into t_user select 'or
I. Mark data
Log On with the scott user and set the tag data
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
EMP_BAK
Creates a backup table emp_bak for the emp table.
Ii. Back up the database
1. Close the database cleanly.
SQL> shutdownimmediate
Databaseclosed.
Databasedismounted.
Oracle instance shut down.
2. Package backup data
[Oracle @ study oracle] $ tar-zcvf admin.tar.gz admin /
[Oracle @ study oracle] $ tar-zcvf oradata.tar.gz ora
Clusterrecovery.exe: server cluster recovery utilitycategory
Tool already ded in the Windows Server 2003 Resource Kit.Version compatibility
The server cluster recovery ity can be installed on computers running Windows Server 2003 and Windows XP Professional.
The server cluster recovery ity can target server clusters running Windows Server 2003, Enterprise Edition
Today, when I used exp/imp for a small backup and recovery operation, I encountered a problem. Many empty tables cannot be expressed. I didn't understand it at the beginning, later, I went to the Oracle official website and read Oracle data. I sent Oracle11g R2 with a new feature. When exp and imp are used, no segment is allocated when the table has no data, to save space. This will prevent the empty table data from being expressed. I want to say some
Oracle table data recovery and oracle Data Recovery
When you accidentally delete data in a table for table data recovery, you generally do not need to operate on the table any more. You can recover the data in the table as follows.
Scenario: If data in table test is accidentally deleted, the following methods can be used to restore data in the table:
Method 1:
First, use WinPE to make recovery CD
1, first on the development machine to adminstrator users run cmd, into the WES7 installation directory under the Petools folder, such as D:program fileswindows embedded Standard7toolspetools, Run the following command:
Copype.cmd x86 c:winpe_x86
If the target machine is 64 bits, the middle argument "x86" is replaced with "AMD64", and the following path can be arbitrarily specified.
2, then, enter the path spec
1. As shown in the following image, we press the power button at the top of the phone to wait for the iphone screen to turn off when the computer is turned off.
2. After shutdown, we do not turn on the Apple iphone and the computer with the original data cable link up (Recommended reading: How the Apple phone to connect to the computer)
3. Now we need to press the operation Fast to the Apple mobile phone DFU recovery mode
①, in the shutdown sta
This article mainly describes the Rman recovery scheme and Oracle Machine recovery, the need for friends can refer to the followingNote:The premise of ① recovery is that it is ready for backup② Full Recovery database is a database that is experiencing a failure to recover without losing any data that has been submitted
Summary of win10 system recovery methods and win10 System Recovery Summary
As the saying goes: When we often walk by the river, we can't avoid system crashes when we often use computers. Can we just take out the re-installed CD and USB flash disks at this time, if the system is win10, it is unnecessary (the method inherited from win8, so win8 can also be used in imitation), because the remedy measures of t
The simplest Oracle data recovery select as of usage, oracle Data Recovery
You perform a Flashback Query by using a SELECT statementwith an as of clause. you use a flashback query to restrieve data as it existed at some time in the past. the query explicitly references a past time by menasof timestamp or SCN. it returns committed data that was current at that point intime.You can perform a flashback query b
I. Cold backup1. When the database is shut down normally, you must know the name and path of the backup file before performing the cold backup.Copy codeThe Code is as follows:SQL> select name from v $ datefile;SQL> select name from v $ controlfile;SQL> select member from v $ logfile;
2. files to be backed up for cold backup include:All data files, all control files, and all online redo log files3. Cold backup steps① Shut down the instance to be backed up normally)② Copy all important files to th
There was a client recovery request this morning, and he accidentally used the RM-RF oradata command in the Solaris system to delete all the data files under one partition. Now do not know how to do, ask us to give support. Check it out. found that the database is not crash, it seems that directly consider the use of handle recoveryROOT@CNISORCLSVR # Uname-aSunOS cnisorclsvr 5.9 generic_112233-08 sun4u SPARC sunw,sun-fire-880ROOT@CNISORCLSVR # Ps-ef|g
last_change #.
You can first mount the database, and then query
Select last_time, last_change # from V $ datafile;
You can see. If a result is returned, it is disabled normally. If no result is returned, it is disabled abnormally.
Determine whether the file needs media recovery:
V $ datafile; From Control File
V $ datafile_header comes from the data file header.
colnamefora40selectname,CHECKPOINT_CHANGE#,CHECKPOINT_TIMEFROMV$DATAFILE;SELECTCHECKP
Openerp data backup and recovery, openerp backup and recoveryBack up the entire database:Use the backup file to restore the database:Notes:
It is best to write a script to automatically back up data
If you do not stop openerp When deleting a database, a prompt is displayed, indicating that the database is in use and cannot be deleted.
When data is restored, If you import the data directly without clearing the old data, an error is prompted and
Method 1
1, we first use the original method of the hands of the machine.
2, then we simultaneously press the phone volume + do not put, boot, until the interface appears robot, loosen the volume + as shown in the following figure.
3, after we press the power button, we can enter the recovery menu as shown in the following figure
Method 2
We search for a "Brush Machine Wizard" in Baidu as shown in the following image
[Figure] Samsung's most popular big screen Android mobile phone demonstrates three buttons with clear labelsIf you often play with Samsung mobile phones, you must know the functions of these three keys and can easily enter the engineering mode (recovery) hold down the volume, HOME, and power keys at the same time, and wait until the screen is on.The above is how most Samsung mobile phones enter the Recovery
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.