Database Duplication With Different DB ID And Oracle SID

Sep 3, 2010

I have the following question:

I try to duplicate a database on Host B with ORACLE_SID=hostb from an offline full backup plus archive log backup was taken from Host A with ORACLE_SID=hosta. Host A and Host B cannot communicate between them.

I don�t want to make a full restore of database, i want to make a duplicate database from that offline backup.

I need the duplicate database must be run with different ORACLE_SID and different DBID.

PD: I was reading the Oracle Documentation about that but i can�t find a step by step guide to follow.

Environment

Oracle 11gr2 with a Linux OS on x86_64 on host A and host B.

View 13 Replies


ADVERTISEMENT

CHARSET ORACLE Database Duplication?

Sep 22, 2010

Can i duplicate a database that is in a different CHARACTER SET?

If i can't made the duplication in a direct way, how can i convert or transform to duplicate a database from one character set o another?

View 7 Replies View Related

Oracle 11g Active Database Duplication?

Nov 2, 2011

I'm trying to set up Active Database Duplication between 2 Oracle 11g servers. Each server is identical, with the following characteristics:

- OS: Windows Server 2008
- Version: Ora11R2 (64 bit)
- DB Name: orcl
- Filesystem: asm (using grid infrastructure)

In addition, each server has been configured with the same sys passwords. The databases themselves were configured during installation (so the setups are about as basic as you can get.)

Now, I've done all sorts of research into how to do this. I've found plenty of good sources, but they seem to all have differences in the details.Here's what I've done so far:

- The TNSNames.ora file on each server has an entry for 'src' and 'dest' (sourca and destination) respectively
- I created an entry named 'SID_LIST_LISTENER' in the listner.ora file on the source machine. However, should the sid_name in this entry refer to the source or destination machine? Or does this listener entry belong on the destination machine instead?
- A lot of the examples require the setup of a new password file and spfile. Are these entries necessary if I'm using the same file structures/user names/etc. on both servers?

View 2 Replies View Related

Database Duplication Via RMAN

Nov 11, 2011

I have 2 identical databases set up as follows:

- Version: Oracle 11gR2 (64 bit)
- OS: Windows Server 2008
- File System: ASM (with GRID Infrastructure)

Both instances are virtually identical... Same directory structures, same SYS passwords. The only thing that differs is the instance name (one is ABC, the other is XYZ).

Now, both databases are up and running, both have users on them, and both can accept remote connections. What I want to do is set up a very simple 'copy' system so that everything can be extracted (via RMAN) from the first database, and replace the database on the second. (Then, the user can log into XYZ with the same usernames/passwords they used on ABC.)

Here's what I'm doing so far:

On the 'source' database (ABC) I run RMAN as follows:
rman target / nocatalog
configure controlfile autobackup format for device type disk to 'C:\temp\CF_%F';
configure channel device type disk format 'C:\temp\bkp_%U';
run {backup database; backup archivelog all; }

Now, I'm not completely sure of what to do on the 'destination' database. I've seen multiple web pages with instructions that require the creation of a new instance using 'oradim' and the creation of a new password with 'orapwd'. However, is that necessary if I have the same sys password on both databases, and I want to use the same XYZ instance name on the destination machine?

Would it work if I used 'delete database' on the destination, and then used the RMAN 'Duplicate database to XYZ backup location 'C:\temp\'? Or does it HAVE to be a new instance created with oradim?

And if I DO have to use oradim to create a new instance, will the data be accessible through XYZ too?

View 2 Replies View Related

RMAN Duplication Of Active Database

Aug 5, 2011

I have issue with regards to duplication of an active (prod) database to a test database. This is my sql run by RMAN:

SPOOL MSGLOG to '/proddb/u01/app/dupe.log';

CONNECT target sys/oracle;
CONNECT auxiliary sys/oracle@MWTEST;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;
RUN {
duplicate target database to MWTEST from active database;
}
CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE;

