oracle recover datafile

When the data in the table is deleted, it does not actually delete the data, but instead it makes a deletion mark that can be recovered as long as it is not overwritten. The experimental process is as follows: Sys@orcl>create table Bbed_test (x varchar2 (20)); Table created. Sys@orcl>insert into bbed_test values (' BADLY9 '); 1 row created. Sys@orcl>insert into bbed_test values (' JP '); 1 row created. sys@orcl>commit; Commit complete. Sys@orcl>select rowID, Dbms_rowid.rowid_relative_f

Oracle learns restore database and recover database restore only by using backup to restore, recover uses archivelog or online log for example: Suppose I have made A backup at A time point, at the time point, database B goes down to the restore database; // This operation uses the backup made by time point A to restore, and returns to time point A

When the data in the table is deleted, it does not actually delete the data, but instead hits a delete tag, which can be restored as long as it has not been overwritten. The experimental process is as follows:[Email protected]>create table bbed_test (x varchar2 (20));Table created.[email protected]>insert into bbed_test values (' BADLY9 ');1 row created.[email protected]>insert into bbed_test values (' JP ');1 row created.[Email protected]>commit;Commit complete.[Email Protected]>select rowid, d

, you can infer whether the log is consistent2. Next, we need to stop the MRP process in the repository:ALTER DATABASE recover managed standby database cancel;Note that this assumes an error, such as the following see, can not care, because our main log is consistent, MRP can be idleERROR at line 1:ora-16136:managed Standby Recovery not active 3. We can then generate the data dictionary in the main libraryexec dbms_logstdby.build;we need to have the d

If the user mistakenly deletes/updates the data, as the user does not have any direct method to restore, they must help the DBA to restore the database, to the oracle9i, this embarrassing situation has improved. Oracle 9i provides a new technique--a flash-back query that allows users to get data before a bad operation in a timely manner, and to recover for errors without DBA intervention. Because the hand

Tags: ROM esc span mistakenly delete differentiate Lang BSP so todayToday, two tables of data are synchronized, and the table has its own association relationship. The new data has been deleted because no changes have been made to the synchronized table (a new number of data has been added, and there is a parent-child relationship between the data). So I want to recover the following ways: ALTER TABLE TableName the row movement attribute of the enabl

Tags: cycle href Recycle Bin object LAN style Origin bin ROMFirst, view the table in the Recycle BinSelect Object_name,original_name,partition_name,type,ts_name,createtime,droptime from RecycleBin; Second, the recovery tableSql>flashback table Test_drop to before drop; Sql>flashback table "Bin$b+xkko1rs5k10uko9bfmua==$0" to before drop; Note: This method must require that the Oracle version must be 9i or 10g or higher, and flashback cannot

Label:1. Log in to SYSDBA database2. Querying snapshots based on point-in-timeSELECT * from source$ as of TIMESTAMP to_timestamp (' 2014-02-24 05:10:32 ', ' yyyy-mm-dd HH24:MI:SS ') where source like '%CP _eas_costbreakdown_info% '; (Cp_eas_costbreakdown_info is the name of the stored procedure)3. Then query the code according to ojb#SELECT * from source$ as of TIMESTAMP to_timestamp (' 2014-02-24 05:10:32 ', ' yyyy-mm-dd HH24:MI:SS ') where obj#=164283 Orde R by Line;4, copy the source, a littl

good enough,We have to repair the hard drive,Boot into repair mode,See in which directory you are able to create files and then use Fsck.ext3-y. Mount Partition ... The repair will be OK.Reference: HTTP://HI.BAIDU.COM/LIJUNYI0198/ITEM/2558F8C613618F61F6C95D04Reboot try it.6 Log in again Sqlplus start from librarySql> STARTUP mount;oracle instance started. Total System Global area 5344731136 bytesfixed size 2213136 bytesvariable size 3489663728 by

"Guide" This paper presents the principle of flashback function, describes the use of Oracle 9i or Oracle 10g Flash-back function to recover accidental loss of data methods. Objective Human error is one of the important reasons for the failure of database system, according to survey about 40% of the system problems are operating errors or user errors caused by,

whitespace (" product_id "CHAR (5) enclosed by X ' 7C '," Sales_da TE "DATE" dd-mon-yyyy AD HH24:MI:SS "enclosed by X ' 7C '," Sales_cost "CHAR (3) Enclosed by x ' 7C ', "STATUS" CHAR (8) enclosed by x ' 7C ') This proves that the table structure in all the control files is the structure of the whole table, not the partition table, in the actual process, you can consider the swap partition to implement -----------------Tips-------------------- operation is risky, hands-on need to be cautious