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

This article mainly introduces "oracle database recovery method is what", in daily operation, I believe many people in oracle database recovery method is what problem there are doubts, Xiaobian consulted all kinds of information, sorted out simple and easy to use operation method, hope to answer everyone "oracle database recovery method is what" doubts helpful! Next, please follow the small series to learn together!

--Create default tablespaces, system-supported tables, and common data tables

1)

create bigfile tablespace NNC_DATA01 datafile 'D:\oracle\NNC_DATA01.dbf' size 100m autoextend on NEXT 10k;--blue font is the name of the table space, table space storage path respectively

--Tablespace named TALENTBASE

create bigfile tablespace TALENTBASE datafile 'D:\oracle\tablespace\tb_bxyh.dbf' size 100m autoextend on NEXT 10k;

--Create temporary tablespaces

create bigfile temporary tablespace NNC_DATA01 tempfile 'D:\oracle\NNC_DATA01.dbf' size 100m autoextend on NEXT 10k;--Blue font is temporary tablespace name, temporary tablespace storage path respectively

2)--Create users, associate tablespaces and virtual tablespaces, and empower users (three dba, resource, connect);

--Use the following sentence in the annex:

--User Rights

grant connect,dba,resource to user;

--Delete user. If it is an existing project database user, delete user first when overwriting; if it is a new project, delete user directly.

--drop user username cascade;

drop user tb_bxyh cascade

--Create Administrator User

create user username identified by username default tablespace tb_bxyh temporary tablespace tb_bxyh_bxyh;

- Authorization

grant connect,dba,resource to username;

--modify the limit

ALTER USER HCM QUOTA UNLIMITED ON username;

4. Then open the F:\oracle database file\cmd file to maintain the import statement.

--When exporting files with exp, use imp when restoring;

imp username/password@ora11g file= import file path fromuser= export username touser= import username log= import file execution log

imp H/H201709@orcl file=C:/Users/Administrator/Desktop/jiar/EXPH_20171011030000/oracle_backup/EXPH_20171011030000.dmp fromuser=H touser=H log=EXPH_20171011030000.log

--Specifies not to export tables

expdp db/db@hrdb directory=DATA_PUMP_DIR exclude=table:"in('tp_sys_blob')" dumpfile=20190305.dmp logfile=20190305.log schemas=tt;

--when exporting files with expdp, use impdp when restoring;

impdp username/password@ora11g directory=dump_dir dumpfile= import filename logfile= import file execution log remap_schema= export username: import username

impdp tb_czyhtest/hr_39_DB@orcl directory=dump_dir dumpfile=bak0210.dmp logfile=bak0210.log remap_schema=tb_czyhtest:tb_czyhtest

--Find import path

select * from dba_directories;

5. After the execution is completed, you must view the import log file. The table information imported each time is about 1000 points. At the end of the import, there will be the following words, indicating that the import is successful. The warning does not affect use.

(Constraints about to be enabled... Import terminated successfully with warnings.)

--If the log display table exported by backup is missing, you can query it with the following statement and execute the query result in the corresponding database. When you backup and export again, you can export the empty table.

Question: Sometimes when importing, you will be prompted that there is insufficient table space. At this time, you need to find the table space according to the prompt, and then query PLsql to find out what the storage files of the current table space are.

For example, it is often prompted that the 'Tablebase' table space is insufficient. In this case, we use the following statement to check the existing file information:

---Query table space size and usage:

select tablespace_name, bytes, user_bytes, user_bytes/bytes,file_name from dba_data_files where tablespace_name='TALENTBASE';

The storage files currently in use are in 'E:\oradata\ora11g\... 'Now that talentbase11.dbf is available, we can add a new storage file using the following statement, and then execute the import statement.

--Insufficient table space

alter tablespace TALENTBASE

add datafile 'E:\oradata\ora11g\TALENTBASE12.dbf'

size 100M autoextend on next 10M maxsize unlimited;

--Automatic extension

alter database datafile '/db/oracle/oradata/hrdb.dbf'autoextend on next 100m maxsize 10000m

--lookup tablespaces

select * from dba_data_files

At this point, the study of "what is the method of oracle database recovery" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.