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
ADVERTISEMENT
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 - 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'
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>
Server Administration :: Access To Database Server Machine Login?
Apr 30, 2012database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?
View 9 Replies View RelatedNetworking And Gateways :: Client And Database Server On Same Machine?
Mar 26, 2013I have client and database on same machine, when I will connect to the instance , it will use IPC, suppose If I will use connection string then which process will handle this request?
View 2 Replies View RelatedServer Administration :: Load Database Files On Other Machine?
Dec 7, 2010I am trying to upload a database backup on a machine. Since the structure of files is different from server, how can i start the database.
Do i need to create a new control file? If yes, how can i run the sql command "Alter database backup controlfile to trace" in nomount mode.
Server Administration :: Number Of Sessions In Database MES (production) Coming From Another Machine
May 25, 2010We have quite a number of sessions in database MES (production) coming from another machine.
From v$session, the program is oracle@WID27 (TNS V1-V3). This WID27 (hostname) consists of quite a number of development databases inside. We have to trace which jobs are actually triggering this, as WID27 are not suppose to connect to production databases.
How can we tell whether the sessions came in is from dblink or from the machine itself?
Forms :: Generate File From Database Into Server And Copy It To Client Machine
Feb 2, 2012I have a forms that generate a file from database into database server and copy it to client machine by the follow process:
IF webutil_file_transfer.Is_AS_readable(V_server_way || V_file_name) THEN
l_success := webutil_file_transfer.AS_to_Client
(clientFile => :V_screen_way
[code]...
But is showing the erro ora-105100 in one client machine
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 ?
Oracle 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 RelatedBackup & 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'
Database Auto Start With Machine On And Shutdown With Machine Shutdown
Sep 2, 2012i install oracle 10g on linux on perform the following step but my database is not auto start with the machine
Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.
The scripts are,
$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbshut
Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.
-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.
In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.
If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.
The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.
Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.
Automate Startup/Shutdown of Oracle Database on Linux
Step 01: Be sure that oratab file is correct and complete.
Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.
Database entries in the oratab file have the following format:
$ORACLE_SID:$ORACLE_HOME:Y
Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.
If in my database there is two database named arju and arjudup then my oratab file will contain the entry like,
arju:/var/opt/oracle/product/10.2.0/db_1:Y
arjudup:/var/opt/oracle/product/10.2.0/db_1:Y
where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.
Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.
a) Login as root.
b) Change directories to /etc/init.d
c) Create a file called dbora and chmod it to 750.
# touch dbora
# chmod 750 dbora
d)Edit the dbora file and make the contents of it like below.
[Code].....
Database 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 ?
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?
RMAN Cloning From One Server To Another?
Jan 17, 2012RMAN cloning from one server to another server.
View 2 Replies View RelatedBackup & 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 :: 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 RelatedServer Administration :: Multiple Database With Multiple Instance On Same Machine?
Mar 16, 2011can we have multiple database version running in a single machine with multiple instances provided there are enough resources.Can we do in RAC only?
View 15 Replies View RelatedBackup & 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.
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
Recovery 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?
Server Administration :: Fetch Procedure Of One Database From Another Server
Oct 22, 2011I want to know if I can access a procedure created on Database server A from database server B.
View 2 Replies View RelatedProcedure To Link Oracle 9i Database Server?
Jun 17, 2009the procedure to link oracle 9i database server withi 10i.
View 1 Replies View RelatedRAC & Failsafe :: ORACLE Server Failover Parameters In Windows Server Machine.config File
Jan 17, 2012working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.
View 6 Replies View RelatedServer Administration :: SHUTDOWN And STARTUP DB Server From Client Machine?
Sep 21, 2010I have installed oracle 11g Release 11.1.0.1 on windows server 2008.I access this server from a client machine running on winXP through SQL PLUS. I wanted to shutdown and start DB server from this client machine. Accordingly i issued shutdown immediate command from SQLPLUS.
Now when i tried to start the DB with "STARTUP NOMOUNT" command i received error 12514. I understand this error means that the listener received a request to establish connections to a database but since DB services are not up and running, hence the error. So my first question is how do I resolve this error.
Continuing further, i tried to re-connect to the database as sys, and i received another error ORA-01041. So, my second question is why did i receive this error and again how can i resolve it
may be you can point me to relevant reference in Oracle documentation) how can i start and stop oracle from a client machine using SQL interface in CLI mode and windows environment and avoid this error.
Backup & Recovery :: ORA-19870 / Error Reading Backup Piece During Database Cloning
Mar 15, 2011I 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].....
Server Utilities :: Export Procedure Views Function And Packages In Database
Sep 29, 2010How to export the procedure,views,function and packages in a database, by using Export commmand.
View 2 Replies View RelatedServer Utilities :: Unable To Import One Procedure From Full Database Dump ( 10g )
Jun 20, 2008i have full export dump file....from this, i need to import only one procedure belongs to schema : IC_MIGR_DATA... i need to import into SCHEMA : rep_user...
iam giving syntax:
impdp system/icg0ld@ICPRD directory=DUMPDIR dumpfile=IC_FULL_19062008.dmp logfile=imp_IC_FULL_190608.log schemas=rep_user parfile=imp_proc.par
parfile :
--------
INCLUDE=PROCEDURE:"LIKE 'IC_MIGR_DATA.JET_UPLIFT'"
while importing, iam getting below error,
*****[oracle10@AIICDELL IC]$ impdp system/icg0ld@ICPRD directory=DUMPDIR dumpfile=IC_FULL_19062008.dmp logfile=imp_IC_FULL_190608.log schemas=rep_user parfile=imp_proc.par
Import: Release 10.2.0.2.0 - 64bit Production on Friday, 20 June, 2008 16:19:46
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-31644: unable to position to block number 30698425 in dump file "/AIIC_backup/expbkp/dumps/IC/IC_FULL_19062008.dmp"
******
how to import this one procedure JET_UPLIFT , this has to be imported into REP_USER schema, owner of this procedure is IC_MIGR_DATA