全部博文(17)
发布时间:2014-04-12 16:26:07
[oracle@ol5-112-dolly dbs]$ cat initorcloltp.oraDB_NAME=orcloltp[oracle@ol5-112-dolly dbs]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 6 17:27:17 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database .........【阅读全文】
发布时间:2014-04-12 16:23:48
duplicate database to orcltestuntil time "TO_DATE('02-APR-2014 21:16:20','DD-MON-YYYY HH24:MI:SS')"spfileset control_files='+DATA/ORCLTEST/CONTROLFILE/control1.ctl','+FRA/ORCLTEST/CONTROLFILE/control2.ctl'set db_file_name_convert='orcloltp','orcltest'set log_file_name_convert='orcloltp','orclte.........【阅读全文】
发布时间:2013-04-14 15:10:07
http://www.oracle.com/technetwork/server-storage/linux/documentation/index.html......【阅读全文】
发布时间:2013-04-10 22:58:16
# file_name awr.sh# first parameter: starting snapshot # second parameter: number of hours# example: sh awr.sh 11111 24#! /bin/bashi=$1j=$(($1 + $2))log=awr_${ORACLE_SID}_${date}.shwhile [ $i -le $j ] do &nb.........【阅读全文】
发布时间:2011-06-28 12:47:45
For dictionary managed temporary tablespace :select (s.tot_used_blocks/f.total_blocks)*100 as "percent used" from (select sum(used_blocks) tot_used_blocks from v$sort_segment where tablespace_name='TEMP') s, (select sum(blocks) total_blocks from dba_data_files where tablespace_name='TEMP') f;.........【阅读全文】