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

This article mainly introduces Oracle AWR how to achieve data import / export, the article is very detailed, has a certain reference value, interested friends must read it!

In LINUX, connect oracle users: su-oracle

1. Upload capture snapshot .dmp file to server (dbid:4292035712) 919219826

two。 Create a directory on the server side (that is, folder awrtest)

$> mkdir / home/oracle/awrtest

3. Move the .dmp file uploaded in step 1 to the folder created in step 2:

$> cp / var/ftp/AWR_10107.dmp (if the original file suffix is .DMP, it must be changed to lowercase .dmp) / home/oracle/awrtest

4. Switch to the sqlplus state and start the database:

$> sqlplus / as sysdba SQL > startup

5. Create a database directory to facilitate database search

SQL > create directory AWRTEST as'/ home/oracle/awrtest'

6. Load the data file:

SQL > @? / rdbms/admin/awrload.sqlSQL > Enter value for directory_name: AWRTEST / Note: when entering directory name, uppercase Enter value for file_name: AWR_10107 / / Note: do not add the file suffix Enter value for schema_name: AWR_STAGE / / (general default) Enter value for default_tablespace: USERS Enter value for temporary_tablespace: / / (enter default)

Once the text appears, it means that the import is successful!

... Creating AWR_STAGE user | ~ | Loading the AWR data from the following | directory/file: / home/oracle/awr | AWRDAT_9239_9394.dmp | ~ | | * * AWR Load Started... | | This operation will take a few moments. The | progress of the AWR load operation can be | monitored in the following directory/file: | / home/oracle/awr | AWRDAT_9239_9394.log |. Dropping AWR_STAGE user End of AWR Load

Error symptoms: (pay attention to the problem of folder restoration! )

[root@localhost] # cd / home/oracle/ [root@localhost oracle] # ls-lttotal 660 drwxr-xr-x 2 root root 4096 Aug 6 02:07 awrdrwxr-xr-x 2 root root 4096 Aug 6 02:04 awrtest2-rw-r--r-- 1 oracle oinstall 326088 Jul 8 22:13 zhongxing.html-rw-r--r-- 1 oracle oinstall 311525 Jul 1 12:48 HUAYOUSHIJI.html drwxr-xr-x 3 oracle oinstall 4096 Jul 1 11:32 awrtest1drwxr-xr-x 2 oracle oinstall 4096 Jul 1 01:10 awrtestdrwxr-xr-x 2 oracle oinstall 4096 Jun 30 12:47 jishubudrwxr-xr-x 3 oracle oinstall 4096 Jun 22 14:58 Desktop [root@localhost oracle] # chmod-R 777 awr [root@localhost oracle] # ls-lttotal drwxrwxrwx 2 root root 4096 Aug 6 02:07 awrdrwxr-xr-x 2 root root 4096 Aug 6 02:04 awrtest2-rw-r--r-- 1 oracle oinstall 326088 Jul 8 22:13 zhongxing.html-rw-r--r-- 1 oracle oinstall 311525 Jul 1 12:48 HUAYOUSHIJI.html drwxr-xr-x 3 oracle oinstall 4096 Jul 1 11:32 awrtest1drwxr-xr-x 2 oracle oinstall 4096 Jul 1 01:10 awrtestdrwxr-xr-x 2 oracle oinstall 4096 Jun 30 12:47 jishubudrwxr-xr-x 3 oracle oinstall 4096 Jun 22 14:58 Desktop [root@localhost oracle] #

Other error reporting problem solving reference address:

Http://space.itpub.net/12129601/viewspace-735524 http://www.xifenfei.com/3966.html cherishes the incorrect creation of http://blog.163.com/jet_it_life/blog/static/205097083201262431444951/directory, which leads to the right problem of ORA-39070 http://www.douban.com/note/37656300/oracle impdp/expdp, Mr. http://space.itpub.net/519536/viewspace-664406 Hou Shengwen.

AWR data Migration reference address:

Spring breeze: export and migration of http://www.dbdream.org/?p=223eygle: AWR and Statspack data http://www.eygle.com/archives/2010/08/awr_statspack_extract.html

7. Execute related scripts: (such as logical read scripts, db-time scripts, etc.)

View dbid:

SQL > select dbid from vault database; 223805804 SQL > setpagesize 500 # su-oracle $cd awrtest/ # confirm $ls according to your installation directory (check the files in the current directory and confirm the relevant file names)

Generate logical read-statement:

SELECT case when to_number (to_char (c.end_interval_time, 'mi')) = 45

Then to_char (round (c.end_interval_time, 'hh34'),' yyyy-mm-dd hh34:mi')

Else to_char (c.end_interval_time, 'yyyy-mm-dd hh34') | |': 30'

End end_time

Case when max (decode (a.instance_number, 1, a.value-b.value, null))

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.