Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to backup and restore Oracle, the article introduces in great detail, has a certain reference value, interested friends must read it!

Create a table partition

Create tablespace apps datafile'& 1\ apps.dbf' size 10m autoextend on next 8m * * create tablespace appsys datafile'& 1\ appsys.dbf' size 10m autoextend on next 8m

Create a partitioned tablespace

Create tablespace APPS_00 datafile'& 1\ APPS_00.dbf' size 10m autoextend on next 8M * * create tablespace APPSYS_00 datafile'& 1\ APPSYS_00.dbf' size 10m autoextend on next 8m

Delete user

Drop user apps cascade;drop user appsys cascade

Create a user

Create user apps identified by cape default tablespace apps;create user appsys identified by cape default tablespace appsys

Authorization

Grant dba to apps with admin option;grant dba to appsys;grant create any table to apps;grant alter any table to apps;grant drop any table to apps;grant create any index to apps;grant drop any index to apps

Create a directory

Create or replace directory expdp_wms_dir as'D:\ data_bak\'; grant read, write on directory expdp_wms_dir to APPS

EXP/IMP backup and restore

Exp user/pwd@SID file=d:\ db_20101010.dmp log=d:\ db_20101010.log owner= (apps,appsys) imp user/pwd@SID file=D:\ db_20101010.dmp log=D:\ db_20101010.log fromuser=apps touser=apps fromuser=appsys touser=appsys ignore=y

EXPDP/IMPDP backup and restore

Expdp user/pwd@SID dumpfile=DB20141216.dmp logfile=DB20141216.log schemas= (apps,appsys) directory=expdp_dir job_name=expdp_job version=11.1.0.2impdp user/pwd@SID dumpfile=DB20141216.DMP logfile=DB20141216.log schemas= (apps,appsys) directory=impdp_dir job_name=impdp_job

Tablespace mapping

Impdp user/pwd@SID dumpfile=DB20141216.DMP logfile=DB20141216.log remap_schema=QA_SOA:SNPW remap_tablespace=DEV_ODI_USER:JJE_ODI_USER directory=impdp_dir job_name=impdp_job

Forgot the password of the administrator sys for ORACLE

Log in locally on the server without a password

Sqlplus / as sysdba

Change your password after logging in

Sql > alter user sys identified by sys;user test lacks CREATE SESSION privilege; logon denied.

Log in using DBA and execute the following authorization statement.

Grant connect,resource to test;grant create session to test; above is all the contents of this article "how to backup and restore Oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.