Shulou(Shulou.com)06/01 Report--

First, start the service (skip this step if the database is started)

Open the command line and execute the following statement

net start OracleServiceORCL

net start OracleOraDb10g_home2TNSListener

net start OracleOraDb10g_home2iSQL*Plus

The above method is to start the service in windows services. When windows services cannot start the database instance, apply the following statement

set oracle_sid=orcl

oradim -startup -sid orcl

sqlplus internal/oracle

startup

second, clean up traces that have been restored before. if we have restored traces in the database, let's clean up traces first.

//delete user

drop user xxxx cascade;

//Delete Tablespace

drop tablespace xxxx;

//delete database file

e:/xxxxxx.dbf

Third, the next step is that once we're ready, we can start restoring.

//Create user

CREATE USER Username IDENTIFIED BY Password

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP;

//Give user permission

grant connect,resource,dba to xxxx;

//Create a table space and specify a file name, size, and/or size

CREATE SMALLFILE TABLESPACE "xxxx" DATAFILE 'E:/ORADATA/ORCL/xxxx.DBF'

SIZE 100M

AUTOEXTEND ON NEXT 100M

MAXSIZE UNLIMITED

LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

//Execute the script grant.txt that grants permissions to the user you just created

//give permission

GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,

DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,

DBA,CONNECT,RESOURCE,CREATE SESSION TO xxxx;

//Start import (full import),file: Location of dmp file, ignore: Because some tables already exist, they will not be imported.

Add ignore=y. Specify the log file log=e:/log.txt (Note: The following must be executed in cmd, not in SQL*PLUS)

imp user/pass@orcl full=y file=e:/xxx.dmp ignore=y log=e:/log.txt;

//When we don't need to restore the database completely, we can restore a specific table separately

//---------------------------------------------------------------------------

imp user/pass@datbase file=e:/xxx.dmp ignore=y log=e:/log.txt tables=(xxxx)

imp user/pass@database file=e:/xxx.dmp ignore=y log=e:/log2.txt tables=(xxxx)

//---------------------------------------------------------------------------

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.