oracle中误删数据重新恢复的过程,教训 ! 学习~
今天在工作过程中失误删除了select * from ccard.em_creditcard where sno = 99的记录,找同事帮我恢复了一下,以下记录恢复的过程。既作为教训也作为学习,引以为鉴,以后删除数据前一定要先备份。
基本思路把前一天的表空间备份出来恢复到一个临时的表空间,然后把记录重新Insert到误删的表空间中,幸亏这条记录是今天之前的,若是当天的数据也没有备份的话需要从日志来恢复了。
[oracle@Pay-DBsrv oracle]$ sqlplus /nolog
SQL> connect / as sysdba
Connected.
SQL> create user cc identified by cc
2 default tablespace users
3 temporary tablespace temp
4 ;
User created.
SQL> grant connect , resource to cc
2 ;
Grant succeeded.
SQL> exit
[oracle@Pay-DBsrv tmp]$ exp system file=ccard.dmp log=ccard.log owner=ccard direct=y
[oracle@Pay-DBsrv tmp]$ imp sys file=monca_full_20050929.dmp fromuser=ccard touser=cc log=temp.log
[oracle@Pay-DBsrv tmp]$ sqlplus /nolog
SQL> connect cc/cc
Connected.
SQL> set pagesize 1000
SQL> select * from em_creditcard where sno = 99;
SQL> connect / as sysdba
Connected.
SQL> insert into ccard.em_creditcard select * from cc.em_creditcard where sno = 99;
SQL> select * from ccard.em_creditcard where sno = 99;
SQL> commit ;
Commit complete.
SQL> drop user cc cascade;
SQL> exit;
分享到:
相关推荐
windows下基于be的oracle restore
恢复删除(delete) 操作的数据,通过日志文件 Restore delete of data from sqlserver
15:33:19: [restore_table] Trying to restore data to SYS.TRUNTAB1$$2 15:33:20: [restore_table] Expected Records in this round: 411 15:33:20: [restore_table] 411 records recovered 此处省略N行输出.....
netbackup for oracle restore script
Oracle备份与恢复机制详解,十分全面,有示例。
对oracle数据库的操作经常会遇到trigger ,procude 等对象的创建,该文档是很有帮助的。
Oracle12c RAC Restore Recover 备份恢复 从集群数据库备份、OCR备份、OCR恢复、数据库多种场景下恢复都做了讲解 适合Oracle初学者,可根据文档内脚本命令,跟着教学,逐步掌握Oracle12C集群数据库备份和恢复等知识...
He is the coauthor of several Oracle Press titles. Robert G. Freeman is a principal DBA and Team Manager at the Church of Jesus Christ of Latter-day Saints. He is the author of several books, ...
基于BE的restore
oracle 9i rman
Data-Unit_MongoDB_Restore适用于磁盘存储故障、勒索病毒删除、误操作删除等导致的数据库丢失恢复。运行工具后将数据文件拖入本窗口即可。也支持扫描分区和裸磁盘,建议扫描磁盘镜像文件,效果更好。 免费版每个集合...
Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the ...
restore database until time "to_date('2019-08-19 08:49:00','yyyy-mm-dd hh24:mi:ss')"; recover database until time "to_date('2019-08-19 08:49:00','yyyy-mm-dd hh24:mi:ss')"; alter database open ...
群晖restore工具
oracle rman深入学习研究的文章,很不错的
用户truncate误删 schema下的若干数据表,无法使用flashback query等技术恢复数据,尝试从之前的全备份中恢复,数据库restore速度较快,但是archivelog恢复时由于HP data Protecter的不明原因导致归档恢复十分缓慢,...
Recovery Manager(RMAN)是一种用于备份(backup)、还原(restore)和恢复(recover) 数据库的Oracle 工具。RMAN只能用于ORACLE8或更高的版本中。它能够备份整个数据 库或数据库部件,如表空间、数据文件、控制文件、...
对于oracle数据库的表数据的导入导出格式
If missing or data modification makes consistent estimation impossible, then the author explains what type of action is needed to restore the lost information. The book contains more than a ...