recover deleted sql database

after the log shrinkage or sudden power outage13. Can recover multiple relational databases14. Recoverable SQL database bkf backup file and bak file15. Database recovery in case of mis-formatting of SQL Server database on disk ar

after the submission is completed), and the database was not backed up. [Recovery Process:]The tool used is log‑e, (: http://five.ttdown.com/L/Log%20Explorer%20for%20SQL%20Serverv%20v3.21.KG.exe) After installation, open Log Explorer File => attach log file-> Select Server and login mode-> connect->Select database> attach> browse> view log> In the left-side dialog box to view the log record,Click View D

Cause: I installed the Oracle database on the Windows system and deleted the Oracle tablespace file without starting Oracle, and the next time I started it, I would have an error, as follows: Ora-01033:oracle Initializationg or Shutdown in progress. Start with the DBA user will be an error: So-and-so file can not find, the file is not found is deleted table space

Purpose: delete a piece of data in the database, and then re-insert the deleted data to another table. At the same time, you need to insert the deletion person and the deletion time in the table. Run SQL statements declarev_fwzco t_fwzc_o%rowtype;begin select fwzc_id,zcbm into v_fwzco.fwzc_id,v_fwzco.zcbm from T_FWZC where fwzc_id='56038d65-2a41-4cf7-b136-f2ce

finally begins with the English letter, do not take Chinese charactersNtries represents the maximum number of super users allowed. This is an optional one. The first two must be specified. It is generally set to be larger than the actual need to avoid enough.After success, restart Oracle, login sys and password, remember the password must be followed by as SYSDBA, I am open PL/SQL command window with conn sys/password as SYSDBA login!I then successfu

Today, a colleague asked me to say that his local database was deleted by him by mistake, so he could not open the file. Let's take a look.SQL> conn jjw/jjwERROR:ORA-01033: Oracle initialization or shutdown in progress Warning: You are no longer connected to ORACLE.SQL>The database has been started, but an error is returned. If yes, I will restart the system to s

First, the problem descriptionThe current DB instance has been joined to a domain environment and is also a replica of an AlwaysOn cluster, and has now exited the previous domain to join a new domain, and the configured database starts the service with the same domain user and password as before. Re-using a previously existing domain user login database prompts that the user name does not exist, and that th

In database operations, when we accidentally delete tables, data, or views, we can use log mining to restore Oracle from Incomplete recovery, this article describes how to use log mining to recover data from incomplete Oracle recovery. Next we will introduce this process.The implementation of this method must meet two conditions: 1. DB works in archive mode; 2. There are cold data files.Next we will introdu

The database is set up with the self-add column , sometimes need to clear the database from the new input data .sql statement " Delete indicates the name ", But when you insert the data again , you'll find that the self-increment column starts with the next value of the last deleted data's maximum value. ,1. is there

T_xifenfei_1 (OWNER VARCHAR2 (), object_name VARCHAR2 (+), Subobject_name VARCHAR2 (+), object_id Number,data_object _id Number,object_type VARCHAR2 (+), CREATED date,last_ddl_time date,timestamp VARCHAR2 (+), STATUS VARCHAR2 (7), TE Mporary VARCHAR2 (1), GENERATED VARCHAR2 (1), SECONDARYVARCHAR2 (1), NAMESPACE number,edition_name VARCHAR2 ()) STORA GE (Dataobjno 68332);. Unloading table T_XIFENFEI_1DUL:Warning:Recreating file "T_xifenfei_1.ctl" 67854 rows unloadedAdditional notes:1. In the lat