Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Archive for the ‘Oracle11gR2’ Category

CREATING AN ORACLE11GR2 DATABASE WITH FEW COMMANDS IN WINDOWS

Posted by Hendry chinnapparaj on February 14, 2012

G:\Hendry Scripts>oradim -new -sid HENDRY
Instance created.

G:\Hendry Scripts>edit initHENDRY.ora

db_name=HENDRY

G:\HENDRY~1>set ORACLE_SID=HENDRY

G:\HENDRY~1>sqlplus “/ as sysdba”

SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 14 14:45:52 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile=initHENDRY.ora
ORACLE instance started.

Total System Global Area 146472960 bytes
Fixed Size 1373152 bytes
Variable Size 92277792 bytes
Database Buffers 50331648 bytes
Redo Buffers 2490368 bytes
SQL> create database;

Database created.

SQL> select ts#, name from v$tablespace;

TS# NAME
———- ——————————
0 SYSTEM
1 SYSAUX
2 SYS_UNDOTS

SQL> column name format a60
SQL> select ts#, name from v$datafile;

TS# NAME
———- ————————————————————
0 G:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\DBS1HENDRY.ORA

1 G:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SYX1HENDRY.ORA

2 G:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\UND1HENDRY.ORA
SQL> column member format a60
SQL> select group#, member from v$logfile;

GROUP# MEMBER
———- ————————————————————
1 G:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\LOG1HENDRY.ORA

2 G:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\LOG2HENDRY.ORA
SQL> column name format a60
SQL> select name from v$controlfile;

NAME
————————————————————
G:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\CTL1HENDRY.ORA
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount exclusive restrict pfile=initHENDRY.ora
ORACLE instance started.

Total System Global Area 146472960 bytes
Fixed Size 1373152 bytes
Variable Size 92277792 bytes
Database Buffers 50331648 bytes
Redo Buffers 2490368 bytes
Database mounted.
SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Release 11.2.0.1.0 – Production
SQL> exit

G:\HENDRY~1>oradim -delete -sid HENDRY
Instance deleted.

Shalom

H

Advertisements

Posted in Database11g | Leave a Comment »

Clone Oracle11gR2 Database on Same Windows Server (without using RMAN)

Posted by Hendry chinnapparaj on February 14, 2012

Source Database : oracle11gr2
Clone New Database: clone1
Mode:- No Archive Mode
Login to Source Database – oracle11gr2
—————————-
SQL> create pfile from spfile;
File created.

SQL> alter database backup controlfile to trace;
Database altered.

mkdir G:\app\oracle\admin\clone1
mkdir G:\app\oracle\admin\clone1\adump
mkdir G:\app\oracle\oradata\clone1 — copy all the datafiles, redo log files here from the source.

Location of spfile and pfile
G:\app\oracle\product\11.2.0\dbhome_1\database
Copy INIToracle11gr2.ora as INITclone1.ora
INITclone1.ora
SPFILECLONE1.ORA
Edit INTclone1.ora and make the following changes and more if required.
*.audit_file_dest=’G:\app\oracle\admin\clone1\adump’
*.control_files=’G:\app\oracle\oradata\clone1\control01.ctl’,’G:\app\oracle\recovery_area\clone1\control02.ctl’
*.db_name=’clone1′
*.db_unique_name=’clone1′

create the script for Controlfile creation from the trace file generated in trace location
G:\app\oracle\diag\rdbms\oracle11gr2\oracle11gr2\trace\oracle11gr2_dbrm_4028.trc

vi createcon.sql
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE “CLONE1” RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘G:\APP\ORACLE\ORADATA\CLONE1\REDO01.LOG’ SIZE 50M BLOCKSIZE 512,
GROUP 2 ‘G:\APP\ORACLE\ORADATA\CLONE1\REDO02.LOG’ SIZE 50M BLOCKSIZE 512,
GROUP 3 ‘G:\APP\ORACLE\ORADATA\CLONE1\REDO03.LOG’ SIZE 50M BLOCKSIZE 512
DATAFILE
‘G:\APP\ORACLE\ORADATA\CLONE1\SYSTEM01.DBF’,
‘G:\APP\ORACLE\ORADATA\CLONE1\SYSAUX01.DBF’,
‘G:\APP\ORACLE\ORADATA\CLONE1\UNDOTBS01.DBF’,
‘G:\APP\ORACLE\ORADATA\CLONE1\USERS01.DBF’,
‘G:\APP\ORACLE\ORADATA\CLONE1\EXAMPLE01.DBF’
CHARACTER SET WE8MSWIN1252
;

RECOVER DATABASE USING BACKUP CONTROLFILE;

ALTER DATABASE OPEN RESETLOGS;

ALTER TABLESPACE TEMP ADD TEMPFILE ‘G:\APP\ORACLE\ORADATA\CLONE1\TEMP01.DBF’
SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;

ūüė°
Create the Listener Database Service, Tns entry and also the NEW Service

G:\app\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = clone1)
(ORACLE_HOME = G:\app\oracle\product\11.2.0\dbhome_1)
(SID_NAME = clone1)
)
)

ūüė°
G:\app\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
vi tnsnames.ora
CLONE1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.174.131)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = clone1)
)
)

ūüė°

G:\>oradim -NEW -SID CLONE1 -SRVC OracleServiceCLONE1 -STARTMODE manual -PFILE G:\app\oracle\product\11.2.0\dbhome_1\database\initclone1.ora
Instance created.

Go to the services and check if the New Oracle Service is running.
OracleServiceCLONE1
OracleJobSchedulerCLONE1
Oracle CLONE1 VSS Writer Service
Shutdown and Copy the Database files from the Source Oracle11gr2 database.

Create the Controlfile and startup the database

Open command prompt in Windows
set oracle_sid=clone1
sqlplus / as sysdba
SQL> @createcon.sql

ORACLE instance started.

Total System Global Area 422670336 bytes
Fixed Size 1375032 bytes
Variable Size 318768328 bytes
Database Buffers 96468992 bytes
Redo Buffers 6057984 bytes

Control file created.

Then open the database.

If you have copied the database files when the source database was running, then you will get error like

ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: ‘G:\APP\ORACLE\ORADATA\CLONE1\SYSTEM01.DBF’
Try the recovery steps below

copy also the online redo logfiles from the source database to the new clone1 database directory and specify the full path during recovery.

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1060604 generated at 02/14/2012 11:02:25 needed for thread 1
ORA-00289: suggestion :
G:\APP\ORACLE\RECOVERY_AREA\CLONE1\ARCHIVELOG\2012_02_14\O1_MF_1_7_%U_.ARC
ORA-00280: change 1060604 for thread 1 is in sequence #7
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
G:\app\oracle\oradata\clone1\REDO01.LOG
Log applied.
Media recovery complete.
SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL>

Create the Temporary tablespace

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘G:\APP\ORACLE\ORADATA\CLONE1\TEMP01.DBF

2 SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;

Tablespace altered.
SQL> select name,created, open_mode from v$database;

