Reg :: Cloning Of Database?

Sep 23, 2013

Oracle 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


ADVERTISEMENT

Cloning Database Strategy

Aug 23, 2012

i 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 ?

View 8 Replies View Related

Oracle Database Cloning From ASM To Non-ASM

Jan 23, 2013

I have to do oracle database cloning from asm to non-asm.

View 4 Replies View Related

RMAN - Cloning Database To Another Server

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

Backup & Recovery :: Cloning Database?

Jul 24, 2012

I'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'

View 15 Replies View Related

Procedure For Cloning Database On Same Machine / Server

Jul 19, 2012

Send me the procedure for cloning a database on the same machine / server .

View 1 Replies View Related

Database Cloning Installed On ZFS Storage Appliance

May 14, 2013

I 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 ?

View 0 Replies View Related

Server Administration :: Database Cold Cloning

Apr 5, 2013

I 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>

View 4 Replies View Related

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

View 2 Replies View Related

RMAN :: Sanity Backup - Cloning Database?

May 5, 2013

oracle 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?

View 7 Replies View Related

Backup & Recovery :: Query On Cloning Database Across Platform

Mar 16, 2011

As 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

View 4 Replies View Related

Backup & Recovery :: Manual Cloning Of Oracle 10g Database

Nov 29, 2011

I need the step by step procedure for the cloning of database in linux environment .

View 2 Replies View Related

Backup & Recovery :: Cloning Of Database On Standalone PC Having Oracle 10g On Windows 7

Mar 20, 2013

I 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.

View 4 Replies View Related

Backup & Recovery :: ORA-19870 / Error Reading Backup Piece During Database Cloning

Mar 15, 2011

I am trying to clone a database on another server with different direcory structure. So that path on the source db server are /u04 whereas on on target db server it would be /u03.

Since this I am testing it on small database initially I have kept all datafiles, backup and archivelogs at /u04 and /u03 on the source and target db servers respectively Now I have copied the backups from source db server to target and since path is changed, I cataloged it

However during restore I am getting

Quote:ORA-19870: error reading backup

Here are the session details

RMAN> catalog start with '/u03/oradata/db7fra';
searching for all files that match the pattern /u03/oradata/db7fra
List of Files Unknown to the Database
=====================================
File Name: /u03/oradata/db7fra/DB7/archivelog/2011_03_15/o1_mf_1_16_6qyvpb3w_.arc
File Name: /u03/oradata/db7fra/DB7/backupset/2011_03_15/o1_mf_annnn_TAG20110315T123018_6qypyv5v_.bkp

[code].....

I have altered permissions on the backup files as well but of no use

oracle@dev-biz:/u03/oradata/db7fra/DB7/backupset/2011_03_15 $ls -ltr
total 545260
-rwxrwxrwx 1 oracle dba 12419072 Mar 15 13:52 o1_mf_ncsnf_TAG20110315T123008_6qypyrz2_.bkp
-rwxrwxrwx 1 oracle dba 3072 Mar 15 13:52 o1_mf_annnn_TAG20110315T125043_6qyr54to_.bkp
-rwxrwxrwx 1 oracle dba 426496 Mar 15 13:52 o1_mf_annnn_TAG20110315T125006_6qyr3zk4_.bkp
-rwxrwxrwx 1 oracle dba 14336 Mar 15 13:52 o1_mf_annnn_TAG20110315T123018_6qypyv5v_.bkp

[code].....

View 13 Replies View Related

ERP Is Running Slow After Cloning

Apr 22, 2012

We 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 View Related

RMAN Cloning From One Server To Another?

Jan 17, 2012

RMAN cloning from one server to another server.

View 2 Replies View Related

Getting Error After Oracle Software Cloning

Oct 4, 2013

I 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. 

View 3 Replies View Related

Server Administration :: Oracle Binary Cloning

Apr 19, 2011

To 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

View 6 Replies View Related

Backup & Recovery :: RMAN Cloning With Catalog?

Mar 3, 2012

New 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

View 1 Replies View Related

Real Application Clusters :: Oracle 11g ASM Under OEL 5.6 - How To Do Cloning

May 5, 2013

oracle 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

View 5 Replies View Related

RMAN :: CLONING By Offline Backup Location?

Jan 9, 2013

I 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.

View 4 Replies View Related

Backup & Recovery :: Duplicate Target RMAN Cloning?

May 3, 2013

1) 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]......

View 2 Replies View Related

RMAN :: Cloning Using Duplicate Command - Retain Conversion

Feb 7, 2013

While 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 Related

Recovery Manager (RMAN) :: Run Active Cloning From Target Server?

May 16, 2013

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
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?

View 5 Replies View Related

DBF File Size Changing After Cloning Same Schema From Different Machines In Oracle 11gR2

Jul 22, 2011

Our 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.

View 3 Replies View Related

Recovery Manager (RMAN) :: Active Cloning Fails With 06054 - Missing Log File?

May 15, 2013

Version 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.

View 5 Replies View Related

Secure Backup :: Difference Between Cold Backup And Cold Cloning

Oct 18, 2012

Difference between cold backup and cold cloning?

View 2 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

Data Guard :: Flashback Snapshot Standby Database Or New Primary Database After Failover?

Aug 30, 2013

If flashback is enable in physical standby database 1. If we failover at 11AM can I flash back NEW primary database to 6 AM ? 2. if I convert physically standby database to snapshot standby database at 11AM ,  Can I  flashback snapshot standby database to 6 AM and do some works on it (DML operations)  then   converting the snapshot standby database into physical standby database ?  

View 1 Replies View Related

Streams :: Apply Archivelog / Generated Before Reset-log Of Source Database In Destination Database

Feb 9, 2013

Database Version - 10.2.0.4.0
OS - Red Hat Linux

We have configured oracle one way stream between two databases. Source database is capturing the changes (No downstream configured). Configuration was working fine but destination database was lagging behind very much i.e about 15 days behind the source database. We are ok with this but the problem is now that , as per client request we have restored previous backup and open the database with resetlog option in source database. After resetlog , archivelog sequence has been changed and stream is not working.

Can I apply the previous archivelog (before resetlog archivelogs ) in destination database anyway.Source database is a production database.

View 1 Replies View Related







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