oracle recover database using backup controlfile

Label:Initialization --CREATE TABLE Space CREATETablespace table space name datafile'file name. dat'SIZE 100M Autoextend on NEXT10M MAXSIZE UNLIMITED;--Create User (Oauser) --Connect Internal CREATE USEROauser identified byOauser;ALTER USEROauserDEFAULTtablespace tablespace_name;ALTER USEROauserDEFAULTROLE All; GRANTDba toOauser;GRANTCONNECT toOauser;GRANTRESOURCE toOauser;GRANT Create Table toOauser;GRANT Create Trigger toOauser;GrantExp_full_database toOauser;GrantImp_full_database toOauser;

directory Create directory W_dir as ' D:\dumpfile ';Create a folder under Computer D called DumpFile, used to store the backup files, and the computer will automatically go to the folder to find the. dmp file, after you have created the directory,Executes the EXPDP BACKUP statement, and the backup file is automatically generated to the directory-specified file.

The Oracle tutorial being looked at is the sh file of the Oracle database logical backup. SH file for full backup: exp_comp.sh rq= ' date + '%m%d ' SU-ORACLE-C "Exp System/manager full=y inctype=complete file=/

%5.rar "%pnm%6.rarren"%pth%4.rar "%pnm%5.rarren"%pth%3.rar "%pnm%4.rarren"%pth%2.rar "%pnm%3. Rarren "%pth%1.rar"%pnm%2.rarren "%pth%0.rar"%pnm%1.rar) Else (del "%pth%6.dmp" Ren "%pth%5.dmp"%pnm%6.dmpren "%pth%4". DMP "%pnm%5.dmpren"%pth%3.dmp "%pnm%4.dmpren"%pth%2.dmp "%pnm%3.dmpren"%pth%1.dmp "%pnm%2.dmpren"%pth%0.dmp "%pnm% 1.DMP) echo%time%, start Backup Database >> "%pth%explog.log":: Export parameters

to connection-T, the number of threads used by--threads, default 4-C,--compress-protocol using the compression protocol on the MySQL connection-V,--version show the program version and exit-V,--verbose more output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2 Myloader: Copy Code code as follows: root@dd:~/mydumper-0.5.2#./myloader--help Usage: Myloader [OPTION ...] multi-threaded MySQL loader Help Options:-?,--Help Sh

Java implements Oracle Database Backup Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage: Import java. io. file; import java. io. IOExcep

Database backup recovery, patrol needs to focus on the object settings:1. Database name, and dbid;--dbid in V$database[email protected]>select dbid,name from V$database;DBID NAME---------- ---------1385095721 ORCL2. Control the location of the file;Show parameter control_fil

Oracle database Backup and restore basic commands1. Get Help$ exp Help=y$ imp help=y2. Three ways of working(1) Interactive mode$ exp Then follow the prompts to enter the required parameters(2) command line mode$ exp User/[email protected] file=/oracle/test.dmp full=yEnter the required parameters in the command line(3)

Tags: tools dev install oracle tail log file blog export RAC bodyNow let's introduce our project using the Exp tool to automatically back up Oracle every day. With this tool we can also use the command line to export using PL/SQL developer. We want to use the EXP command to export Oracle's data, first of all to ensur

Tags: backing up schema database metadataBackup and recovery of Oracle database pumpDirectoryI. Preparation for database backup and pre-recovery ... 1 1. Authorize and create DIRECTORY objects for database users ... 1 _toc38845

In Oracle Database backup, we often use the following three modes: Table mode, all objects in the specified user, and data export/import, the following describes the actual application of the three modes in Oracle Database Backup.

Tags: Click to select Scheduled Tasks virtual directory ASC window strong Sqlplus DirectorOne, database backup 1. Enter the database Sqlplus system/Password sqlplususername/[emailprotected]assysdba 2. Create directory D:\temp\dmp (DPDATA1 database name) Create directory dpdata1 as ' d:\temp\dmp '; (Delete directories d

As one of the mainstream databases in the current market, Oracle databases are developed on many applications. Due to the reasons for upgrading Oracle databases and different application providers, several Oracle versions may exist in an application unit, such as Oracle 7, Oracle