Oracle backup restores simple processes and pits in the middle.

Oracle

Cold

It looks like you need DBCA create a consistent Oracle Instance server configuration version as much as possible, with the same installation path.

Turn off Oracle Services

Copy the Oradata in the Oracle app directory and the control file in the fast flash back zone to the new server note that the directory is identical

If you have data for your own business library that you have to move to the same directory,

Start the database service to recover to the database if it is available immediately.

Hot Spare

Exp EXPDP Imp IMPDP Rman is temporarily not written with less.

Exp/imp is slower but has better compatibility and high and low versions, but looks like 12c. Oracle is slowly using this old backup recovery method.

Advantages: The client runs relatively simple without considering the differences between Linux winserver and so on.

Exp System/[email protected] Owner=username file=c:\backupdir\dumpname.dump lot=c:\somedir\log.txt

Import:

You need to create a table space and users to recover the library, or Oracle will error

Create statement

Sqlplus/as SYSDBA or execute related commands,

Table Space:

Create bigfile (optional) tablespace talespacename datafile ' dir\data.dbf ' size 100m autoextend on next 100m;

User

Create user username default tablespace tablespacename identified by password

Permissions

test environment words to empower a little more ... This, however, exposes your rookie attributes.

Grant Dba,resource,connect,create any table,create any view,create any sequence,unlimited tablespce to username

And then

Imp system/[email protected] fromuser=username touser=username file=backdumpwithdirectory.dmp log=xxxx.log

Note that oracle11.2.0.1 and several low-version bugs can cause the environment to be unavailable due to partial empty tables when EXP is not available, so it is recommended to use EXPDP

EXPDP need to create directory so it is recommended to perform on the server side

Method:

Sqlplus/as SYSDBA

Create directory as ' directory '

and execute it in command.

EXPDP system/password directory=dir schemas=username dumpfile=some logfile=some

When recovering

Create table spaces and users first

The user's permissions do not need to be assigned to the backup restore when automatically added

IMPDP system/password directory=dir schemas=username dumpfile=some logfile=some

Relatively simple like parallel and other parameters can be slowly learned to use.

Oracle backup restores simple processes and pits in the middle.