standby switchover 到primary之后需重启，见如下:SQL> alter database recover managed standby database finish;数据库已更改。SQL> alter database commit to switchover to primary;数据库已更改。SQL> select * from hr.test;select * from hr.test*第 1 行出现错误:ORA-

怎样dump出asm disk metadata,就像dump datafile?

oradebug setorapid &Pidoradebug suspend不用oradebug是否能suspend某个pid?(alter system suspend是整个系统suspend)

今天在测试alter system flush shared_pool时，发现shared_pool并无多大变化:SQL> select ksmchcls,count(*) from x$ksmsp group byksmchcls;KSMCHCLSCOUNT(*)-------- ----------R-free12R-freea29free1099freeabl4153perm15recr

Analysis Period: 26-JUN-2008 from 10:00:12 to 13:33:52Database ID/Instance: 2494693421/1Database/Instance Names: XE/xeHost Name: xxxxxDatabase Version: 10.2.0.1.0Snapshot Range: from 3750 to 3755Database Ti

Instance Efficiency Percentages (Target 100%)Buffer Nowait %: 100.00 Redo NoWait %: 100.00Buffer Hit %: 99.21 In-memory Sort %: 100.00Library Hit %: 87.52 Soft Parse %: 53.19Execute to Parse %: 68.00 Latch Hit %: 99.99Parse CPU to Parse Elapsd %: 35.70 % Non-Parse CPU: -55.47

遇到恢复问题:RMAN> restore database;Starting restore at 25-JUN-08using channel ORA_DISK_1using channel ORA_DISK_2channel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00001 to C:ORACLEXEORAD

经常在作删除表空间时:drop tablespace test including contents and datafiles但是发现数据文件一直存在，重启数据库后也经常有这种现象是否与xxx条件有关？

由于backupset 是从备份中copy出来的，故已不在控制文件所指位置:现测试 :RMAN> restore database from "d:2008_06_25";Starting restore at 25-JUN-08using channel ORA_DISK_1using channel ORA_DISK_2RMAN-00571: ===========================================================RMAN-00569: =======

d:test