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 RepliesI 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 .
Given facts:
rman is used to backup database A to disk
rman is used to put those disk backups to tape
rman is used to duplicate database A to database B on another host
the duplicate process worked fine before we started testing encryption
the duplicate process worked fine with database A having an encrypted column in one table in a non-encrypted tablespace
Now, database A has an encrypted tablespace with nothing currently in it. The duplicate process now ultimately fails with ORA-19913, unable to decrypt backup.
I am not using encrypted backups, not specifying encrypt or decrypt anywhere in the duplication process. The only thing that is encrypted is the one tablespace in database A. I have the same wallet files on Host A (database A) and Host B (database B). Wallets are open. So why does the duplication process fail because the backup cannot be decrypted?
I am cloning my prod db to test with the rman active clone command. I can successfully clone my DB, but after a few hours or so I see messages in the alert log that I have corrupted blocks in several datafiles. Note, i dont see these messages in my PROD DB therefore I think that DB has no corruption. I have few questions:
1) I was reading tha having tables or indexes set with the NOLOGGING option can cause objects to be unrecoverable. Would this affect my active clone?
2) I know you can either change a DB or tablespace to force logging. Is there a query I can use to determine if the DB is in force logging mode.
ALTER TABLESPACE tablespace_name FORCE LOGGING;
ALTER DATABASE FORCE LOGGING;
3) Lastly how to check as why my clone DB would have corrupted blocks.
Here is the clone command I am using.
rman catalog=rman/rman@proddb target=sys/sys@proddb << EOT
connect auxiliary sys/sys@clonedb
duplicate target database to clonedb from active database nofilenamecheck
pfile=/u01/app/oracle/product/11g/dbs/initclonedb.ora ;
exit
EOT
How to clone database using RMAN FULL BACKUP on different machine? I do not wants to use DUPLICATE Command......
Is there any other way to clone DB? I am using Oracle 11g R1 on Windows Server 2007 (64 bit)
I want to create such a script to clone the Database user with the new name. Just like we do normal import and export I want that i should enter just the username of the existing user and username of the new user I want to get created, the password for the same.
It should create the new user with all roles and the default roles and privileges of old user.
1. I installed oralce with Service_Name=DB1 it works fine,
2. I created another database with dbca named DB2,
3. I connected both system/password@db1 and system/password@db2 without any problem,
4. After rebooting the computer I can connect only the first database DB1 which I installed with Oracle installation. But, I can not connect to the 2nd database which I created with dbca. Error Message Shows: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
DB1 has no problem I can connect to that, but I can not connect to DB2 after rebooting the system. Now I need to know how to connect to DB2.
Quote:
connection messages:
oracle@pc ~]$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 21 12:51:43 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: SYSTEM@DB1
Enter password:
[code]....
May I know what is the command for rman to backup and delete single archive log?
View 15 Replies View Relatedwe are using oracle 11.2.0.3 on linux platform and was wanting to know if there is a way to backup just a single table partition using rman? If so does the database need to be running in archivelog mode in order to do this with the database online?
This is a database that has one single huge table that is partitioned by day and we are attempting to export out daily partitions using datapump export so that we can archive them to tape but the disk system we have is not able to keep up and the export of roughly 128gb is taking over 8 hours and is failing because the undo is aging out. We would like to bypass writing the partitions out to disk and just stream them to tape if at all possible?
I have database in single server. I already have ORACLE_SID=stagedb. So i want to create new sid and named as proddb.Is it possible have multiple db in single server? This server not running as RAC. It run as single only.
View 1 Replies View RelatedI have installed three database in MY Linux server. I have started Instance for all database and started database also .
No I want to check my databases status or currently running database How can I know . Or which Dynamic View or Database dictionary I should use ?
I have a query regarding the cloning of a database.
Actually, i have made the two machine on a single system(Laptop) and now i want to clone the database, so for that i am unable to move the database backup from one Machine to another.
how can i move the backup and which command is applicable for that.
Note: - Listener/TNS is already configured on both the database.
I have an Oracle 10.1 database on a Windows 32 bit platform that I am attempting to clone to a new server to make a development instance.
For this particular scenario the database needs to stay at version 10.1. Both servers are Windows Server 2003. Following oracle docs I have copied the home folder and am attempting to run OUI with the clone switch.
OUI crashes and reports the error as "unknown".
OUI also crashes if I try to run it without the clone switch from gui.
Why this occurs, and have confirmed that PATH is correct etc on the new dev server and the other obvious stuff.
I just need a quick way of getting this dev server instance up and running AND maintaining the same database version (10.1). I thought the clone operation would be a good option but don't know how to troubleshoot when the error is "unknown".
how to clone database using cold backup,I want step by step guide for it
I want to give clone of production database to developers
My management is asking me to find the best way to migrate our 3.3 TB data warehouse to a new server. I currently use RMAN to back up the database. This is done offline on Sundays, and it takes about 9 hours, compressed backups to disk. Archived log backups are done online, not in conjuction with the db backup.
I have read a number of documents detailing step to use OEM Db Control (aka dbconsole) to clone the database to the new server.
I have a few questions:
1. I need to clone the Oracle SW first, as our current install has patches, so it should take less time.
2. Do you think just restoring from the last RMAN backup and doing recovery would be faster than cloning?
3. On the new server, I have assumed that the root user (not me) would have to pre-create the OFA structure, e.g.; we have some mount points like /f01/oracle/DBNAME or /g01/oracle/DBNAME. I cannot imagine that the Db control Gui or Rman could create that structure on the target server. Is that correct?
4. There seems to be an attitude in my shop that the storage array mount points and OFA would not have to be identical on the target server. Any opinions?
Back in 1995, I successfully manually cloned a database to a new server in an HP environment, but it was only about 70G!!
Difference of standby and clone,i know their uses but i want a detailed explanation.
View 2 Replies View Relatedconfigure the clone the database on the same system. i m using window xp 2000 and oracle 10.2.1.
View 19 Replies View RelatedI am looking to create a DDL-only clone of a 2TB database. The purpose of this clone is to provide developers a preprod-like environment where they can test the syntax of their code changes before deploying to production. The database will reside on a seperate, small server.
As I only need the structure of the objects and not the data, my first port of call was EXP using rows=n. However, when I IMP to an indexfile I see that the initial extents have been defined on the tables (in some cases 1GB!). As stated my clone environment is small, so I would be looking to have these set at 1mb. how I can achieve this? I will want to be able to automate the cloning of the database as much as possible. Perhaps there's some other way other than EXP/IMP?
I have run a standby clone that terminated with error due to few missing LV-s. I removed all LV-s for the clone, recreated them including the missing ones. I ran the clone again,but it skips the files that were successfuly duplicated in the previous clone request that failed. I need to be able to start the clone all over again, but RMAN does persistantly skip duplicating the datafiles that were successfuly processed in the first atempt.
How to ignore the RESUME option so that the clone process would start from the beginning? Where does RMAN keep the info about the successfuly duplicated datafiles in clone standby process? I have tried few RMAN tables , but no luck.
I tried to convert a physical SuseLinux with Oracle 9i Machine into an virtual Machine (esxi Server 5.0). (VMware vCenter Converter ) Before started I shutdown database:
su – oracle
sqlplus ‘/ as sysdba’
shutdown
and the run converter.
But i have problem with copy /u01 and /u02 (database files) "Error: Unable to clone the volume mounted on '/u01' "
So i want clone machine without /u01 and /u02 then copy file. What I should do to be correctly?
Actually i am not using OCI directly. I have a Delphi application in which I would need to clone an open db connection. Not only username, password, and target database (this is easy and i already do that).
What I would need is also inherit context variables and global temporary tables content status at the moment in which the cloning operation takes place. It seems a very difficult, if not impossible, thing to achieve.
I have one Linux machine on which first I did with Oracle 11gR2 Enterprise edition (EE) , it was working fine.
now today I installed oracle11gR2 Standard edition in different partition which is having separate oracle_home from EE.
when I checked the listener services ,port and all , I came to know that the new installation(SE) it will automatically pickup different listener name(listener_SE SID name) and non-standard port(1523).
I did with oracle10gR2 SE and EE both on the same machine with different oracle_home but all together using only one listener (LISTENER) and one port - 1521.
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.
i have just create a clone database. it work very well.but when i open the dbca to delete this database.it not show in dbca prompt. why ?
View 4 Replies View RelatedI'm using Oracle Database 11g R2 for study purposes.Currently I'm learning about the DBCA clonic templates.I have an Oracle DB 11g R2 X86 running properly in Ms Windows XP Professional SP 3 X86, using DBCA I created the seed template file .dbc and the .CTL and .DBF files, later I copied those files to a server running Oracle DB 11g R2 X86 in Ms Windows 7 Ultimate X86. Again, using DBCA I successfully created the source database through the seed template file, everything was ok.
Now, I formatted my testing server and I installed Ms Windows 7 Ultimate X64 and Oracle Database 11g R2 X64. I copied the seed template file .dbc and the .CTL and .DBF files to "assistantsdbca emplates" directory. Well, I started DBCA to try create the source database and when the DBCA is creating and starting the Oracle instance it shows the errors:
ORA-00604: error occurred at recursive SQL Level 1
ORA-06553: PLS-801: Internal error [56327]
Is it possible to clone my testing DB from X86 to X64 using DBCA clonic templates?
Can we make Data Guard to take clone Primary Database at Specific Time?
e.g. Clone Primary Database at 10 AM and at 6 PM?
I have a RedHat Server with Oracle Ent. 8iI did a full export of all my current data bases ( DCTEST, DCPROG, DCUSAC, DCCAND)I now have the DC*.dmp files. How can I know import these files into Oracle Database 11R2?
Do you have a Step-by-Step how-to ?IF I don't have the scripts to re-create the databases how to go forward ?
what will be the advantages and disadvantages of configuring database on only one port number for connecting the database server.
View 1 Replies View Relatedcan I query sql server and oracle in a single form
View 1 Replies View RelatedI am trying to create a clone database using hot backup of a database .
STEPS THAT I FOLLOWED
------------------------------------
LET ----- >CURRENT_DB NAME=DEV
CLONE DATABASE NAME=DEVCLONE
steps PERFORMED FORM DEV DB
-----------------------------------------------
- put the database in backup mode using 'alter database begin backup'
- copy all the data files to a different folder
- during copy i have performed some operations on the DB (creating users, tables, dmls etc...)
- in between copying i also performed log switch
- after completion of copy , "alter database end backup"
- created a backup control file in a human readable format (alter database backup controlfile to trace as ........)
steps performed for clone DB side ((DEVCLONE)
-------------------------------------------------------------------
- created a parameter file for the database .
- modified the backup control file so that it will point to the location of copied destination of datafiles
- set the ORACLE_SID
- then 'sqlplus / as sysdba
- starup nomount
- run the modified control file ( created a control file for the clone database)
- recover the database using "recover database using backup controlfile"
I have provided the archive files that it was asking for (archive logs that has been generated in DEV DB)
then i canceled the recovery by typing "cancel"
- recover database using backup controlfile until cancel;
then typed "cancel"
- then try to open the database with open resetlogs but it showed below error
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:DATA_GUARDDEVHOTSYSTEM01.DBF'