It stops however in the middle and wouldn't continue. There is still huge space for the test database (3x the current size of prod database).

View 5 Replies View Related

Backup & Recovery :: RAC Database Duplication Using RMAN?

Jan 27, 2011

I have done many duplication before in sinlge instance databases using a backup tool and rman catalog. At the moment i was trying to do a RAC database duplication and facing some issues. For this i was doing a testing on my 1-node RAC. Primary and duplicated database is on the same Host and oracle version is 10.2.0.3. I perfomed following steps:

1.Created a DUPL database using DBCA.

2.Created a pfile using spfile.

3.Dropped all the datafiles, controlfiles and redo log files.

4.Started the database in nomount using pfile.

5.Disable cluster related parameters in pfile.

6.Took a full backup of the MAIN database with archivelog on disk.

6.Duplicate the database and it is done successfully.

7.Shutdown the instance and enabled cluster parameters.

8.Start instance using SRVCTL fails with error CRS-0215: Could not start resource 'ora.DUPL.DUPL1.inst'

But if start the instance using sqlplus it comes up nicely. There is not much information in alert log files.

View 13 Replies View Related

Backup & Recovery :: 11g Active Database Duplication?

Nov 2, 2011

I'm trying to set up active database duplication between 2 Oracle 11g servers.

Both servers were set up with identical configurations (same directory structures, file systems, SIDs, and sys passwords.) Both oracle instances were created at the time of software installation.

Here is how things are configured:
- Version: Ora11gR2
- Oracle service name: orcl
- File system: ASM
- OS: Windows Server 2008

I've done some research and found several sources giving instructions on how to set up active database duplication (including a blog engry by rajabaskar on this site), but each site seems to have different details.

So, here's what I have so far:

- Set up entries in each TNSNames file... each has an entry 'src' and 'dst' (for source and destination)

- A new listener has been added on the source machine

- on the destination machine, run the 'oradm' to create a new SID. However, is this really necessary? Since the service names are already the same

- I'm also supposed to create a password file on the destination machine using orapwd. Again, is this necessary, if I'm using the same passwords on both machines?

Am I on the right track? Should I have created an actual database on the destination machine or should I have started with just the software installed?

View 1 Replies View Related

Recovery Manager (RMAN) :: Perform Active Database Duplication?

Sep 11, 2012

I like to duplicate the database DATABASEA to DATABASEB and need to be run in same server. I tried to bounce the listener & databaseb instance multiple times but no lucky.

Step 1 : The instance DATABASEB is in Nomount stage

Step 2 :

==> tnsping DATABASEB
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 11-SEP-2012 07:36:54
Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = client )(PORT = 1521)) (CONNECT_DATA = ( SERVER = DEDICATED) (SERVICE_NAME = DATABASEB)(UR=A)))
OK (10 msec)

Step 3 :

