RMAN Cloning From One Server To Another?

Jan 17, 2012

RMAN cloning from one server to another server.

View 2 Replies


ADVERTISEMENT

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

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

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

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

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 :: 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) :: 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

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

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

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

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

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 :: How To Restore Backup From A Server To A Test Server

Feb 27, 2013

I have two Solaris 5.11 x86 64 bit servers. I need to be able to copy the backup files to a temp location on the 2nd server and restore that server so it is a test version of the first server. There is no RMAN catalog, I simply want to backup on A move to B restore from files copied to b.

On the first server installed Oracle Enterprise 11.2.0.3. sid = orcl. i created one schema with a new table space added a table and inserted 500,000 rows.

i set the db to archivelog=on, set configure controlfile autobackup on

i then did RMAN backup as backupset database spfile;

on the second server, i installed Oracle Enterprise 11.2.03, sid=orcl exactly like i did on the first server.i scp'd all of the files created by the backup to one location on the test server. i renamed spfileorcl.ora in dbs to somethinge else. startup nomount, exit and go to rman and run this:

DUPLICATE DATABASE TO 'orcl' SPFILE BACKUP LOCATION '/tmp/backups' NOFILENAMECHECK;

this runs for a while and looks like it works but eventually fails with :

RMAN-05541: no archived logs found in target database

subsequent attempts to 'startup' the database receive the error ORA-19838: Cannot use this control file to open database.

This is very frustrating. I have gone over all of the manuals, documentation and more but there is no 'step by step' process that i can find that is current with my version of Oracle that documents the steps necessary to simply backup a db, move it to a test server to a disk and then restore that test server as a copy of the first server.

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

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

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

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

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

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

RMAN Clone From RAC To Single Server?

Apr 27, 2011

I'd like to confirm whether its possible to clone a database instance from a RAC cluster to a single server, with an additional issue that the RAC cluster is running Oracle 10g and the single server is running 11g. Can I do that directly or do I need an intermediate step to upgrade the database instace to 11g? Or can I even use exp/imp on RAC?

View 2 Replies View Related

Server Administration :: Upgrade 9i To 10g Using RMAN Backup?

Mar 22, 2011

I have upgraded a 9i db to 10g on another server using rman backup (9.2.0.8.0 on linux to 10.2.0.4.0 on Linux)

I copied the hot backup - rman from 9i db server to 10g db server

Then I restores the rman backup on the 10g db server opened the database with

alter database open restlogs upgrade;
@?/rdbms/admin/catupgrd.sql
shutdown immediate;
startup restrict
@?/rdbms/admin/utlrp.sql

Now I have all components in VALID state but the db server itself in INVALID state as can be seen from results below

SQL> select comp_name, status, version from dba_registry;

COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
Oracle Database Catalog Views
VALID 10.2.0.4.0

Oracle Database Packages and Types
VALID 10.2.0.4.0

SQL> @?/rdbms/admin/utlu102s.sql TEXT
.
Oracle Database 10.2 Upgrade Status Utility 03-22-2011 10:35:20
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:06:59
.
Total Upgrade Time: 00:07:05

PL/SQL procedure successfully completed.

SQL>

Has the upgrade failed?

Note that
OS for 9i db server is
Linux 2.6.9-42.EL #1 x86_64 x86_64 x86_64 GNU/Linux
OS for 10g db server is
Linux 2.6.18-53.el5 #1 x86_64 x86_64 x86_64 GNU/Linux

View 4 Replies View Related

Server Administration :: Oracle RMAN Backup

May 10, 2012

My production database is about 900 GB in size but the actual data in our database is only approx 600Gb it means 300GB is a deleted data and not fragmented, as per my understanding the best way to resolve fragmentation is Import/Export but we can go for this option because its a very time taking process.

We are taking full database backup using RMAN every week and also going to upgrade our production database from Oracle SE to Oracle EE edition using the same full database RMAN backup, as i know Rman is also not backup of those blocks which not containing any data , it means if we will use Rman full backup to setup our new EE database it will only 600GB of data not 900GB or there is only Export/Import to remove fragmentation.

View 2 Replies View Related

RMAN :: Duplicate Target DB On Remote Server

Sep 18, 2012

on 11g R2 on Win 2008, I want to duplicate my target DB which is on a a remote server using RMAN backups. The destination is on local server.
I will run RMAN on local server.

In initnewdb.ora, I should add :

# Convert file names to allow for different directory structure if necessary.
#DB_FILE_NAME_CONVERT=(/u01/app/oracle/oradata/DB11G/,/u01/app/oracle/oradata/NEWSID/)
#LOG_FILE_NAME_CONVERT=(/u01/app/oracle/oradata/DB11G/,/u02/app/oracle/oradata/NEWSID/)

my questions :

1-In my case would it be :

# Convert file names to allow for different directory structure if necessary.
#DB_FILE_NAME_CONVERT=(\remoteserver:/u01/app/oracle/oradata/DB11G/,/u01/app/oracle/oradata/NEWSID/)
#LOG_FILE_NAME_CONVERT=(\remoteserver:/u01/app/oracle/oradata/DB11G/,/u02/app/oracle/oradata/NEWSID/)

2- should we keep the convert parameters in init.ora file after duplication for always ?

View 14 Replies View Related







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