ERP Is Running Slow After Cloning
Apr 22, 2012We have done cloning of our ORACLE APPLICATION(11i),after that performance of ERP is getting slow (like fetching of data). What we can do to increase the performance.
View 1 Replies
ADVERTISEMENT
Reg :: Cloning Of Database?
Sep 23, 2013Oracle Database 11g 11.2.0.1 SE1 I have a production database server which is currently having about 1TB of data.I need to shift this server to a different location with minimum possible downtime. Which is the best option this?RMAN backup, or datapump export and import
View 11 Replies View RelatedCloning Database Strategy
Aug 23, 2012i have production database (1102.0.3.0) in Windows 2008 server R2 64 bit version . My database has some schemas which has partition tables and Db links and M views also .
Now my team lead asked me to setup the same environment(As cloning ) in testing environment also ... I have lots of options to create the same setup database using options like export/Import , data pump , hot backup and cold backup, Rman .
My doubt is which option will be best and optimal to achieve the same ?which approach i should proceed ?
RMAN Cloning From One Server To Another?
Jan 17, 2012RMAN cloning from one server to another server.
View 2 Replies View RelatedOracle Database Cloning From ASM To Non-ASM
Jan 23, 2013I have to do oracle database cloning from asm to non-asm.
View 4 Replies View RelatedRMAN - Cloning Database To Another Server
Feb 14, 2012Using 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'
Backup & Recovery :: Cloning Database?
Jul 24, 2012I've cloned one database manually and tried to open it only mounts and it comes up with this error:
"ORA-01589: must use RESETLOGS or NORESETLOGS option for database open"
Now, I issue "ALTER DATABASE OPEN RESETLOGS" but still getting following errors:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'F:ORACLEPRODUCT10.2.0ORADATAORALSYSTEM01.DBF'
Getting Error After Oracle Software Cloning
Oct 4, 2013I have a database(10.2.0.5.0) in solaris 10 , i simply take a tar backup of ORACLE_HOME andextracted them into another server (which is solaris 10 only) and linked the binaries after that when i connecting with sqlplus.
I am getting following error
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Oct 4 14:49:48 2013 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Enter user-name: /as sysdbald.so.1: oracle: fatal: libskgxp10.so: open failed: No such file or directoryERROR:ORA-12547: TNS:lost contact
I would like to tell that i have also oracle 11gr2 running on the server my oracle_base is same for both(10g 11g)but ORACLE_HOME is different.
Server Administration :: Oracle Binary Cloning
Apr 19, 2011To clone my oracle binary from host A to host B, in order to make up my DB in the host B
see bellow the necessary information:
source :
version host:HP-UX hostA B.11.11
db : Release 9.2.0.8.0
destination :
HP-UX hostB B.11.31
Backup & Recovery :: RMAN Cloning With Catalog?
Mar 3, 2012New to oracle FAQ. I'm interested in oracle, waiting to explore more Technic's in 10g with a proper guidance. Hope i'm in the right place.Here is my question.
I need steps for configuring rman cloning with catalog & without catalog.were in prod db the source is in /u01 & in auxiliary db the client want in /u05. how to do it. here i have recreate control file or not
Procedure For Cloning Database On Same Machine / Server
Jul 19, 2012Send me the procedure for cloning a database on the same machine / server .
View 1 Replies View RelatedDatabase Cloning Installed On ZFS Storage Appliance
May 14, 2013I have an update Oracle database 11g installed on ZFS Storage, and I need to make cloning for it. HCC feature is enabled.
How can I make this?
Using RMAN backup + ZFS Snapshot + ZFS Cloning ?
Real Application Clusters :: Oracle 11g ASM Under OEL 5.6 - How To Do Cloning
May 5, 2013oracle 11g ASM RAC under OEL 5.6 . i just want to do a cloning so first i create cloning of my oracle home and then i create pfile and i get this error
SQL> startup nomount;
ORA-29702: error occurred in Cluster Group Service operation
SQL> exiti google it , i found this issue is with relink RAC binaries due to the souce database is RAC and destination is not
[oracle@backuptest ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@backuptest lib]$ make -f ins_rdbms.mk rac_off
bash: make: command not found
RMAN :: CLONING By Offline Backup Location?
Jan 9, 2013I am doing a cloning of DB 11.1.0 from PROD to TEST but
os RHEL 5.5
Click to add to Favorites RMAN 11GR2 : DUPLICATE WITHOUT CONNECTING TO TARGET DATABASE [ID 874352.1]
initv11dup.ora
------------
db_name=v11dup
db_unique_name=v11dup
db_recovery_file_dest='/recovery_area'
[code]..
is not working for same SID on the target database.it is asking for a target name.
Server Administration :: Database Cold Cloning
Apr 5, 2013I am trying to perform cold cloning at my home pc. when i am trying to create control file , i got this error.
SQL> CREATE CONTROLFILE SET DATABASE "fclone" RESETLOGS FORCE LOGGING NOARCHIVEL
OG
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 5
4 MAXDATAFILES 10
[code].......
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 12800 (blocks), but should match header 74112
ORA-01110: data file 2: 'C:appIndraoradatafclonesysaux01.dbf'
SQL>
Cloning Database Through RMAN On Personal Machine
Jul 19, 2012 i have started cloning the database thru RMAN on my personal machine .the problem now is the database which i tried to clone and the database for which i was doing this task both are not working.I tried changing the database name and log file name using the parameters
db_file_name_convert=
log_file_name_convert=
the main database files are on disk1 and the clone database files are on disk2...i have restored the controlfile by command
>alter database recover using backup controlfile ; after some time its giving cannot alter and giving message that system datafile needs recovery even i tried
> alter database recover automatic not worked then i used the command
>> alter database recover using backup controlife until cancel;it gave message saying change generated so i cancelled the recovery and tried to open the database using RESETLOGS even now its giving the message SYSTEM file needs media recovery
RMAN :: Sanity Backup - Cloning Database?
May 5, 2013oracle 11g ASM RAC under OEL 5.6
i have a task to do do a sanity backup just to check the backup is recoverable or not , but i failed to install the agent in my server due to we have a HP DATA Protector for a backup and my manager told me i need to take the backup from HDP not as i always do take the backup on disk and then move this backup on test server and do a task cloning ,i do the cloning by rman but the backup on tape drive , i mean by rman open a channel to take the backup from PROD to TEST?
Backup & Recovery :: Query On Cloning Database Across Platform
Mar 16, 2011As I understand we can't clone database across platform using Rman, as Rman backup taken on say Unix is useless to be recovered on Windows. Though I think of Export and Import, will copying the datafiles, logfiles, controlfile will serve purpose for cloning across platform?
Note that I do not mean Transportable tablespace here. Only copying cold backup across platform
Backup & Recovery :: Duplicate Target RMAN Cloning?
May 3, 20131) have taken backup at target side.
2) through SCP, transferred all the file to auxiliary side.
3) Ran the duplicate command at auxiliary side.
After running the command, i got the below error.
hish@localhost db_1]$ rman target sys/oracle@suman auxiliary /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 12 09:13:43 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SUMAN (DBID=3778352561)
connected to auxiliary database: ASHISH (not mounted)
[code]......
Backup & Recovery :: Manual Cloning Of Oracle 10g Database
Nov 29, 2011I need the step by step procedure for the cloning of database in linux environment .
View 2 Replies View RelatedRMAN :: Cloning Using Duplicate Command - Retain Conversion
Feb 7, 2013While cloning using RMAN DUPLICATE command, one can convert all files from various locations to new locations by using DB_FILE_NAME_CONVERT. One can also retain the same locations with no conversion by using NOFILENAMECHECK. My question is what if I want to convert some, and not convert others?
View 3 Replies View RelatedRecovery Manager (RMAN) :: Run Active Cloning From Target Server?
May 16, 2013O.S Version HP-UX B.11.31 U ia64
Oracle DB Version 11.2.0.3.0
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Storage : ASM Diskgroups
-------------------------------------------------------------------------------------------------------------------------------------
I am new to Oracle, like to get clarified on below;
1. From where can we run the RMAN Clone script?
Source DB : PRDDB HOST: PRDHOST
Destination DB: DUPDB HOST: DEVHOST
Are there any constraints on running the RMAN Script from the Source DB Host - PRDHOST?
If I am running it from PRDHOST, do I have to have the initdupdb.ora available on PRDHOST?
What are advantages and disadvantages on running the script on Source & Destination Host?
Backup & Recovery :: Cloning Of Database On Standalone PC Having Oracle 10g On Windows 7
Mar 20, 2013I want to do cloning of a database on my standalone pc having oracle 10g on windows 7. PC is P4 with 2GB RAM.
The database is installed on my pc and i want to clone it on the same pc.
DBF File Size Changing After Cloning Same Schema From Different Machines In Oracle 11gR2
Jul 22, 2011Our product uses Oracle11gR1 and in new release we are going to use Oracle11gR2. For this we are performing following steps:
(1) Install Oracle11gR2 on a machine where our product (Oracle11gR1) is already installed.
(2)Upgrade Oracle11gR1 schema to Oracle11gR2.
(3)For using upgraded schema in our product installer we create clone of upgraded schema.
(4)For creating clone we are using Oracle11gR2 DBCA utility.
(5) Clone files are successfully created (DBC, CTL, DBF).
Now we performed same steps from another machine and DBF file size changed very much. On one machine it was 89 MB and on second machine it was 150 MB. There is no different in schema and both machines are Windows 7 machines.
Tor educe size of schema we tried different space reclamation commands but size is not changing.
Recovery Manager (RMAN) :: Active Cloning Fails With 06054 - Missing Log File?
May 15, 2013Version Details:
O.S Version HP-UX B.11.31 U ia64
Oracle DB Version 11.2.0.3.0
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Scenario :
Using RMAN Active cloning to duplicate a RAC database from Production to Development environment.
Problem:
At the end of the cloning the below errors are reported;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
[code]...
How to prevent the error of RMAN-06054: media recovery requesting unknown archived log for thread with sequence and starting SCN of while performing the RMAN Active Cloning? I do NOT want to use UNTIL clause.
Slow Insertion In Particular TABLE
Apr 17, 2012The issue is slow insertion in particular table(i.e A Table) it means insertion in all other tables(i.e B, C, D tables) in same schema is going properly but only when i am trying to insert in one particular table(i.e A table) in same schema it takes long time to complete insertion. Daily insertion is 6000 rows.
I have check all the details like Tablespace size, Analyzing of table, Analyzing of indexes and all. There is no any error alertlog file.
10.2.0.3 SqlPlus DB Connection Slow?
May 16, 2007We have two database instances on the same server. One was left at 9.2.0.7 and one was upgraded to 10.2.0.3. Connecting externally (sqlplus '/as sysdba') to the 9.2.0.7 database is lightning fast. Connecting externally to the 10.2.0.3 database is very slow, comparatively speakiing. This is on an IBM AIX-5L (64-bit) machine. We are using "tnsnames".
View 10 Replies View RelatedWhy Parametrized Cursor Is Slow
Aug 3, 2010WHY PARAMETRIZED CURSOR IS SLOW
I have the following query which is very slow
CURSOR c_party_ids (p_party_name VARCHAR2, p_party_type VARCHAR2, p_eval_active NUMBER)
IS
SELECT a.party_id,
a.party_type,
b.cust_account_id,
b.attribute17
[code].......
Slow Import For Oracle 11g R3 On IBM AIX 6.1
Sep 3, 2012I am migrating a oracle 9i database to 11g r3. I can only use imp. As the database is huge, I have split the exp dump by schemas. In my recent test, i have split the schema into 4 seperate threads to be imported into the new oracle11g database. The 4 thread of imp consist of almost similar sizes of schema (Eg thread 1 - Schema 1, 2 ,3. Thread 2 - Schema 4,5,6 etc)
All the dump files are in the same mount point. When i execute the import (4 threads) together, the total import timing is each thread is between 2.5 days to 3.5 days.
Then i proceed to try only 1 thread, only 2 hrs. So could this be a IO issue or oracle memory problem?
Specs
IBM AIX 6.1, 32GB RAM
Oracle
24GB AMM
Number of processes 500
Slow Performance On New 11gr2 Linux DB?
Aug 27, 2013we are busy updating one databasee from a windows platform 2003 oracle 10G to a linux and oracle 11r2
We exported/imported the data and it looks ok Explain plans look the same . but our heavy batches are twice slower than on the windows box ,the two top events are disk related, sequential and scattered reads there are 90% of the time of the batch job , i read some white paper and found that using ASM can be bad in some cases the same with the linux for this particular kind of scattered reads , i was just wondering if just changing the SGA to 10GB instead of 4GB to get more cache and speedup the things .