Backup & Recovery :: Migrating Databases / Task To Migrate Total Databases

Mar 27, 2012

I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.

temp tablespace
***************
current server - 4.0(approximately)
Migrating server - 160 MB

System tablespace
*****************
current server - 580 MB
Migrating server - 220 MB

Also I checked the tables are also matching for the 4 databases.Also Provide the solution or method which is correct.

steps done for migrating(By me)
********************************
EXPORTING DATA USING DATAPUMP
*********************************

1 From command prompt MKDIR 'c:oraclexeapp mp';

2 From SQL prompt conn system/kotak;

3 create or replace directory dmpdir as 'c:oraclexeapp mp';

4 grant read,write on directory dmpdir to kotak;

5 From command prompt

expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log;
IMPORTING DATA USING DATAPUMP
*****************************
in another server machine

1 From SQL prompt conn system/kotak;

2 create or replace directory dmpdir as 'c:oraclexeapp mp';

3 grant read,write on directory dmpdir to kotak;

4 From command prompt set ORACLE_SID=xe;

5 impdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=impdpxe.log;

IN OUR PROCESS we created the below tablespaces and user before IMPORTING created 4 tablespaces

1. kotak
2. kotakdb
3. wired_data
4. ferrari

Created Users which are there in 219 server
1. KOTAK
2. KOTAKDB
3. FC_80
4. DEMOINTERNETBANK
5. DEMOINTERNETBANKDB
6. CREDITCARD

View 1 Replies


ADVERTISEMENT

Backup & Recovery :: EBU Catalog Registered 2 Databases With Same Name But Different Hosts

Jun 14, 2011

When we run a backup of a database [oracle7.3.4.5] using EBU [2.2.1.0.0] on Solaris 7, error message appears:

Statement processed.
BFS in progress "1134684df1de4a" cancelled on 10-JUN-2011 11:05:34
BFS in progress "1134694df1de4a" cancelled on 10-JUN-2011 11:05:35

Ending backup to tape

This backup spawns archive sequence numbers 1731 to 1731
This backup comprises SCN 8725981 to 8725802
EBU-2003: Job 24267 failed due to an internal error
on 10-JUN-2011 11:05:52 [ 7178 : brcdodbfil ]
[cod]....

In EBU catalog, are registered 2 databases with the same name but different hosts.

View 3 Replies View Related

Migrate MySQL And Access Databases Over To Oracle 9i

Oct 2, 2008

I need to migrate MySQL and Access databases over to Oracle 9i. Is there a tool that will do this and also migrate sql scripts?

I heard of Oracle Workbench as one tool I could use?

View 4 Replies View Related

Server Administration :: Migrate Two Different Databases To Oracle?

Jul 11, 2012

I have to migrate two different databases to oracle.i have made two Migration Repository for each to do the migration, migration is done.but i would like to know can it be done with one migration repository.if yes then with one is best way to do it.data of two databases is different but table and sp are 99% same.

View 3 Replies View Related

Calculate Total Disk Space Used By Oracle Databases Across Whole Company?

Oct 18, 2013

If we want to know the number of instances, number of RAC databases  and whole total disk space used by oracle (not file system size),1. Any script can be ran from OEM grid control against all instances/databases? or2. we have a repository unix server which has all tnsnames of whole databases, any script we can run from there?

View 5 Replies View Related

Attack Databases While Performing Backup?

Apr 1, 2011

are there any possibility to attack oracle databases while performing database backup!

View 3 Replies View Related

ShadowProtect To Backup Oracle Databases?

Mar 22, 2013

if you are using ShadowProtect to backup your Oracle databases. What are your experiences and the pros and cons in using ShadowProtect as the one and only backup/recovery tools for Oracle databases? Can the potential of ShadowProtect replaces the commonly use Oracle backup/recovery tools?

The reason why I raise this question is because my boss has the idea that ShadowProtect is THE best backup/recovery tools. Personally I don't think so, because there can be cases where we only need to recover the database and not the whole OS.

View 6 Replies View Related

Storage Systems Used For Saving Archive And Backup Files Especially For Oracle Databases

Mar 5, 2013

what type of storage systems used for saving archive files and backup files "especially for oracle databases"

View 5 Replies View Related

Backup & Recovery :: How To Migrate Oracle Database From 10g To 11g

May 25, 2012

how to migrate oracle database from 10g to 11g

View 1 Replies View Related

Backup & Recovery :: Migrate 10gR2 On SPARC 5.9 To SunOS 5.10 X86_64

Sep 24, 2012

I need to migrate a 10gR2 Ent Ed. from SPARC 5.9 to SunOS 5.10 x86_64 and then upgrade the database to 11gR2 on the target platform. With the below output I would like know if I have any other option besides the imp/exp.

