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
ADVERTISEMENT
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
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
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
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
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
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
View Related
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
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
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
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
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
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
Jul 25, 2012
I tried to clone a 2 node rac database to single instance non rac database using existing backup. I have not used connectivity to target or catalog. rman duplicate finished with below messages:
rman auxiliary sys/******@dbracdup
RMAN> duplicate database to dbrac spfile backup location '/oracle/backup';
...
...
Finished recover at 25-JUL-12
Segmentation fault
And the database was in mount stage, and when i tried to open database it failed with below error:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-19838: Cannot use this control file to open database .
View 4 Replies
View Related
Dec 21, 2012
creating the standby database from Active database using RMAN and getting the below issue after i executed the duplicate command.
Version of Database:11g(11.2.0.1.0)
Operating System:Linux 5
Error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/21/2012 17:26:52
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[code]....
provide any work arounds to proceed further in creating the standby database.
View 1 Replies
View Related
Mar 14, 2012
How one should know whether RMAN is using target database control file or using separate catalog database. Also what one should do if he dont have catalog users credentials.
View 3 Replies
View Related
Aug 23, 2010
I have failed to duplicate target db for standby from active db using spfile with the following errors:
RMAN-03009: failure of backup command on prim1 channel at 08/11/2010 05:25:09
ORA-19558: error de-allocating device
ORA-19557: device error, device type: DISK, device name:
ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
[Code].....
The script has successfully created on standby db all controlfiles and also has copied 2 data files DATA01.DBF and DATA02.DBF into the correct location. Then the errors above kicked in and stopped the rman dup process.
View 4 Replies
View Related
Mar 4, 2013
I have created database with 11.2.0.3 in RHEL 5. I have catalog database(RMAN) with version 10.2.0.1 and 5 databases with different versions(10.2.0.1,10.2.0.3,10.2.0.5) registered with this catalog databases.
Now I want to register the 11.2.0.3 database with catalog (RMAN) database.
Am getting error while I register :
#rman target / catalog=rman/rman@rman
connected to target database: TEST (DBID=12345678)
connected to recovery catalog database
RMAN> register database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 03/04/2013 10:27:12
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 1: ORA-04023: Object RMAN.DBMS_RCVCAT could not be validated or authorized
View 9 Replies
View Related
Jul 19, 2010
I would like to know how to migrate the database from linux to windows using RMAN.
View 4 Replies
View Related
May 15, 2010
Through RMAN i have to connect to two databases having same name but the databases are at two different nodes.Can RMAN recognise the 2 databases.If yes how? I want to know the command.
View 1 Replies
View Related
Feb 23, 2011
Can I copy rman to use a different database with a different ID
View 6 Replies
View Related
Feb 14, 2012
Using RMAN to clone production DB to another server. After the recover database , rman keeps asking the archivelog which is not available.
I had taken the RMAN full backup (backup database plus archivelog) and restore the same with mentioned steps in the below link.
[URL] ...........
But during the recover database statment not getting completed instead its keep asking archive log file which is not existing.
HOw to open the database.
===error msg====
dbf thread=1 sequence=38
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/09/2012 05:45:32
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/u01/app/oracle/product/10.2.0/db_1/dbs/arch1_37_772998244.dbf'
ORA-00310: archived log contains sequence 37; sequence 38 required
ORA-00334: archived log: '/u01/app/oracle/product/10.2.0/db_1/dbs/arch1_37_772998244.dbf'
View 1 Replies
View Related
Oct 24, 2012
I have a 11.2.0.1 database windows 2008 server. I have RMAN with nocatalog. I need to take daily RMAN backup of database at 6 PM.
I want to schedule this RMAN backup to run automatically. I want to run this backup when I am not logged on.
View 2 Replies
View Related
Oct 19, 2011
How to create a standby database with and without rman......?
View 3 Replies
View Related
Dec 19, 2012
We have Oracle 10.2.0.3 database installed on Itanium server.
1. One day we found some packages got invalid & not compiling at all with error – ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [].
2. Then we successfully restored the database from old RMAN backup of previous date that caused this error.
3. After 2 days again we found the same error in alert_prd log - ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_STATS", line 19089 ], [], [], [], [], [], [], []
4. Then for testing we exported database using exp command & found 3 tables are not exporting because of data block corruption issue.
5. Then we truncated the data from all 3 tables and then able to export successfully.
6. After all this we manually run SYS.DMS_STATS job but found same error logged in prd_alert log.
This looks like, still database block corruption issue is there & we are unable to cure it 100% This is a production system & in very critical state now.
View 1 Replies
View Related
Nov 6, 2013
We have 11gR2 2 node RAC on Linux. ASM and OMF is used for database. The database on it is backed up using RMAN. We want to test the RMAN backup by restoring it to a new database on same server.
View 5 Replies
View Related
Aug 6, 2012
I just duplicate my PRODUCTION database to TEST database (11.2.0.1 both) on windows 7.
I just create a backup from PRODUCTION:
RMAN> backup full database format ='C:Usersmy_usermiBBDDflash_recovery_are aTESTdatabase_%U';and controlfile backup:
RMAN> backup current controlfile format='C:Usersmy_usermiBBDDflash_recover y_areaTESTCONTROL_FILE_%U';now i'm trying to restore this backup into TEST with this script:
RMAN
CONNECT TARGET /
STARTUP NOMOUNT;
SET DBID 486238190; #DBID of TEST database
RUN
[Code]....
but i'm having a similar error when i tried to duplicate both databases ( post -->Error duplicate databases fallo de la recuperaci¾n del medio fÝsico
canal liberado: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: fallo del comando recover en 08/06/2012 11:53:06
ORA-00283: recovery session canceled due to errors
RMAN-11003: fallo al analizar/ejecutar la sentencia SQL: alter database recover
if needed start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'C:USERSmy_userMIBBDDORADATAPRODUCTIONSYSTEM01. D BF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:USERSmy_userMIBBDDORADATAPRODUCTIONSYSTEM01.D BF'
Controlfile was restored correctly. what am I doing wrong?
View 23 Replies
View Related
Dec 6, 2012
I have a active data guard database which is copy of my production database. can i backup the active database using RMAN? The ADG is a read only and dont know, if RMAN can backup an read only database.
View 4 Replies
View Related
Sep 13, 2012
i was worked on oracle 11g.1, oracle data miner 11.1.0.4, sql developer 3.
unfortunately, after finishing my tables and models ,the hard disk damaged and was replaced with other.the oracle setup was not on system partition,it was on D:/ and i had windows backup for C, D partition. i restored oracle partition D which contains old oracle files and i installed oracle again but on partition F.
now....how can i restore tables and modules?
View 3 Replies
View Related
Nov 13, 2011
I am trying to refresh the validation database with the old production backup i.e. our requirement. I have given the rman script i have executed and the output error message amd the rman configuration setting. Plus in the next post ill post the current sucessfully running RMAN script for your reference.
rman TARGET sys/passwd@Production CATALOG rman_pmxp/rman@catlog AUXILIARY sys/passwd @validation
RMAN> show all
2> ;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'H:\backups\DB_Sunday_Backup\Prod_%d_%F.rman.ctl';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
[code]...
View 1 Replies
View Related