I will be duplicating my production database back to a few weeks ago on my test server, to retrieve certain data. I am running 11g standard edition, not using a recovery catalog.
Below are the basic steps I plan to take in a nutshell.
1. Copy the backup files to the test system
2. In the rman run block (on the test server)
A. Set newname for each of the datafiles and tempfiles (don't have many files)
B. Duplicate command to point in time, specifying backup location and no filename check.
We plan to move the database to a new host with much more RAM, CPU. The new database server will have exactly the same OS version, Kernel version and the same version of database / grid standalone (ASM). I will have to install OS, Database software, Grid Standalone on the new server.
The current version of the database is 11.2.0.3.0 Enterprise Edition and the OS version is Oracle Enterprise Linux 6.3. However, we plan to use the same disks (ASM disks). I believe I don't need to use RMAN to do the migration, Is it correct?
the strange thing is "lkinstrdmetdev" is the wrong name(sid is rdmetdev), and the file does not exist in the FS too. the correct file name should be "lkrdmetdev" and i've deleted this file from the directory. I did not do any changes. and no any oralce processes running while i started up the oracle instance.
Thu Feb 14 09:25:20 EST 2013 sculkget: failed to lock /u01/app/oracle/product/10.2/dbs/lkinstrdmetdev exclusive Thu Feb 14 09:25:20 EST 2013 sculkget: lock held by PID: 272600512 Thu Feb 14 09:25:20 EST 2013 Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Thu Feb 14 09:25:20 EST 2013 Failed to acquire instance startup/shutdown serialization primitive [code]....
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/ shutdown serialization primitive
I have 2 server install oracle : server 1 and server 2
server 1 run database DB01
i use rman backup DB01 ( this command : BACKUP FULL DATABASE PLUS ARCHIVELOG DELETE INPUT; ) and move ( The database backup pieces , Controlfile backup piece, The parameter file i.e init.ora file) to server 2 .
At server 2 :
After start database with init.ora file and restore controlfile error :
RMAN-03002: failure of restore command at 07/22/2011 02:56:04 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
i am having database in server and i have to run my web application in client machine. how to set the connection of server database in web.config file.
Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.
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.
I want to duplicate a prod database in to a dev db.I am using catalog database to connect to target and auxiliary datbase.I copied all backupsets to the local disk on Dev env in the correct path.For RMAN duplicate ,does the backuppeices need to be present on PROD filesystem as well or just DEV filesystem or both.
I try to use rman duplicate database to bring entire databse form Windows XP system to another Windows XP. I have been trying to use rmain duplicate database without success.
I failed on "startup force nomount......". The system always prompt me an error as "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" and following by TNSLSNR.exe has encountered a problem and need to be close......"
I have tried to re-install the oracle multiple times and failed at the same problem as above. So, I am thinking of using imp and exp to do the work. Is it possible? If yes, how to do it.
i am trying to duplicate database on another oracle server. i am getting following errors when i use command in rman orapwd was created on original /source/ db and transferred to destination server.
rman auxiliary sys/pwd@ORA
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 2 02:37:51 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to auxiliary database: ORA (not mounted) RMAN> duplicate database to "ora" backup location "O:ackup"; Starting Duplicate Db at 02-OCT-12
contents of Memory Script: { sql clone "create spfile from memory"; } executing Memory Script
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 10/02/2012 02:38:36 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
RMAN>
when i try to reconnect to rman it throws:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
i have to startup in nomount again
ORARCLE_SID is set to ora
backup of db was created from source db by:
RMAN> run{ 2> configure controlfile autobackup format for device type disk to 'd:/backup/%F'; 3> configure controlfile autobackup on; 4> allocate channel d1 type disk; 5> backup tag FULL_DB format 'd:/backup/db_%t_%s.bk' (database); 6> release channel d1; 7> }
i'm trying to duplicate my RAC database with ASM and 2 nodes to a single node, non ASM with rman duplicate database for standby with active database on windows. The problem is i dont know how to remove RAC configuration when duplicating the database.
Here is the procedure:
On standby i've: - installed database software, - configured listener and tnsnames, - added instance service (oradim -new -sid STANDBY -intpwd PASSWORD -startmode M), - configured initora (with only db_name = STANDBY) - configured orapwd file - startup nomount
on RAC node1:
rman target sys/PASSWORD@RAC connected to target database RMAN> connect auxiliary sys/password@STANDBY connected to auxiliary database: STANDBY (not mounted)
now for the duplicate command:
RMAN> duplicate target database 2> for standby 3> from active database 4> spfile 5> parameter_value_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY' 6> set db_unique_name='STANDBY' 7> set log_file_name_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY' 8> set db_file_name_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY';
i have tried adding this parameter - set cluster_database='false' but no luck.
I have Oracle 10.2.0.4 database on HP-UX. I want to move this to same version of database on windows on different server.I want everything to be same on both databases on different servers(names of databases can change).I installed oracle on windows box and created a database 10.2.0.4. Few questions
1) What is the best method to recreate complete database on another machine.In my case move 10.2.0.4 database on HP-UX to 10.2.0.4 database on windows. Is there a better method other than dpexp/dpimp?
2) When I created database 10.2.0.4 on windows it created sys, system and other default users. If I get a full export of 10.2.0.4 database on HP-UX it also contains sys, system and other default users. My question is, will there be any issue when I import full mode into 10.2.0.4 database on windows?
3) If I do with dpexp/dpimp what are the best parameters to be used?
Previously it is working fine but today when i am trying to duplicate a database using rman not getting exactly error but the o/p is as below
C:Usersdbadmin>rman target sys/tiger@na Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 27 15:33:33 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: NA (DBID=1572981579) RMAN> connect auxiliary sys/tiger@da connected to auxiliary database: NOIDA (DBID=1572981579, not open)
It is correct that the rman is connected to the db with name na but not with db da Previously i am able to connect both the instance.
I'm running the following and getting access denied errors.What do I need to do to make the recovery files available of the duplicate host?I cataloged the backupsets at the network path of where they are, I don't have space on the drive for the backupset and the restored database once it's done.
*Results filtered for length on duplicate lines
RMAN> DUPLICATE TARGET DATABASE TO Test 2> DEVICE TYPE DISK PFILE='D:ORACLEORA102DATABASEINITTEST.ORA'; Starting Duplicate Db at 02-AUG-13 released channel: ORA_AUX_DISK_1 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=155 devtype=DISK
contents of Memory Script:
{ set until scn 2875467028; set newname for clone datafile 1 to new; set newname for clone datafile 2 to new; ...TRIMMED
Oracle 10.2.0.5Linux 5I am creating a duplicate database using RMAN based on Oracle's documentation. I was successful up to running the duplicate command.Here is my command:DUPLICATE TARGET DATABASE vlab pfile='/<complete path of pfile>'; When I run the command, it tries to read from the backup files on production database - which is on anotehr node.Before then, I had backup piece copied to the node with the duplicate database.I ran this command to catalog the backup piece:catalog start with '/<complete path to backuppiece>'Error: no files to be unknown to the database On the other hand, when I run the command without cataloging the backuppiece, I get this error:
Partial view of error- restoring datafile 00021 to /oraappl/pca/vptch/vlabdata/staff101.dbf restoring datafile 00022 to /oraappl/pca/vptch/vlabdata/staff201.dbf restoring datafile 00023 to /oraappl/pca/vptch/vlabdata/tools01.dbf restoring datafile 00024 to /oraappl/pca/vptch/vlabdata/vol01.dbf restoring datafile 00025 to /oraappl/pca/vptch/vlabdata/volsup101.dbf restoring datafile 00026 to /oraappl/pca/vptch/vlabdata/volsup201.dbf channel ORA_AUX_DISK_1: reading from backup piece /oraappl/pca/backups/weekly/vproddat ackupset/2013_08_27/o1_mf_nnndf_TAG20130827T083750_91s7dz0r_.bkp ORA-19870: error reading backup piece /oraappl/pca/backups/weekly/vproddata/rman/VPROD 3_08_27/o1_mf_nnndf_TAG20130827T083750_91s7dz0r_.bkp ORA-19505: failed to identify file "/oraappl/pca/backups/weekly/vproddata/rman/VPROD/b
I have a RUN file within a script to duplicate a database. As part of this RUN file I also run the command configure controlfile autobackup off; as part of this RUN file. However, this command has turned off backup of the control file on the AUXILLARY database (i.e. production) as well as the TARGET database (test). Is this supposed to happen?
My run file is:
rman TARGET sys/XXXX@${DB}-SOURCE AUXILIARY / RUN { allocate AUXILIARY channel a1 type disk; allocate AUXILIARY channel a2 type disk; allocate AUXILIARY channel a3 type disk; allocate AUXILIARY channel a4 type disk;
I have oracle 11.2.0.3.0 in Windows 2008 server R2 64 bit version. I have installed database ASMDB with ASM ... Now i have another one machine , I want to clone my database in that machine with Non ASM file system .. Can any one tell me step by step document to do it ?
Can i keep the database name as ASMDB in another Machine ?
We are going to test migration of g10 to g11. To reduce maintenance of configuration we want to install new Oracle on the same server and start on the same port with the same SID. To achieve that we are going to configure new Oracle on different IP and hostname (managed by DNS, whatever). So listener will be configured like for different servers with identical SIDs.
I want to host name and max logon day from the below query But host name not belongs to start with 'IRS%' and 'EMEAUKIMIV00023828'.
My question is How to handle the backslash in oracle 8i and also check the below query is ok or not,
select host, max(logon_day) from ( select host,logon_day from system.stats$user_log where host not like 'IRS%' AND not in ('EMEAUKIMIV00023828')) group by host;
Here i have three tier application. I want to know it host name from sid or sqlid . I want to know which query run on which host. Because i have one user from application to database. So i want to know which query consume more time on which host ?
I've got a problem when I use the HOST procedure to work with DOS Prompt. When I access the DOS Prompt via Oracle Forms HOST Procedure, the name of files and folders got limited by 8 chars plus extension. Lets suppose I want to copy a file and the file name is my_image.jpg. What I have to do is:
HOST('copy MY_IMA~1 C:TEMPIMAGE01');
I guess it sucks cause the function GET_FILE_NAME give me the filename as my_image.jpg. Do I have to convert the filename every time?