SQL> /

PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- -------------------------------------------------- --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
4 HP-UX IA (64-bit) Big
9 IBM zSeries Based Linux Big
16 Apple Mac OS Big
18 IBM Power Based Linux Big

8 rows selected.

SQL> !uname -a
SunOS moloto 5.9 Generic_122300-17 sun4u sparc SUNW,Sun-Fire

SQL>

View -1 Replies View Related

Can Monitor 10.2.0.2 Databases Using OEM 11g

Feb 7, 2011

In my company we have few 10.2.0.2 databases and few 10.2.0.4 databases.Currently we are monitoring using OEM 10g (10.1.0.5.0) installed on a seperate server.

Planning to install OEM on a new server as part of server room renovation. let me know the process of installing OEM on a different server without loosing the historical data?Also wondering if the OEM 11g will support the current databases?

View 2 Replies View Related

Same Server Two Databases

Oct 3, 2012

I have a windows 2008 server.

I already installled oracle software for oracle_home C:/oracle/product/11.2.0/dbhome_1 for database DEV.

Now, I want to create new database with different oracle_home on same server with oracle_home as C:/oracle/product/11.2.0/dbhome_2 and SID as TEST.

Do I have to istall oracle software again ? if yes, what about inventoryfiles in C:\Program Files\Oracle\Inventory ? wont they be overwritten ?

View 3 Replies View Related

Multiple Databases With Same Name?

Nov 23, 2010

We are getting a consultant to upgrade an Oracle 9i installation to 11g R2. The current installation has 6 different databases installed on the same server. Each database is a different customer so for reasons of security we have requested that this be split into 6 virtual machines with one database per machine.

