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
oracle10g Database Recovery (RMAN recovery) tutorial
I. Automatic management of documentsIi. use of the Rman function, including all data archive maintenance and reporting capabilities to "invoke the Rman recovery script" by using Oracle Enterprise ManagerRman recovery: Restore and Recover commandsRestore: Rman looked
Tags: Linux virtual machine KVM data recovery mistakenly deletedone, virtual machine failure Environment DescriptionThe client's physical machine operating system is a Linux system, and the file system is the EXT4 file system. The KVM virtual machine on it is deleted, each virtual machine contains a disk file in Qcow2 format, and a disk file of approximately 1.2T in raw format, mainly to restore RAW format disk files. Customer has backed up on their o
Canon and other high-definition SLR now more and more popular and more advanced technology, users in the use of the same time, there will inevitably be data loss, etc., today encountered a shooting wedding customers mistakenly operation will canon 80D machine in the MP4 format file all format lost, Later use of the various scanning software on the Internet to try their own recovery failed, the recovered files will not play properly.Canon 80D machine u
I. fault description of RAID data recovery
Fault descriptionThe total storage space of hp fc msa2000 is composed of eight 450 gb sas hard disks, of which seven are a RAID 5 array, and the remaining one is used as a hot backup disk. Two hard disks are damaged in the RAID 5 array, and only one hot spare disk is activated successfully. As a result, the RAID 5 array is paralyzed and the upper-layer Lun cannot be used normally.Because some disks in the rai
Recovery Based on backup control file (unsing backup controlfile)
Applicable:Recovery Based on backup control files is applicable to the following situations: the tablespace is accidentally deleted; all control files are damaged.
1. Close the database and perform a full-database cold backup:
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/DBBak2/oradata/WWL/users0
Server raid5 data recovery success stories, disk array data recovery methods, raid5 success stories
[Introduction to physical servers and logical Storage]
The customer uses an IBM 3850 server and four RAID 5 disk arrays made of 300 gb sas disks. The server operating system is Windows x64 and runs a single-node Oracle version of 11.2.0.2. The data is stored as a file system and is not archived. This oracle d
Label:A Beijing real estate company, an HP Dl380g7 server, because of physical damage to multiple disks, resulting in raid crashes, data loss. The HP Dl380g7 server runs a Kingdee EAS system with a background of more than 40 GB of Oracle database, and the database data is very important. The HP Dl380g7 server is plugged into 8 146GB SAS disks, and each 4 disk has a set of RAID5, and a total of two sets of RAID5 are made into a RAID0, a total of 8 disk RAID50. 8 disk has 3 disk damage, and offlin
Tags: Rman offsite recoveryObjectiveRman in the actual application of a few, many times a project began to set up a backup strategy, the follow-up is basically not used, unless the database is abnormal, it can be said that Rman is a less common but very important skills, but it is very easy to forget. In order not to drop the chain at the critical moment, an Rman geo-recovery database experiment was done.Introduction to the test environment
Recover 1.1. Loss of SPFile Recovery
Prerequisite: Automatic backup of database control files has been configured and reliable backups have been made:
Rman> CONFIGURE controlfile autobackup on;
New RMAN configuration parameters:
CONFIGURE Controlfile autobackup on;
A new RMAN configuration parameter was successfully stored
Starting resync for full recovery directory
Complete all Resync
Rman>
r
Oracle RAC Environment ASM Disk Group is forcibly deleted with kfed tool for perfect recovery of mistakenly deleted disk group casesIn some cases, may be due to misoperation, not small drop diskgroup, this time do not be nervous, this type of failure, can be kfed for a perfect recovery (data 0 lost). If the relevant ASM disk is further damaged, subsequent restores will be cumbersome, You may need to use the
Tags: presence extraction using a contiguous VMFS storage space is data lossNow, with the advent of virtualization technology, many enterprises are starting to use virtualization technology. The principle of virtualization technology is to virtualize the hardware to different virtual machines. That is, a physical machine can have more than one virtual machine. However, if the physical machine fails or the storage server fails, the upper-level virtual machine is unavailable. There are other reaso
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.