Oracle 12 c mistaken delete a table, how to use rman backup strategy and the corresponding generated backup file to restore the data? Not return to the time node recovery, 20 deleted at 7 o 'clock yesterday afternoon, strives for the great god taught, the Linux system, the installation of 12 c

CodePudding user response:

What is the command to delete? Stick down!

CodePudding user response:

Using rman restore table and table partitions, processing step is more,
Can try the flash flash back to back,

Processing steps are as follows:

 
- 1. The query is in the recycle bin 
The select object_name original_name, partition_name, type, ts_name, createtime, droptime 
The from recyclebin 
Where original_name='table name; 

- 2. If in, is to use flash technology recovery 
Flashback table table name to before drop; 

CodePudding user response:

The delete from the table all to empty the table name

CodePudding user response:

reference 1st floor qq646748739 response:

delete command is what? Stick down!

The delete from the table all to empty the table name

CodePudding user response:

refer to the second floor qq646748739 response:

using rman restore table and table partitions, processing step is more,
Can try the flash flash back to back,

Processing steps are as follows:

 
- 1. The query is in the recycle bin 
The select object_name original_name, partition_name, type, ts_name, createtime, droptime 
The from recyclebin 
Where original_name='table name; 

- 2. If in, is to use flash technology recovery 
Flashback table table name to before drop; 

CodePudding user response:

1. Try logminer recovery log technology;
2. If not, then use the PRM - DUL ORACLE recover data recovery tools,

CodePudding user response:

Look with the drop to delete

CodePudding user response:

Try to restore?

 
Flashback table hr_post_person_host to before drop; 

CodePudding user response:

refer to 6th floor qq646748739 response:

1. Try logminer recovery log technology;
2. If not, then use the PRM - DUL ORACLE recover data recovery tools,

Technology is white, please detailed guidance, how to operate, thank you for your great god

CodePudding user response:

refer to the eighth floor qq646748739 response:

try to restore?

 
Flashback table hr_post_person_host to before drop; 

Seems not, yesterday was on November 17

CodePudding user response:

Many articles online, help you search to the article, according to the steps yourself,
https://jingyan.baidu.com/article/ce43664916bb2b3772afd379.html

CodePudding user response:

11 references qq646748739 response:

many articles online, help you search to the article, according to the steps yourself,
https://jingyan.baidu.com/article/ce43664916bb2b3772afd379.html

Linux system, the date is not also can recover?

CodePudding user response:

1. Make a backup, you can use the rman + archive, do not fully recover
2. Try to oracle flashback query flashback
3. You can use some of oracle, a kind of tool undelete recovery (but this does not guarantee 100%)