Pages

Tuesday, May 24, 2011

RMAN-06091: no channel allocated for maintenance (of an appropriate type)

RMAN-06091: no channel allocated for maintenance (of an appropriate type)
The error message appears when we try to delete some backups. Set of commands could be like below.

RMAN> show retention policy;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

RMAN> delete obsolete;

Wednesday, February 16, 2011

Compile Database Objects - 1

There are multiple types of objects in database and different ways of compilation. There are different states for the objects and what we usually want them is to be "VALID".
To check the status of some object we can query user_objects, dba_objects views. Below query may show you the information required.

Wednesday, February 9, 2011

Tablespace Administration - 3

Temporary tablespace can be monitored/modified similarly, as we do for usual tablespaces. Use below links for details.
Tablespace Administration
Tablespace Administration with ASM
The difference here is the segments are temporary and are not being tracked by the views we have for other tablespaces.
For the files we have dba_temp_files and v$tempfile, and files are represented as tempfile at the place of datafile, and v$temp_space_header keeps track of free space.

So for the space and Usage we can have a query like below:-