月度存档: 十二月 2009

Control file autobackup

I find many large files(each file is about 12M) in dump folder, names are like ,
ISC01P_C-3518282637-20081111-05
I find many large files(each file is about 12M) in dump folder, names are like ,
ISC01P_C-3518282637-20081111-05

since there is no enough space on bdump, I would like to remove such files from the folder. But before that, i also need to figure out what’s the files for… and finally here is the result,

they are the backup image of control file. I find following configuration in the catalog database,

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 35 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘D:\ORACLE\ADMIN\isc01p\BDUMP\%d_%F’;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE ‘SBT_TAPE’ TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE ‘SBT_TAPE’ TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘D:\ORACLE\ORA1020\DATABASE\SNCFISC01P.ORA’; # default
———————————————————-

继续阅读 »

expdp – include & exclude

you can use parameter EXCLUDE to exclude the objects when expdp/impdp. find the format below.

EXCLUDE=TABLE:”in (‘TABLE1′,’TABLE2′,’TABLE3’)”

EXCLUDE=SYNONYM,SEQUENCE,PACKAGE,FUNCTION,PROCEDURE,VIEW,JOB,TABLE:”in (‘TABLE1′,’TABLE2′,’TABLE3’)”

for windows,

schemas=userA
include=TABLE:”IN \(‘TAB1’\)”
directory=dmpdir
dumpfile=DBNAME_USERA_tabs1.dmp
LOGFILE=DBNAME_USERA_tabs1.log