NAME CREATED OPEN_MODE
——— ——— ——————–
CLONE1 14-FEB-12 READ WRITE
==================================

SQL to generate the copy script

Select ‘COPY DATAFILE ‘ ||FILE_ID||’ TO “G:\app\oracle\oradata\clone1\’||SUBSTR(FILE_NAME,38,50)|| ‘”;’ from dba_data_files;
‘COPYDATAFILE’||FILE_ID||’TO”G:\APP\ORACLE\ORADATA\CLONE1\’||SUBSTR(FILE_NAME,38
——————————————————————————–
COPY DATAFILE 4 TO “G:\app\oracle\oradata\clone1\RS01.DBF”;
COPY DATAFILE 3 TO “G:\app\oracle\oradata\clone1\OTBS01.DBF”;
COPY DATAFILE 2 TO “G:\app\oracle\oradata\clone1\AUX01.DBF”;
COPY DATAFILE 1 TO “G:\app\oracle\oradata\clone1\TEM01.DBF”;
COPY DATAFILE 5 TO “G:\app\oracle\oradata\clone1\MPLE01.DBF”;

5 rows selected.

Shalom

H

Posted in Clone11g DB or Duplicate | Leave a Comment »

Error in writing to File “orancrypt11.dll” and “oravsn11.dll” during oracle11gr2 install on Windows

Posted by Hendry chinnapparaj on January 30, 2012

Problem:Error in writing to File “orancrypt11.dll” during oracle11gr2 install (copying files stage) on Windows 2003. The process cannot access the file because it’s being used by another process.
Solution: just rename the file to orancrypt11.dll.old and oravsn11.dll.old and click retry.

Posted in Install and Configure | Leave a Comment »

em.ear file not found error during oracle11gr2 installation on windows

Posted by Hendry chinnapparaj on January 30, 2012

Problem: For one of the Projects i was trying to install oracle11gR2 on a windows 2003 server and encountered¬†the error “em.ear” file not found.

Solution:- when you unzip the software files win32_11gR2_database-1of2 and win32_11gR2_database-2of2, unzip them on the same folder.

Shalom

H

Posted in Install and Configure | Leave a Comment »

Migrate 11.2.0.2 Non-ASM Database files to 11.2.0.2 ASM Storage

Posted by Hendry chinnapparaj on September 1, 2011

Thursday, 1 September 2011

Hendry Dasan

Purpose of Oracle ASM Data Migration

Alternatives to Oracle ASM storage include file systems, raw disks, and SAN configurations. Oracle ASM includes numerous benefits over these storage alternatives, including performance optimization, redundancy protection, and load balancing. You do not need a third-party Logical Volume Manager because Oracle ASM manages disks for you. Oracle Real Application Clusters (Oracle RAC) databases benefit from Oracle ASM because it provides ready-made shared storage.

If a database currently uses a storage system other than Oracle ASM, then you can migrate all or part of the database into Oracle ASM, thereby simplifying database administration. You can also migrate a fast recovery area to Oracle ASM.

Native operating system commands such as Linux cp or Windows COPY cannot write or read files in Oracle ASM storage. Because RMAN can read and write Oracle ASM files, you can use RMAN to copy data files into and out of Oracle ASM storage or between Oracle ASM disk groups. This technique is useful if you must store backups on user-managed disks.

 

Basic Concepts of Oracle ASM Data Migration

You can migrate data to Oracle ASM with RMAN even if you are not using RMAN as your primary backup tool. The migration requires one RMAN database backup.

If you have sufficient disk space to hold the entire database both in Oracle ASM and alternative storage systems, then you can move a database directly into Oracle ASM. If you do not have sufficient storage, then you can back the database up to tape, create an Oracle ASM disk group that uses old disk space, and restore the database from tape to Oracle ASM.

After you set the location of the new recovery area, existing backups remain in the old recovery area and count against the total disk quota of the recovery area. The backups are deleted from the old recovery area when space is needed. These backups are usable by RMAN. It is not necessary to move legacy backups to the new Oracle ASM recovery area unless you need disk space. To free space consumed by files in the old recovery area, you can back them up to tape or migrate them to the Oracle ASM recovery area.

 

Preparing to Migrate the Database to Oracle ASM Using RMAN

This section explains how to prepare the database for migration. This section makes the following assumptions:

You want to migrate the database to two Oracle ASM disk groups: +DATA for the database. The database to be migrated to Oracle ASM storage is named asmtest

 

 

Determine how much disk space will be required for your database Migration

Connect to the oracle11g database

 

select DF.TOTAL/1048576 “DataFile Size Mb”, LOG.TOTAL/1048576 “Redo Log Size Mb”, CONTROL.TOTAL/1048576 “Control File Size Mb”, (DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 “Total Size Mb” from dual, (select sum(a.bytes) TOTAL from dba_data_files a) DF, (select sum(b.bytes) TOTAL from v$log b) LOG, (select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL;

 

 

DataFile Size Mb Redo Log Size Mb Control File Size Mb Total Size Mb

—————- —————- ——————– ————-

38695.9688             1500           104.015625    40299.9844

 

 

Ensuring you have enough space within your ASM instance.

Connect to ASM Instance

+ASM:/u01/ofsad2> sqlplus / as sysasm

 

SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 31 10:33:40 2011

 

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production

With the Automatic Storage Management option

 

SQL> show user

USER is “SYS”

 

SQL> select NAME, STATE, TOTAL_MB, FREE_MB from v$asm_diskgroup;

 

NAME                           STATE         TOTAL_MB    FREE_MB

—————————— ———– ———- ———-

DATA                           MOUNTED         514687     465497

 

SQL> SELECT name, free_mb, total_mb, free_mb/total_mb*100 “FREE %” FROM v$asm_diskgroup;

 

NAME                              FREE_MB   TOTAL_MB     FREE %

—————————— ———- ———- ———-

DATA                               465497     514687 90.4427351

 

 

ENSURE COMPATIBEL IS 11.2.0.2.0 FOR THE ASM MIGRATION

If the COMPATIBLE initialization parameter setting for the database is less than 11.0.0, then make any read-only transportable tablespaces read/write. (JUST FOR TRANSPORTABLE TBLS ONLY). Read-only transportable tablespaces cannot be migrated because RMAN cannot back them up.

 

 

 

SQL> show parameter compatible

 

NAME                                 TYPE        VALUE

———————————— ———– ——————————

compatible                           string      11.2.0.2.0

SQL>

 

Database RMAN Configuration

 

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;

 

old RMAN configuration parameters:

CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;

new RMAN configuration parameters:

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

new RMAN configuration parameters are successfully stored

 

just do a backup test

 

RMAN> backup current controlfile;

 

Starting backup at 31-08-2011 14:37:03

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=203 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 31-08-2011 14:37:04

channel ORA_DISK_1: finished piece 1 at 31-08-2011 14:37:11

piece handle=+DATA/asmtest/backupset/2011_08_31/ncnnf0_tag20110831t143703_0.833.760631829 tag=TAG20110831T143703 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07

Finished backup at 31-08-2011 14:37:11

 

RMAN> show all;

 

RMAN configuration parameters for database with db_unique_name ASMTEST are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE ‘SBT_TAPE’ TO ‘%F’;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’;

CONFIGURE DEVICE TYPE ‘SBT_TAPE’ PARALLELISM 1 BACKUP TYPE TO BACKUPSET;

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;

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 CHANNEL 1 DEVICE TYPE ‘SBT_TAPE’ PARMS¬† “ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo_asmtest.opt)”;

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default

CONFIGURE COMPRESSION ALGORITHM ‘BASIC’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/oracle/product/11.2.0.2/dbs/snapcf_asmtest.f’; # default

 

RMAN>

 

Do a Backup of the Spfile

 

asmtest:/u01/oracle/product/11.2.0.2/dbs> cp -p spfileasmtest.ora spfileasmtest.ora.ori

 

Back up the data files to the Oracle ASM disk group.

The following example uses a RUN command to make a level 0 incremental backup and allocates a  single channel (allocate more channels to increase the backup speed). A level 0 incremental backup is an RMAN incremental backup that backs up all data blocks in the data files being backed up.

 

asmtest:/u01/oracle/product/11.2.0.2/dbs> rman target /

 

Recovery Manager: Release 11.2.0.2.0 – Production on Wed Aug 31 14:45:49 2011

 

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: ASMTEST (DBID=258344671)

 

RMAN> run

2> {

3> allocate channel dev1 device type disk;

4> backup as copy

5> incremental level 0

6> database

7> format ‘+DATA’

8> tag ‘ORA_ASM_MIGRATION’;

9> }

 

…

channel dev1: datafile copy complete, elapsed time: 00:00:01

channel dev1: starting datafile copy

input datafile file number=00216 name=/u02/oradata/asmtest/CSHIDX015_01.DBF

output file name=+DATA/asmtest/datafile/cshidx015.845.760633307 tag=ORA_ASM_MIGRATION RECID=265 STAMP=760633306

channel dev1: datafile copy complete, elapsed time: 00:00:01

channel dev1: starting datafile copy

input datafile file number=00259 name=/u02/oradata/asmtest/XMLDATA001.DBF

output file name=+DATA/asmtest/datafile/xml_data.846.760633307 tag=ORA_ASM_MIGRATION RECID=266 STAMP=760633307

channel dev1: datafile copy complete, elapsed time: 00:00:01

channel dev1: starting incremental level 0 datafile backup set

channel dev1: specifying datafile(s) in backup set

including current SPFILE in backup set

channel dev1: starting piece 1 at 31-08-2011 15:01:48

channel dev1: finished piece 1 at 31-08-2011 15:01:49

piece handle=+DATA/asmtest/backupset/2011_08_31/nnsnn0_ora_asm_migration_0.847.760633309 tag=ORA_ASM_MIGRATION comment=NONE

channel dev1: backup set complete, elapsed time: 00:00:01

Finished backup at 31-08-2011 15:01:49

released channel: dev1

 

 

 

can do an incremental backup just before the final migration if data is modified after full backup

 

The following example makes an incremental level 1 copy of the level 0 backup created in the previous step:

RUN

{

ALLOCATE CHANNEL dev1 DEVICE TYPE DISK;

BACKUP INCREMENTAL LEVEL 1

FOR RECOVER OF COPY WITH TAG ‘ORA_ASM_MIGRATION’

DATABASE;

}

 

 

 

 

 

asmtest:/u01/oracle/product/11.2.0.2/dbs> rman target /

 

Recovery Manager: Release 11.2.0.2.0 – Production on Wed Aug 31 15:05:00 2011

 

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: ASMTEST (DBID=258344671)

 

RMAN> run

2> {

3> allocate channel dev1 device type disk;

4> backup incremental level 1

5> for recover of copy with tag ‘ORA_ASM_MIGRATION’

6> database;

7> }

 

using target database control file instead of recovery catalog

allocated channel: dev1

channel dev1: SID=204 device type=DISK

 

Starting backup at 31-08-2011 15:05:55

channel dev1: starting incremental level 1 datafile backup set

channel dev1: specifying datafile(s) in backup set

input datafile file number=00025 name=/u02/oradata/asmtest/CB002_02.DBF

skipping datafile 00025 because it has not changed

input datafile file number=00003 name=/u02/oradata/asmtest/sysaux01.dbf

input datafile file number=00251 name=/u02/oradata/asmtest/MIS_DATA_64M_01.DBF

input datafile file number=00148 name=/u02/oradata/asmtest/CPS_LM_DATA_1M_01.DBF

input datafile file number=00253 name=/u02/oradata/asmtest/MIS_INDEX_1M_01.DBF

input datafile file number=00021 name=/u02/oradata/asmtest/BWA_LM_INDEX_64M_01.DBF

input datafile file number=00236 name=/u02/oradata/asmtest/DOCIX001_01.DBF

input datafile file number=00013 name=/u02/oradata/asmtest/AUT_LM_INDEX_8M_01.DBF

input datafile file number=00030 name=/u02/oradata/asmtest/CB004_01.DBF

input datafile file number=00035 name=/u02/oradata/asmtest/CB007_02.DBF

input datafile file number=00040 name=/u02/oradata/asmtest/CB009_02.DBF

input datafile file number=00045 name=/u02/oradata/asmtest/CB012_01.DBF

input datafile file number=00050 name=/u02/oradata/asmtest/CB014_02.DBF

input datafile file number=00055 name=/u02/oradata/asmtest/CB017_01.DBF

input datafile file number=00060 name=/u02/oradata/asmtest/CB019_02.DBF

input datafile file number=00107 name=/u02/oradata/asmtest/CBIDX007_01.DBF

input datafile file number=00112 name=/u02/oradata/asmtest/CBIDX012_01.DBF

input datafile file number=00117 name=/u02/oradata/asmtest/CBIDX017_01.DBF

input datafile file number=00157 name=/u02/oradata/asmtest/CPS_LM_INDEX_8M_01.DBF

input datafile file number=00165 name=/u02/oradata/asmtest/CSE005_01.DBF

input datafile file number=00170 name=/u02/oradata/asmtest/CSE010_01.DBF

input datafile file number=00175 name=/u02/oradata/asmtest/CSEIDX005_01.DBF

input datafile file number=00180 name=/u02/oradata/asmtest/CSEIDX010_01.DBF

input datafile file number=00186 name=/u02/oradata/asmtest/CSH005_01.DBF

input datafile file number=00191 name=/u02/oradata/asmtest/CSH010_01.DBF

input datafile file number=00204 name=/u02/oradata/asmtest/CSHIX003_01.DBF

input datafile file number=00209 name=/u02/oradata/asmtest/CSHIDX008_01.DBF

input datafile file number=00214 name=/u02/oradata/asmtest/CSHIDX013_01.DBF

input datafile file number=00227 name=/u02/oradata/asmtest/DOC005_01.DBF

input datafile file number=00232 name=/u02/oradata/asmtest/DOC010_01.DBF

input datafile file number=00238 name=/u02/oradata/asmtest/DOCIX003_01.DBF

input datafile file number=00243 name=/u02/oradata/asmtest/DOCIDX008_01.DBF

input datafile file number=00248 name=/u02/oradata/asmtest/DOCIDX013_01.DBF

input datafile file number=00118 name=/u02/oradata/asmtest/CBIDX018_01.DBF

input datafile file number=00011 name=/u02/oradata/asmtest/AUT_LM_INDEX_512K_01.DBF

input datafile file number=00220 name=/u02/oradata/asmtest/CSHIDX019_01.DBF

input datafile file number=00064 name=/u02/oradata/asmtest/CB021_02.DBF

input datafile file number=00069 name=/u02/oradata/asmtest/CB024_01.DBF

input datafile file number=00074 name=/u02/oradata/asmtest/CB026_02.DBF

input datafile file number=00079 name=/u02/oradata/asmtest/CB029_01.DBF

input datafile file number=00084 name=/u02/oradata/asmtest/CB031_02.DBF

input datafile file number=00089 name=/u02/oradata/asmtest/CB034_01.DBF

input datafile file number=00094 name=/u02/oradata/asmtest/CB036_02.DBF

input datafile file number=00099 name=/u02/oradata/asmtest/CB039_01.DBF

input datafile file number=00123 name=/u02/oradata/asmtest/CBIDX023_01.DBF

input datafile file number=00128 name=/u02/oradata/asmtest/CBIDX028_01.DBF

input datafile file number=00133 name=/u02/oradata/asmtest/CBIDX033_01.DBF

input datafile file number=00138 name=/u02/oradata/asmtest/CBIDX038_01.DBF

input datafile file number=00147 name=/u02/oradata/asmtest/CPSDATA_01.DBF

input datafile file number=00198 name=/u02/oradata/asmtest/CSH017_01.DBF

input datafile file number=00216 name=/u02/oradata/asmtest/CSHIDX015_01.DBF

channel dev1: starting piece 1 at 31-08-2011 15:05:57

channel dev1: finished piece 1 at 31-08-2011 15:06:12

piece handle=+DATA/asmtest/backupset/2011_08_31/nnndn1_ora_asm_migration_0.848.760633557 tag=ORA_ASM_MIGRATION comment=NONE

channel dev1: backup set complete, elapsed time: 00:00:15

channel dev1: starting incremental level 1 datafile backup set

channel dev1: specifying datafile(s) in backup set

input datafile file number=00026 name=/u02/oradata/asmtest/CB002_01.DBF

skipping datafile 00026 because it has not changed

input datafile file number=00002 name=/u02/oradata/asmtest/undotbs01.dbf

input datafile file number=00159 name=/u02/oradata/asmtest/CPS_XML_DOC_01.DBF

input datafile file number=00250 name=/u02/oradata/asmtest/MIS_DATA_1M_01.DBF

input datafile file number=00008 name=/u02/oradata/asmtest/AUT_LM_DATA_64M_01.DBF

input datafile file number=00182 name=/u02/oradata/asmtest/CSH001_01.DBF

input datafile file number=00252 name=/u02/oradata/asmtest/MIS_DATA_8M_01.DBF

input datafile file number=00033 name=/u02/oradata/asmtest/CB006_02.DBF

input datafile file number=00038 name=/u02/oradata/asmtest/CB008_01.DBF

input datafile file number=00043 name=/u02/oradata/asmtest/CB011_01.DBF

input datafile file number=00048 name=/u02/oradata/asmtest/CB013_02.DBF

input datafile file number=00053 name=/u02/oradata/asmtest/CB016_01.DBF

input datafile file number=00058 name=/u02/oradata/asmtest/CB018_02.DBF

input datafile file number=00105 name=/u02/oradata/asmtest/CBIX005_01.DBF

input datafile file number=00110 name=/u02/oradata/asmtest/CBIDX010_01.DBF

input datafile file number=00115 name=/u02/oradata/asmtest/CBIDX015_01.DBF

input datafile file number=00142 name=/u02/oradata/asmtest/CBTRAP_02.DBF

input datafile file number=00163 name=/u02/oradata/asmtest/CSE003_01.DBF

input datafile file number=00168 name=/u02/oradata/asmtest/CSE008_01.DBF

input datafile file number=00173 name=/u02/oradata/asmtest/CSEIX003_01.DBF

input datafile file number=00178 name=/u02/oradata/asmtest/CSEIDX008_01.DBF

input datafile file number=00184 name=/u02/oradata/asmtest/CSH003_01.DBF

input datafile file number=00189 name=/u02/oradata/asmtest/CSH008_01.DBF

input datafile file number=00194 name=/u02/oradata/asmtest/CSH013_01.DBF

input datafile file number=00207 name=/u02/oradata/asmtest/CSHIDX006_01.DBF

input datafile file number=00212 name=/u02/oradata/asmtest/CSHIDX011_01.DBF

input datafile file number=00225 name=/u02/oradata/asmtest/DOC003_01.DBF

input datafile file number=00230 name=/u02/oradata/asmtest/DOC008_01.DBF

input datafile file number=00235 name=/u02/oradata/asmtest/DOC013_01.DBF

input datafile file number=00241 name=/u02/oradata/asmtest/DOCIDX006_01.DBF

input datafile file number=00246 name=/u02/oradata/asmtest/DOCIDX011_01.DBF

input datafile file number=00258 name=/u02/oradata/asmtest/UINDEX01.DBF

input datafile file number=00010 name=/u02/oradata/asmtest/AUT_LM_INDEX_1M_01.DBF

input datafile file number=00020 name=/u02/oradata/asmtest/BWA_LM_INDEX_512K_01.DBF

input datafile file number=00221 name=/u02/oradata/asmtest/CSHIDX020_01.DBF

input datafile file number=00065 name=/u02/oradata/asmtest/CB022_01.DBF

input datafile file number=00070 name=/u02/oradata/asmtest/CB024_02.DBF

input datafile file number=00075 name=/u02/oradata/asmtest/CB027_01.DBF

input datafile file number=00080 name=/u02/oradata/asmtest/CB029_02.DBF

input datafile file number=00085 name=/u02/oradata/asmtest/CB032_01.DBF

input datafile file number=00090 name=/u02/oradata/asmtest/CB034_02.DBF

input datafile file number=00095 name=/u02/oradata/asmtest/CB037_01.DBF

input datafile file number=00100 name=/u02/oradata/asmtest/CB039_02.DBF

input datafile file number=00124 name=/u02/oradata/asmtest/CBIDX024_01.DBF

input datafile file number=00129 name=/u02/oradata/asmtest/CBIDX029_01.DBF

input datafile file number=00134 name=/u02/oradata/asmtest/CBIDX034_01.DBF

input datafile file number=00139 name=/u02/oradata/asmtest/CBIDX039_01.DBF

input datafile file number=00158 name=/u02/oradata/asmtest/CPS_LOB_LM_64_01.DBF

input datafile file number=00199 name=/u02/oradata/asmtest/CSH018_01.DBF

input datafile file number=00259 name=/u02/oradata/asmtest/XMLDATA001.DBF

channel dev1: starting piece 1 at 31-08-2011 15:06:13

 

…

 

nput datafile file number=00195 name=/u02/oradata/asmtest/CSH014_01.DBF

input datafile file number=00200 name=/u02/oradata/asmtest/CSH019_01.DBF

channel dev1: starting piece 1 at 31-08-2011 15:07:42

channel dev1: finished piece 1 at 31-08-2011 15:08:07

piece handle=+DATA/asmtest/backupset/2011_08_31/nnndn1_ora_asm_migration_0.852.760633663 tag=ORA_ASM_MIGRATION comment=NONE

channel dev1: backup set complete, elapsed time: 00:00:25

channel dev1: starting incremental level 1 datafile backup set

channel dev1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel dev1: starting piece 1 at 31-08-2011 15:08:08

channel dev1: finished piece 1 at 31-08-2011 15:08:09

piece handle=+DATA/asmtest/backupset/2011_08_31/ncsnn1_ora_asm_migration_0.853.760633689 tag=ORA_ASM_MIGRATION comment=NONE

channel dev1: backup set complete, elapsed time: 00:00:01

Finished backup at 31-08-2011 15:08:09

released channel: dev1

 

If the database is in ARCHIVELOG mode, and if the database is open, then archive the online logs.

The following example uses the SQL command to archive the current redo logs:

 

 

RMAN> SQL “ALTER SYSTEM ARCHIVE LOG CURRENT”;

 

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

 

If the database instance is currently using a server parameter file, then back it up.

The following example backs up the server parameter file:

RMAN> BACKUP AS BACKUPSET SPFILE;

 

Starting backup at 31-08-2011 15:09:48

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=204 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 31-08-2011 15:09:49

channel ORA_DISK_1: finished piece 1 at 31-08-2011 15:09:50

piece handle=+DATA/asmtest/backupset/2011_08_31/nnsnf0_tag20110831t150949_0.855.760633789 tag=TAG20110831T150949 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 31-08-2011 15:09:50

 

 

If block change tracking is enabled, then disable it.

The following command disables block change tracking:

 

RMAN> SQL “ALTER DATABASE DISABLE BLOCK CHANGE TRACKING”;

 

sql statement: ALTER DATABASE DISABLE BLOCK CHANGE TRACKING

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of sql command on default channel at 08/31/2011 15:10:38

RMAN-11003: failure during parse/execution of SQL statement: ALTER DATABASE DISABLE BLOCK CHANGE TRACKING

ORA-19759: block change tracking is not enabled

 

Shut down the database consistently.

The following command shuts down the database:

RMAN> SHUTDOWN IMMEDIATE;

database closed

database dismounted

Oracle instance shut down

 

 

ASM DISK USAGE AT THIS POINT AFTER DOING THE BACKUP

 

SQL> SELECT name, free_mb, total_mb, free_mb/total_mb*100 “FREE %” FROM v$asm_diskgroup;

 

NAME                              FREE_MB   TOTAL_MB     FREE %

—————————— ———- ———- ———-

DATA                               426002     514687 82.7691393

 

 

 

Migrating the Database to Oracle ASM Using RMAN

The following procedure is intended to minimize database downtime.

 

If the database is using a server parameter file, then restore it to the Oracle ASM disk group with the following commands, where sid is the SID of the instance:

 

RMAN> STARTUP MOUNT

 

connected to target database (not started)

Oracle instance started

database mounted

 

Total System Global Area     680607744 bytes

 

Fixed Size                     2222736 bytes

Variable Size                226493808 bytes

Database Buffers             444596224 bytes

Redo Buffers                   7294976 bytes

 

RMAN> run

2> {

3> allocate channel dev1 device type disk;

4> RESTORE SPFILE TO ‘+DATA/spfileasmtest.ora’;

5> }

 

allocated channel: dev1

channel dev1: SID=580 device type=DISK

 

Starting restore at 31-08-2011 15:18:28

 

channel dev1: starting datafile backup set restore

channel dev1: restoring SPFILE

output file name=+DATA/spfileasmtest.ora

channel dev1: reading from backup piece +DATA/asmtest/backupset/2011_08_31/nnsnf0_tag20110831t150949_0.855.760633789

channel dev1: piece handle=+DATA/asmtest/backupset/2011_08_31/nnsnf0_tag20110831t150949_0.855.760633789 tag=TAG20110831T150949

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:05

Finished restore at 31-08-2011 15:18:33

released channel: dev1

 

 

 

 

SQL> show parameter spfile

 

NAME                                 TYPE        VALUE

———————————— ———– ——————————

spfile                               string      /u01/oracle/product/11.2.0.2/d

bs/spfileasmtest.ora

 

 

 

 

Set Oracle Managed Files initialization parameters to Oracle ASM locations.

Note:

If you are not migrating the fast recovery area, then do not change the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameter settings. However, you must set DB_CREATE_ONLINE_LOG_DEST_n parameter to an Oracle ASM location for migration of the online redo logs.

Set the DB_CREATE_FILE_DEST and optional DB_CREATE_ONLINE_LOG_DEST_n initialization parameters to Oracle ASM disk groups. If the database uses a recovery area, then change the recovery area location to the Oracle ASM disk group. Also, change the recovery area size.

 

 

RMAN> shutdown immediate

 

database dismounted

Oracle instance shut down

 

RMAN> STARTUP FORCE NOMOUNT;

 

Oracle instance started

 

Total System Global Area     680607744 bytes

 

Fixed Size                     2222736 bytes

Variable Size                230688112 bytes

Database Buffers             440401920 bytes

Redo Buffers                   7294976 bytes

 

 

SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST=’+DATA’ SID=’*’;

 

System altered.

 

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=100G SID=’*’;

 

System altered.

 

 

Set the CONTROL_FILES initialization parameter to Oracle ASM locations

 

SQL> STARTUP FORCE NOMOUNT;

ORACLE instance started.

 

Total System Global Area  680607744 bytes

Fixed Size                  2222736 bytes

Variable Size             230688112 bytes

Database Buffers          440401920 bytes

Redo Buffers                7294976 bytes

SQL> ALTER SYSTEM SET CONTROL_FILES=’+DATA’ SCOPE=SPFILE SID=’*’;

 

System altered.

 

Migrate the control file to Oracle ASM and mount the control file.

 

 

RMAN> RESTORE CONTROLFILE FROM ‘/u02/oradata/asmtest/control01.ctl’;

 

Starting restore at 31-08-2011 15:32:27

using channel ORA_DISK_1

 

channel ORA_DISK_1: copied control file copy

output file name=+DATA/asmtest/controlfile/current.857.760635149

Finished restore at 31-08-2011 15:32:28

 

RMAN> ALTER DATABASE MOUNT;

 

database mounted

released channel: ORA_DISK_1

 

Migrate the data files to Oracle ASM.

Use RMAN to switch to the database copy that you created in step above “Back up the data files to the Oracle ASM disk group” in “Preparing to Migrate the Database to Oracle ASM Using RMAN”. The switch renames all the data files to files on Oracle ASM disk groups. Afterward, recover the database. If incremental backups were taken, then RMAN applies them during recovery. For example, enter the following commands at the RMAN prompt:

SWITCH DATABASE TO COPY;

RUN

{

ALLOCATE CHANNEL dev1 DEVICE TYPE DISK;

RECOVER DATABASE;

}

 

RMAN> SWITCH DATABASE TO COPY;

 

datafile 246 switched to datafile copy “+DATA/asmtest/datafile/docidx011.665.760633199”

datafile 247 switched to datafile copy “+DATA/asmtest/datafile/docidx012.664.760633199”

datafile 248 switched to datafile copy “+DATA/asmtest/datafile/docidx013.663.760633201”

datafile 249 switched to datafile copy “+DATA/asmtest/datafile/doctrap.662.760633203”

datafile 250 switched to datafile copy “+DATA/asmtest/datafile/mis_lm_data_1m.806.760633037”

datafile 251 switched to datafile copy “+DATA/asmtest/datafile/mis_lm_data_64m.812.760633019”

datafile 252 switched to datafile copy “+DATA/asmtest/datafile/mis_lm_data_8m.791.760633057”

datafile 253 switched to datafile copy “+DATA/asmtest/datafile/mis_lm_index_1m.805.760633039”

datafile 254 switched to datafile copy “+DATA/asmtest/datafile/mis_lm_index_8m.816.760633007”

datafile 255 switched to datafile copy “+DATA/asmtest/datafile/ro_test.656.760633209”

datafile 256 switched to datafile copy “+DATA/asmtest/datafile/statspack.815.760633009”

datafile 257 switched to datafile copy “+DATA/asmtest/datafile/user_data.661.760633203”

datafile 258 switched to datafile copy “+DATA/asmtest/datafile/user_index.660.760633205”

datafile 259 switched to datafile copy “+DATA/asmtest/datafile/xml_data.846.760633307”

datafile 260 switched to datafile copy “+DATA/asmtest/datafile/bw_audit.818.760632997”

datafile 261 switched to datafile copy “+DATA/asmtest/datafile/soe.814.760633013”

datafile 262 switched to datafile copy “+DATA/asmtest/datafile/soeindex.819.760632989”

 

RMAN> run

2> {

3> allocate channel dev1 device type disk;

4> recover database;

5> }

 

destination for restore of datafile 00231: +DATA/asmtest/datafile/doc009.679.760633183

destination for restore of datafile 00237: +DATA/asmtest/datafile/docidx002.674.760633189

destination for restore of datafile 00242: +DATA/asmtest/datafile/docidx007.669.760633193

destination for restore of datafile 00247: +DATA/asmtest/datafile/docidx012.664.760633199

destination for restore of datafile 00260: +DATA/asmtest/datafile/bw_audit.818.760632997

destination for restore of datafile 00261: +DATA/asmtest/datafile/soe.814.760633013

channel dev1: reading from backup piece +DATA/asmtest/backupset/2011_08_31/nnndn1_ora_asm_migration_0.852.760633663

channel dev1: piece handle=+DATA/asmtest/backupset/2011_08_31/nnndn1_ora_asm_migration_0.852.760633663 tag=ORA_ASM_MIGRATION

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:03

 

starting media recovery

media recovery complete, elapsed time: 00:00:03

 

Finished recover at 31-08-2011 15:36:35

released channel: dev1

 

RMAN>

 

 

If the database uses block change tracking or Flashback Database, then enable these features

 

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘+DATA’;

 

Database altered.

 

SQL> ALTER DATABASE FLASHBACK ON;

 

Database altered.

 

SQL> ALTER DATABASE OPEN;

 

Database altered.

 

Drop the tempfiles and re-create them in Oracle ASM

 

SQL> select name from v$tempfile;

 

NAME

——————————————————————————–

/u02/oradata/asmtest/temp01.dbf

 

SQL> ALTER DATABASE TEMPFILE ‘/u02/oradata/asmtest/temp01.dbf’ DROP;

 

Database altered.

 

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE;

 

Tablespace altered.

 

 

 

 

More info here:-

http://download.oracle.com/docs/cd/E11882_01/server.112/e16102/asm_rman.htm#i1022780

 

Posted in Database11g, Oracle11gR2 GRID INFRA and ASM | Leave a Comment »

Uninstall and Install ORACLE CONFIGURATION MANAGER (OCM) for Oracle 11Gr2 and also for Oracle10g

Posted by Hendry chinnapparaj on August 19, 2011

OCM DeInstall Steps for AIX

—————————

# Please do this for ALL Oracle Homes that have had OCM installed previously.

 

– The only env variable needed for the below to work for each home is ORACLE_HOME. Set this as required manually (or use already configured aliases). It is also fine to be set to the agent home too.

export ORACLE_HOME=/u01/oracle/product/…¬†¬† or

export ORACLE_HOME/u01/oracle/agent[10|11]g

 

– Stop OCM if running. Look for a nmz process relating to the Oracle Home as above in ps -ef output.

Ps ‚Äďef|grep nmz

$ORACLE_HOME/ccr/bin/emCCR stop

 

– If OCM database collections were previously done (presence of ORACLE_OCM user in db is enough to confirm this), FOR EACH DATABASE on the server set the env and execute the below as SYS. Otherwise goto next step.

SQL> @?/ccr/admin/scripts/dropocm.sql¬† <–¬† this drops the ORACLE_OCM user and does other things too.

 

– If OCM collections were previously done (presence of below deployPackages file is enough to confirm this), execute the below IN EACH ORACLE HOME. Otherwise goto next step.

$ORACLE_HOME/ccr/bin/deployPackages -d $ORACLE_HOME/ccr/inventory/core.jar

 

– Remove the previous OCM install folder FROM EACH ORACLE HOME.

rm -rf $ORACLE_HOME/ccr

 

————————-

OCM Install Steps for AIX

————————-

ftp the latest OCM Patch p5567658_1035_AIX64-5L.zip to the Aix server in binary mode to /u01/oracle/stage

login as oracle (or equiv) software owner

# OCM Install for all Oracle Homes

 

– Set the env for the Oracle Home and run the below to start the install.

cd /u01/oracle/stage

unzip -d $ORACLE_HOME /u01/oracle/stage/p5567658_1035_AIX64-5L.zip

 

cd $ORACLE_HOME/ccr/bin

export CCR_DISABLE_CRON_ENTRY=1

./setupCCR -s 18070588 duty.dba@xyz.com

 

NONE (this is case sensitive too)

CMDOMAU\svc-proxy-oracle-cm@sc-proxy.ytdomau.local:8080

Provide password

 

– Make required OCM customisations.

./emCCR automatic_update off

./emCCR set collection_interval=”FREQ=DAILY; BYHOUR=18; BYMINUTE=10″¬† <–¬† change BYHOUR and BYMINUTE to be some time preferably evenings within 6-7pm and record the details in ¬†spreadsheet. For existing deployments please reuse current set times.

 

– Add in below 3 lines of text to OCM properties file to exclude IP and MAC address collection.

vi $ORACLE_HOME/ccr/hosts/<hostname>/config/collector.properties¬† <–¬† add in hostname in lowercase before using this line. There should be content in the file already.

ccr.metric.host.ecm_hw_nic.inet_address=false

ccr.metric.host.ecm_hw_nic.mac_address=false

ccr.metric.host.ecm_hw_nic.broadcast_address=false

 

– Cycle OCM to pickup this exclusion.

$ORACLE_HOME/ccr/bin/emCCR stop

$ORACLE_HOME/ccr/bin/emCCR start

 

# OCM Install into each database if Oracle Home is a DB Home

 

– Instrumenting the Database for Configuration Collection

cd $ORACLE_HOME/ccr/admin/scripts

./installCCRSQL.sh collectconfig -s <Oracle Sid>¬† <–¬† change Oracle Sid before using this line.

Successfully installed collectconfig in the database with SID=<Oracle Sid>.

 

– Repeat above line for other databases in this Oracle Home.

 

– Run new manual collection to pickup database(s) content

cd $ORACLE_HOME/ccr/bin

./emCCR collect

 

# Go back and do the above for ASM or other Homes (e.g. Agent Home) if present – but with a collection time ideally 5 mins before or after the DB Home.

 

# Remove the OCM install zipfile once the change is complete.

 

 

 

Posted in OCM for Oracle 11GR2 | Leave a Comment »

Managing Memory in Oracle11gR2

Posted by Hendry chinnapparaj on August 17, 2011

Specify a memory target covering the SGA and PGA – and then also the db cache and share pool size parms (as these change from being a setting to a lower limit when memory_target is set). This way it prevents the auto tuning from getting carried away with undersizing either of these.

memory_target            5,368,709,120
db_cache_size              805,306,368
shared_pool_size          805,306,368

Upon dumping the spfile contents to pfile the double underscore hidden parms show where these two are currently operating – you can see it is actually working at present with the shared pool being capped from going any lower:

__sga_target            3,489,660,928
__pga_aggregate_target    1,879,048,192

__db_cache_size        2,583,691,264
__shared_pool_size          805,306,368

__java_pool_size           16,777,216
__large_pool_size           33,554,432
__streams_pool_size           16,777,216
__shared_io_pool_size            0

Posted in Oracle11gR2 Tuning | Leave a Comment »

Rman: Ora-01008 When Connecting To Target in 11.2.0.2

Posted by Hendry chinnapparaj on August 15, 2011

Rman: Ora-01008 When Connecting To Target in 11.2.0.2 [ID 1280447.1]

Problem:

The RMAN Backup job failed with the error

RMAN> backup archivelog all;

Starting backup at 15-08-2011 14:40:29

DBGSQL:¬†¬†¬†¬† TARGET> select¬† nvl(max(al.recid), ‘0’),nvl(max(al.recid), 0)¬†¬† into¬† :txtparmvalue, :parmvalue¬†¬† from¬† v$archived_log al¬† where¬† al.status in (‘X’, ‘A’)¬†¬†¬† and¬† al.is_recovery_dest_file = ‘YES’¬†¬†¬† and¬† al.creator = ‘RMAN’
DBGSQL:        sqlcode = 1008
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/15/2011 14:40:29
RMAN-03014: implicit resync of recovery catalog failed
ORA-01008: not all variables bound

RMAN> exit

This is a bug for  11.2.0.2 databases or so says Metalink note 1280447.1

To fix the issue Рalter system  flush shared_pool ;

Cause
This issue is discussed in Bug#10414993 which has been closed as a duplicate of (non-published)
Bug# 9877980 which in turn will be fixed in the 11.2.0.3 Patch Set Release.

Solution
As a workaround you can flush the shared pool.

SQL> alter system flush shared_pool;

This will allow you to connect with rman.

Posted in RMAN11G | Leave a Comment »

ORA-39142: incompatible version number 3.1 in dump file “/u01/oracle/dpdump/expdat.dmp”

Posted by Hendry chinnapparaj on June 29, 2011

Problem

——————-

I was exporting data from a 11.2.0.2 database and trying to import the dump into a 10.2.0.3 database

While importing the dump into a lower version database , the foll errors were thrown :

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file “/u01/oracle/dpdump/expdat.dmp”
Solution

—————-

To avoid this error, while exporting from the 11g database , add the foll parameter –¬† version=10.2

exdp xxx/xxx parfile=abc.par version=10.2

Then import this dump into the 10.2.0.3 database and it goes through without any errors.

 

Posted in Oracle Utilities | Leave a Comment »

11g Datapump – how fast is it?

Posted by Hendry chinnapparaj on June 20, 2011

How long to export 1 billion (yes, not a million) rows (8 columns) from a single table in the DSE?

Pick a time and scroll down for the answer….

 

 

 

9 mins & 9 seconds…¬†¬†¬†¬†¬†¬† ¬† –¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† 1,047,869,238 rows

 

 

That’s about 1.9 million rows per second.

Exports out to 48Gb of dump files on disk.

This is with 12 concurrent processes, uncompressed. (3 core LPAR)

Interestingly, doing the same, exporting out to compressed dump files finishes in 10 mins 59secs (17% slower) but the compressed dumps total 5.39Gb (89% improvement)¬† Not surprisingly, we’ll be using the compressed option on the 11g upgraded MSE!

Export: Release 11.2.0.2.0 – Production on Mon Jun 20 12:06:25 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

;;;

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production

With the Partitioning option

Starting “SYSTEM”.”AD_IVR_CALL_EVENTS”:¬† system/******** parfile=/u01/local/dbhk/scripts/par/AD_IVR_CALL_EVENTS.par

Estimate in progress using STATISTICS method…

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200808″¬† 709.4 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200904″¬† 637.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200701″¬† 586.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201007″¬† 578.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200907″¬† 569.4 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200812″¬† 569.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200412″¬† 562.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200910″¬† 557.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200807″¬† 557.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200810″¬† 555.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200912″¬† 553.1 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201003″¬† 550.9 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201012″¬† 550.9 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201008″¬† 546.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200607″¬† 543.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200606″¬† 542.9 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200406″¬† 542.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200707″¬† 540.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200903″¬† 539.1 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200911″¬† 538.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201103″¬† 537.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200905″¬† 536.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200603″¬† 536.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200710″¬† 536.1 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200801″¬† 535.6 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200705″¬† 530.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200503″¬† 530.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200608″¬† 529.9 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201006″¬† 529.1 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201004″¬† 528.9 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200703″¬† 528.6 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200805″¬† 528.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200706″¬† 527.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200403″¬† 525.6 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200605″¬† 524.6 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200708″¬† 524.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201005″¬† 521.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200908″¬† 521.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200512″¬† 521.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200612″¬† 520.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200508″¬† 519.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200803″¬† 519.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200809″¬† 519.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200611″¬† 518.1 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200906″¬† 518.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200909″¬† 517.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201011″¬† 517.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201105″¬† 517.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200610″¬† 515.4 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200407″¬† 514.7 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200804″¬† 513.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201101″¬† 509.6 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200404″¬† 508.1 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201001″¬† 508.1 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200511″¬† 507.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201009″¬† 506.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200601″¬† 505.9 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201104″¬† 503.9 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201010″¬† 502.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200806″¬† 500.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200501″¬† 500.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200802″¬† 499.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200704″¬† 498.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200711″¬† 496.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200409″¬† 495.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200510″¬† 494.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200604″¬† 493.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200509″¬† 491.7 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200811″¬† 489.7 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200901″¬† 488.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200405″¬† 485.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200609″¬† 483.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200504″¬† 481.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201002″¬† 480.5 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201102″¬† 479.8 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200702″¬† 477.4 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200709″¬† 477.4 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200411″¬† 477.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200712″¬† 477.1 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200408″¬† 477.0 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200602″¬† 471.2 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200402″¬† 469.6 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200902″¬† 462.7 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200502″¬† 451.7 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200507″¬† 441.3 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200410″¬† 439.4 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200505″¬† 115.9 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201106″¬† 26.43 MB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200506″¬†¬†¬†¬†¬† 0 KB

.¬† estimated “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_MAXVAL”¬†¬†¬†¬†¬† 0 KB

Total estimation using STATISTICS method: 43.72 GB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/AUDIT_OBJ

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200810″¬† 604.1 MB 12939912 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201007″¬† 632.0 MB 13474288 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200912″¬† 606.3 MB 12892550 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200412″¬† 616.2 MB 13085351 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200910″¬† 606.3 MB 12986081 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200807″¬† 616.8 MB 13260488 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200907″¬† 631.7 MB 13574572 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200701″¬† 641.0 MB 13655199 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200904″¬† 694.5 MB 14862177 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200812″¬† 634.7 MB 13592978 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201012″¬† 605.0 MB 12850284 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201008″¬† 599.1 MB 12726329 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200808″¬† 771.8 MB 16531124 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201103″¬† 590.2 MB 12535919 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201003″¬† 603.8 MB 12834227 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200607″¬† 591.3 MB 12653571 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200911″¬† 586.8 MB 12556209 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200606″¬† 591.7 MB 12651270 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200707″¬† 589.2 MB 12603246 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200903″¬† 600.9 MB 12868423 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200710″¬† 595.2 MB 12773875 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200406″¬† 592.2 MB 12637972 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200905″¬† 597.8 MB 12800999 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200603″¬† 586.0 MB 12493271 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200801″¬† 594.8 MB 12746291 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200705″¬† 579.4 MB 12348292 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200503″¬† 582.5 MB 12377092 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201004″¬† 579.7 MB 12321619 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201006″¬† 578.0 MB 12330863 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200703″¬† 576.7 MB 12292556 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200403″¬† 575.4 MB 12247907 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200805″¬† 574.6 MB 12309609 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200608″¬† 578.8 MB 12340844 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200706″¬† 575.1 MB 12293222 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200708″¬† 573.1 MB 12214623 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200605″¬† 573.2 MB 12220353 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200512″¬† 569.2 MB 12137220 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201005″¬† 571.1 MB 12138518 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200908″¬† 580.8 MB 12437572 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201011″¬† 567.9 MB 12065936 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201105″¬† 566.1 MB 12021580 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200508″¬† 566.9 MB 12093661 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201101″¬† 559.8 MB 11891896 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200612″¬† 569.4 MB 12133487 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200803″¬† 575.9 MB 12336807 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200809″¬† 564.6 MB 12093460 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200611″¬† 566.9 MB 12083574 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200909″¬† 575.3 MB 12320296 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200906″¬† 574.5 MB 12347610 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200407″¬† 560.6 MB 11976380 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201009″¬† 555.4 MB 11801545 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201104″¬† 554.2 MB 11769178 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200610″¬† 562.4 MB 11988388 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201010″¬† 550.3 MB 11696143 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200804″¬† 571.6 MB 12245285 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200404″¬† 556.5 MB 11840166 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201001″¬† 556.8 MB 11841551 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200511″¬† 554.1 MB 11818410 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200601″¬† 552.7 MB 11788350 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200806″¬† 554.6 MB 11926007 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200501″¬† 548.2 MB 11651476 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200802″¬† 555.8 MB 11909144 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200704″¬† 546.2 MB 11640865 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200711″¬† 551.5 MB 11823282 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200604″¬† 539.8 MB 11507238 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200510″¬† 538.6 MB 11502404 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201102″¬† 526.4 MB 11181328 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200509″¬† 535.7 MB 11438151 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200409″¬† 543.6 MB 11565692 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200901″¬† 543.1 MB 11636825 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200811″¬† 532.6 MB 11412449 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200405″¬† 530.1 MB 11287595 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201002″¬† 526.7 MB 11198516 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200609″¬† 528.3 MB 11264507 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200702″¬† 520.8 MB 11101477 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200504″¬† 528.6 MB 11240207 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_201106″¬† 28.90 MB¬† 615580 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200411″¬† 522.1 MB 11119657 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200712″¬† 531.0 MB 11379792 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200505″¬† 127.2 MB 2705187 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200602″¬† 514.8 MB 10981016 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200408″¬† 523.2 MB 11144453 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200709″¬† 521.1 MB 11109906 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200402″¬† 514.0 MB 10943865 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200902″¬† 503.3 MB 10782745 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200502″¬† 495.0 MB 10525001 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200410″¬† 480.5 MB 10239449 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200506″¬†¬†¬†¬†¬† 0 KB¬†¬†¬†¬†¬†¬† 0 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_MAXVAL”¬†¬†¬†¬†¬† 0 KB¬†¬†¬†¬†¬†¬† 0 rows

. . exported “MSE”.”AD_IVR_CALL_EVENTS”:”AD_IVREVE_200507″¬† 480.7 MB 10284825 rows

Master table “SYSTEM”.”AD_IVR_CALL_EVENTS” successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.AD_IVR_CALL_EVENTS is:

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_01.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_02.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_03.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_04.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_05.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_06.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_07.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_08.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_09.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_10.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_11.dmp

/u02/oradata/export/MSEp/AD_IVR_CALL_EVENTS_12.dmp

Job “SYSTEM”.”AD_IVR_CALL_EVENTS” successfully completed at 12:15:34

Posted in Oracle Utilities | Leave a Comment »