oracle recover database using backup controlfile

that time, my idea was, Oracle this thing, why do not have to go to the virtual machine to install Ah, dizzy dish ~ ~ ~ But it turns out that it is no problem to install Oracle into a virtual machine ~ ~ ~After we found the problem, we all felt very puzzled, how can Oracle database have this problem? Must not be a

Backup scheme for MySQL database using the Percona-xtrabackup toolNeed to back up the MySQL host 172.16.155.23Host 172.16.155.22 for backup MySQLPurpose: The MySQL database on the 155.23 host is backed up on a daily basis and synchronized to the remote host1. Install the

Del/q change.txt Set/p file = enter the file name of the spare parts database: Set/p path = enter the storage path (remember to enter the colon :): "% Var %" \ exp.exe smhr/smhr file = % path % \ % file % full = n Set/p choice = 1. Continue 2. Press any key to exit: If % choice % = 1 goto start : Imp Del/q change.txt Set/p file = drag the database file to be imported into the form: "% V

Oracle Data Guard synchronizes Data through archive files. The archive files of the master database can be deleted during RMAN backup, but the archive files of the slave database cannot be deleted automatically. You need to write scripts to delete them regularly. If you delete an archive file directly, you may find tha

Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage: Today, we will paste an Oracle database backup feature that has been implemented very

Table Backup ModeBackup: Exp system/[email protected]:1521/db owner= (user) File=e:\db\db20150326.dmp tables= (table);Restore: Imp system/[email protected]:1521/db fromuser= (user) Touser=user file=e:\db\db20150326.dmpUser Backup ModeBackup: Exp system/[email protected]:1521/db owner= (user) File=e:\db\db20150326.dmpRestore: Imp system/[email protected]:1521/db fromuser= (user) touser= (user) File=e:\db\db2

Config NBU backup Database NBU Installation Environment: Database:oracle 11.2.3 Os:oracle Linux 5.7 x86_64 Backupsoftware:nbu 7.5 Tape library:mhvtl-utils-1.4 A virtual band library that is commonly used in a production environment, or a vendor-supplied dummy tape library. But in the process of learning not so much money to buy equipment, then only use virtual machine to do virtual tape library. Th

Because of the usual database backup and restore operations, To improve efficiency and save time, you have the following batch process. This is written for Oracle, can be used on different computers, because it will automatically read the current computer environment variables, so as to obtain the Oracle installation p

1: create a user Copy codeThe Code is as follows:Create temporary tablespace user_tempTempfile 'd: \ app \ topwqp \ oradata \ orcl \ user_temp.dbf'Size 500 mAutoextend onNext 50 m maxsize 2048 mExtent management local;Create tablespace ts_mydbLoggingDatafile 'd: \ app \ topwqp \ oradata \ orcl \ ts_mydb.dbf'Size 500 mAutoextend onNext 50 m maxsize 2048 mExtent management local;Drop user mydb cascade;Create user mydb identified by mydbDefault tablespace ts_mydbTemporary tablespace user_temp;Grant

Package com.test; Import Java.io.BufferedInputStream; Import Java.io.BufferedReader; Import Java.io.FileInputStream; Import java.io.IOException; Import Java.io.InputStream; Import Java.io.InputStreamReader; Import Java.util.Date; /** * Java program Import Export database to do program timing (combined with Quartz,log) automatic backup to prevent data loss * * @author leiwei 2011-12-1 * * * Public

: oraclebackup"/dmp/OA *. log/d-10/c "cmd/c del @ path" Echo is backing up the Oracle database. Please wait ...... Exp user/password @ orcl file = E:/oraclebackup/dmp/OA _ % date :~ 0, 4% % date :~ 5, 2% % date :~ 8, 2%. dmp log = E:/oraclebackup/log/OA _ % date :~ 0, 4% % date :~ 5, 2% % date :~ 8, 2%. log owner = (jasoa_doc) Echo task completed! After that, change the txt extension of the notepad to bat.

In the EBS oracle production environment, the database backup script is saved as the sh script respectively below. The first one is that the backup speed of the compressed backup is extremely slow, and it takes 10 hours to GB, however, after the