数据库恢复服务 微信: dbservice1234

Initial buffer sizes: read 1024K, overflow 832K, change 805K

   1691 #ifdef KCRFR_DEBUG

rman 注册归档(arch)的语句

One way of registering a logfile is via the following:

SQL> alter database register logfile
'/var/arch/arch_1_101.arc';

So this is a straightforward way of registering a logfile giving the full path to the logfile. However, what if you have a very large number of logfiles to register, the above does not really scale all that well. Thankfully there is an rman command that enables you to register all logfiles within a directory:

rman> catalog start with '/var/arch';

This can save you a lot of time if you need to register a large number of files.

resmgr:internal state change等待

 resmgr:internal state change==> session 对应的resource manager plan正在改变中

Hang or similar symptoms when changing resource manager plans during
 heavy workload activity.
 One or more sessions block on a wait for "resmgr:internal state change"

SQL> select partition_name from dba_ind_partitions where index_name='LOCAL_ONE';

PARTITION_NAME
---------------------------------------------------------------------------------------------

EMPLOYEES_PART1
EMPLOYEES_PART2
EMPLOYEES_PART3

SQL> alter index LOCAL_ONE drop partition EMPLOYEES_PART1;
alter index LOCAL_ONE drop partition EMPLOYEES_PART1
            *
第 1 行出现错误:
ORA-14076: 提交的变更索引分区/子分区操作对本地分区的索引无效

You cannot explicitly drop a partition from a local index.  Instead, local 
index partitions are dropped only when you drop a partition from the underlying 
table. You have to disable the local partition index by making it unusable.

Example:

-- alter table make all local partition indexes unusable
ALTER TABLE &v_table_name
MODIFY PARTITION &v_part_name
UNUSABLE LOCAL INDEXES;

This will set the UNUSABLE status in the DBA_IND_PARTITIONS on all
the local partitioned indexes equipartitioned with &v_part_name.

ALTER SESSION SET skip_unusable_indexes = true;
 
-- load data in the corresponding partitions
INSERT ... VALUES ...
 
-- alter table make partition local index usable
ALTER TABLE &v_table_name
MODIFY PARTITION &v_part_name
REBUILD UNUSABLE LOCAL INDEXES;

The status of the &v_part_name partitions indexes will be now USABLE again in
DBA_IND_PARTITIONS.