==> rman target sys/*****@DATABASEA auxiliary sys/********@DATABASEB
Recovery Manager: Release 11.2.0.2.0 - Production on Tue Sep 11 07:37:50 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DATABASEA (DBID=1723462779)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

[code]...

View 9 Replies View Related

SQL & PL/SQL :: Delete Duplication In A Table

Jul 7, 2011

I want to delete the duplicate rows in a table. there is no column which can be used to differentiate between the rows.

SELECT column_name1
FROM [table]
WHERE column_name2 = cond
GROUP BY column_name1
HAVING COUNT (column_name1) > 1

from the above query i can find the duplication in the table and can delete through it. But what i want one record of each duplication not to be deleted most probably the record added last to the table.

View 13 Replies View Related

RMAN ASM Duplication Orphan Files?

Jun 10, 2011

I use the following script to duplicate a target to an auxiliary instance. This works fine once.

However if I run it a second time it will create a new set of datafiles leaving the original files in place taking up space.

Is there something that I can put in the script that will stop this happening.

I know I could probably put a "set newname for datafile" clause for each datafile in the target database, but this makes the script over complicated and I would like to keep it as generic as possible.

DUPLICATE TARGET DATABASE TO dupdb
until time "TO_DATE('07/06/2011 07:25','DD/MM/YYYY HH24:MI')"
LOGFILE GROUP 1 ('+DATA') SIZE 50M,
GROUP 2 ('+DATA') SIZE 50M,
GROUP 3 ('+DATA') SIZE 50M,
GROUP 4 ('+DATA') SIZE 50M;

View 2 Replies View Related

Forms :: Avoid Duplication In Three Tables

Jan 31, 2013

I'm creating oracle form to allow the user to register a new record in a table, I want to check the duplication in Four tables! which means, the user is able to save the record if it's NOT already registered in the other four tables.By checking P_ID (user parameter). this is my

Declare
v_count number;
begin
select count(*) into v_count ---Checking the 1st table
from 1_table
where p1_id=:p_id;
if (v_count>0) then
message ('Duplicate');
[code]....

View 4 Replies View Related

Forms :: New Record With Same ID Inserted Every Time - Duplication

Mar 4, 2013

I have a form that used to enter new employees , if the employee ID already registerd then the user can ONLY update the information and NOT adding the same ID with new info.

int the ID item in when-validat-item trigger I put this code

begin

IF :SOURCE_CODE IS NULL THEN MESSAGE('PLEASE ENTER SOURCE CODE');
ELSE
declare --chg#13-3169 nada

[Code].....

in the save button the code is : commit;

The problem Is : a new record with same ID is inserted every time !! Duplication is happining

View 6 Replies View Related

Recovery Manager (RMAN) :: Backup-Based Duplication Without A Target And A Recovery Catalog Connection?

Sep 30, 2012

how to duplicate it on oracle 11g xe windows 2003

i have read from documentation but getting some error.

in last

E:Documents and SettingsAdministrator>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 30 03:03:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect auxiliary sys/12
connected to auxiliary database: XE (not mounted)
RMAN>
RMAN> DUPLICATE DATABASE TO xe

[code]...

Backup-Based Duplication Without a Target and a Recovery Catalog Connection?

View 6 Replies View Related

Data Guard :: Apply Patches On Oracle Database With Logical Standby Database?

Apr 22, 2011

I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.

I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?

1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site

View 2 Replies View Related

Convert Oracle Database (schema Data) To Postgresql Database

Oct 11, 2012

i want to convert oracle database(schema data) to postgresql database

which tool would be best and url to download and steps to convert from one database to another ?

View 2 Replies View Related

Forms :: Use MS Sql Server Database With 6i Without Oracle Database Install

Feb 6, 2010

Can we use M.S Sql Server Database with Forms 6i with out oracle database install.

View 1 Replies View Related

Migrate MySQL Database Into Oracle Database?

Sep 11, 2003

I'm trying to migrate a mySQL database into an Oracle database.

View 7 Replies View Related

Networking And Gateways :: Oracle Database Gateway Installing On Oracle 8?

May 17, 2011

But i do a lot of work-arounds to make sure the installation does not make corrupt my OracleAgent,OracleService and OracleDataGatherer. If i just let the installation do its thing i have problems with my libraries, and can't start anything.

The errors are : Procedure entry point 'BlaBla' could not be located in the Dynamic Link library 'AnyName'.

I notice that i have 2 versions of the libraries in OracleHomeBIN (one version 8, one version 11). The programs that start the OracleAgent,Service and DataGatherer call the old libraries but expect to find values that can be found only in new libraries.

View 1 Replies View Related

PL/SQL :: Oracle SQL Template To Create Re-usable DDL / DML Scripts For Oracle Database

Jun 13, 2012

I have a requirement to put together a Oracle SQL template to create re-usable DDL/DML Scripts for Oracle databases.Only the Oracle DBA will be running the scripts so permissions is not an issue.

The workflow for any DDL is as follows:-

1) New Table

a. Check if the table exists from the system/admin views.

b. If table exists then give message "Table Exists"

c. If table does not exist then execute DDL code

2) Add Column

a. Check if Column exists for a given table from system/admin views

b. If column exists in the specified table,

b1. backup table.

b2. alter table to make changes to the column

b3. verify data or execute dml script convert from backup to the new change.

c. If Column does not exist

c1. backup table

c2. alter table to add column

c3. execute dml to populate column with default value.

The DML scripts are for populating base tables with data required for business operations.

3) Add new row

a. check if row exists by comparing old values of each column with new values to be added for the new record.

b. If exists, give message row exists

c. If not exists, add new record.

4) Update existing record (We have createtime columns in these tables so changes can be tracked)

a. check if row exists using primary key.

b. If exists,

b1. deactivate the record using the "active" column of the table

b2. Add new record with the changes required.

c. If does not exist, add new record with the changes required.

View 17 Replies View Related

Oracle 11g - Global Database Name Value?

Sep 22, 2011

When I installed Oracle 11.g I set 'GlobalDataBaseName' ("orcl.net").SID was "orcl". from where can I invoke 'GlobalDataBaseName' value ?

View 1 Replies View Related

Database Redundancy With Oracle SE ONE?

Nov 5, 2012

I'd like to get database redundancy with Oracle Standard Edition One. currently have one physical database server and are considering getting a second physical database server.

What's the best way to achieve that without going to Oracle Standard Edition using RAC?

View 7 Replies View Related

Importing Of Oracle Database?

May 30, 2011

Actually I am using Oracle 9i in Windows Operating System. Now I want to move to my entire Oracle Database to Oracle 11g in Linux version. What are all the correct steps to do this. I am not a DBA.

View 1 Replies View Related

Oracle Database Overloaded

Mar 5, 2011

In my Production server, Database size increased very high due do to logs generated in a table called "Process Activity". And the table size is 50GB.

We deleted the data from the table "Process Activity". And still the table size and Database size remain same. Space not released by DB. One of my friend, recommended me to sync the oracle DB to release the space. how to synchronize the DB to release space.

View 3 Replies View Related

11.2 - How To Mount Oracle Database

Jun 10, 2013

While I was trying to configure an Oracle DB called "NW6" using the Database Configuration Assistant, I have Oracle 11.2 database installed on a Windows 2008 Server, the configuration wizard thrown an error : ORA-01507:database not mounted

So I am not able to successfully complete the DB configuration. Also I tried to test the service using the net configuration assistant, it throws an error: ORA-27101 shared memory realm does not exist.

View 9 Replies View Related

Download Oracle Database 10g

Aug 3, 2012

I need download the Oracle 10g to do some migration tests, but isn't not available in oracle website.

View 1 Replies View Related

Oracle 9i With PHP - Connectivity To Database

May 2, 2007

I would like to develop a system with Oracle 9i as the database and PHP 4/5 as the front end. I am not able to establish the connectivity to the database. What should I do now ?

View 3 Replies View Related

SQL & PL/SQL :: Sending SMS Through Oracle Database

Sep 16, 2006

I have a Database of My all customers Mobile Nos I want to send SMS to all customer from Oracle Database using Pl/SQL or any inbuilt Oracle Package, if available or through Oracle forms

How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed .

View 7 Replies View Related

SQL & PL/SQL :: How To Insert PDF Into Oracle Database

Mar 8, 2013

how can i insert .pdf file into my oracle database.

insert statement how can i insert this pdf file into my oracle database using insert statement.

View 24 Replies View Related

ORACLE - While Connecting To Database?

Dec 8, 2010

I am building the Oracle on RHEL 5(on Virtual machine with fixed disk space). I could install, after configuring and tried to connect to the database using "sqlplus system" on the command prompt(logged in as root), I get the following error message:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

View 2 Replies View Related

Replicate Oracle XE Database In 10G?

Mar 23, 2007

I want to replicate my Oracle XE database in Oracle 10G. Is their a 'simple' way to do that? I know that XE does not have server backup.

View 2 Replies View Related







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