The consultant suggested that they could install the 11g database once and then just make copies (which would all have the same instance name. We are told that the TNS names can be configured so clients are directed to the right database.

View 3 Replies View Related

SQL & PL/SQL :: Sequence Can Be Used Across Databases?

Mar 19, 2012

As we can give grant on sequence and can use in different schema of same database, can same sequence be used across databases?

View 2 Replies View Related

Copy Data Between Databases

Oct 12, 2012

I want copy some tables from one database to another. Which of following is the fastest way:

- INSERT /*+APPEND*/ via database link
- Transportable Tablespaces
- datapump IMP/EXP (I supposed it's the slowest way)

View 2 Replies View Related

Oracle Example Databases And Tables

Oct 3, 2011

I'm just wondering because i didn't find any example / test databases for Oracle. Thus MS has its "northwind", mysql its "world" or "sakila".

Additionally, the tables view is quiet confusing, referring to all those generated tables (

[URL]........

I tried right-click + apply filter *remove generated* but it didn't work.

View 3 Replies View Related

SQL & PL/SQL :: How To Synch Two Oracle Databases

Aug 2, 2010

I have cloned the database into another using DBMS_METADTA API (export the metadata in xml form and recreate it on destination). I need to synch these two periodically. I need to update the XML to synchronize the databases.

I don't have 11g to use DBMS_METADATA_DIFF API.

View 7 Replies View Related

SQL & PL/SQL :: Comparing Tables In Two Different Databases

Apr 13, 2011

As part of our project, we need to perform table comparisons in two different databases. I am currently looking for various options to accomplish this.

One of them is doing minus operation between these two tables. Also, i have looked at the data compare option in toad utility.

View 1 Replies View Related

SQL & PL/SQL :: Query From Multiple Databases

Apr 14, 2010

I have a query that queries an Oracle 10g database see below

SELECT PLOGDBY, COUNT(PLOGDBY) AS "Calls Logged"
FROM LCC_TPROBLEM WHERE
(PLOGDBY = 'WOODWARD_A' OR

PLOGDBY = 'BASSETT_A' OR
PLOGDBY = 'MISTRY_R' OR
PLOGDBY = 'MEADOWS_K' OR
PLOGDBY = 'SKINNER_R' OR
PLOGDBY = 'DAVIS_Z' OR
PLOGDBY = 'BLOUNT_L' OR

[Code]...

This gives me the result:

PLOGDBY Calls Logged
DAVIS_Z 11
MEADOWS_K 26
MISTRY_R 47
PATEL_RI 53
SKINNER_R 21
THANDI_D 58
WOODWARD_A 30

I also have a query that queries a SQL Server database:

Select Agent, SUM([acd calls which have rung the agent])As CallsRung
FROM Dashboard_stats
Where Date = DATEADD(DAY,DATEDIFF(DAY,'20000101',GETDATE())-1,'20000101')
Group by Agent

This gives me the result:

Davis_Z22
Meadows_K31
Mistry_R54
Patel_R65
Skinner_R35
Thandi_D89
Woodward_A34

What I want to do is write a query that returns the result:

Query 1(Oracle database) as a percentage of Query 2 (SQL Server database)

Results would be:

Davis_Z50%
Meadows_K83%
Mistry_R87%
Patel_R81%
Skinner_R60%
Thandi_D65%
Woodward_A88%

View 4 Replies View Related

2 Databases / 2 Listeners On 2 Different Ports?

Mar 14, 2011

I have 2 databases( A and .. which shares common ORACLE_HOME....

i configured 2 listeners through netca in different ports....

and both listener names are different...

But when I stop LISTENER.. both the listeners are getting stop and when i start both the listeners are up and running.. and I could see database B's services.. and vice versa...and when i tnsping , i am able to see port 1521 default port for database A.

when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..if so, which SID should I add A or B?

View 1 Replies View Related

SQL & PL/SQL :: New Table Creation From Different Databases?

Apr 9, 2013

I have two tables having same name in two different databases.i have to create a new table with these two tables in a new database.

But if one table have 2 columns and another table having three columns I have to create a new table with three columns..

View 6 Replies View Related

No Flashback For Pluggable Databases?

May 9, 2013

I've just found out that 12cR1 will not (in all likelihood) allow "flashback database" for pluggable DBs. Am I the only one disappointed by that ? I use flashback db (+replay) a lot to revert and replay automated tests and I had plans to consolidate tenths of test environments into PDBs.

View 3 Replies View Related

Multiple Databases In Linux Server?

Jun 16, 2013

while using top command it shows multiple processes usage.Actually we have 3 databases in the same server.how to find out which database process and user session hogging the cpu resources

View 2 Replies View Related

Options Licensing For Cloned Databases?

Mar 1, 2011

I have a production DB that has the oracle tuning pack option turned on, I occasionally need to clone the DB to a test server where I do not use the tuning pack, If I select from DBA_feature_usage_statistics it tells me that the Options pack is turned on for the Prod db DBID but not for the cloned db dbid. Do I need to worry about this old data being left around in my database? If so is there anyway to remove it? I am running 10.2.0.4

View 5 Replies View Related

Moving Databases To New Host Server?

Oct 7, 2012

I have a requirement to move the databases to a new server.

Existing set up:

database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.2
OS - UNIX AIX-5.3

New Server (setup):

database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.3
OS - UNIX AIX-6.1

My query is what is the best way to move the database to new server(UNIX AIX 6.1)?

a) can i upgrade the database to 11.2.0.3 before moving to new server or its better to move the database in 11.2.0.2 and then upgrade there?

b)is export and import of database can work for moving this?

c) RMAN backup and restoration can be done for moving databases?

d)simply moving all the related files to new server and start upgrading it from there?

View 8 Replies View Related

Consolidate RAC Databases In Single GI For A Cluster

Jul 11, 2012

I had installed grid infrastructure for a cluster, and RAC database. The ASM is the storage option. The configurations as follows:

Grid Home: /u01/grid/app

Oracle RAC Home: /oracle/db1/app/product/11.2/dbhome1

Can I have another RAC Database to use the existing Grid infrastructure ? The second RAC database will have different owner than db1.

The configurations as follows:

Grid Home: /u01/grid/app

DB1 Oracle RAC Home: /oracle/db1/app/product/11.2/dbhome1 and Database Name: RACDBA so the current instances are RACDBA1 and RACDBA2

DB2 Oracle RAC Home: /oracle/db2/app/product/11.2/dbhome2 and database name: RACDBB so the future instances will be RACDBB1 and RACDBB2

View 1 Replies View Related

Get A List Of All Servers Associated With Linked Databases?

Sep 24, 2012

How do I get a list of all servers associated with linked databases?

for example: I have an entry in TNSNAMES.ora:

PTSYS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = BMSQL2.BEAM.LOCAL)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PTSYS)
)
)

if I link this database as follows:

create public database link SourceDB --@PTSYS
CONNECT TO sysadm IDENTIFIED BY password
using
'PTSYS';

How can I tell that this database is on the BMSQL2 server?

View 1 Replies View Related

Table Data Comparisons Across Two Databases?

Oct 4, 2011

I want to compare the table contents across the two different databases , one is on netezza and other is on Exadata.

View 2 Replies View Related

Server Administration :: Multiple 11g Databases

Dec 5, 2010

I have Oracle 11g installed on AIX and I want to install another 11gR2 single instance in a different oracle home, will it be possible?

View 3 Replies View Related

Replication :: Data Between 4 Databases In Network

Nov 22, 2012

We want to replicate the data between the databases.We have 4 databases in a network.If there will be any change in database 1,e.g. updation in any table,it should automatically replicate on other 3 databases.or user will change something in database 2 ,it should replicate on other 3 databases and vice versa. All 4 databases have same schema and same configuration.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved