Duplicate using RMAN Recently, I had a request from one of our clients to duplicate a single instance database into a two node RAC database. Both source and destination databases were 11g Rel 2 on Linux. I could take the old approach and use RMAN backups or use 11g’s new feature DUPLICATE FROM ACTIVE database, which doesn’t need any backup from target database. I preferred to use the second approach. Duplicate from ACTIVE database Duplicating from an active database doesn’t require any RMAN backup to be taken from the source database. Actually, it reads all database structure from the source database that needs to be mounted or opened during the duplication. Duplicate the Target database to Standby from the active database using the script below. The script is known to work on many other databases but is failing here when looking for the init.ora at the target database for parameters. This is because RMAN reads the parameter files in a specific order. Sep 24, 2018 - You find 35+ HP QTP / UFT Interview Questions and answers which is useful for experienced as well. Active X; Delphi; Java.Net; Oracle. 3) Can we call QTP test from another test using scripting. 35) How would you connect to database using VBScript? A) It is used to remove duplicate objects. Rman Duplicate Active Database Script Uft DentalAlthough this method seems easy as we don’t need to backup source database or make it accessible for auxiliary instance anymore, it has its own disadvantages as well. Two big disadvantages of the ACTIVE database duplication method are: • Negative performance impact on the source database. This impact applies to the whole duplication time. • High network traffic on the connection between the source and target databases. ![]() Rman Duplicate Active Database Script Uft ContractIf either of these negative impacts are not acceptable in your environment, you will need to switch to the old backup-based approach. By the way, I think that if you have the latest backup of your source database available and it can be accessed by auxiliary instance, the best method for duplication is still the backup-based approach. Duplicate from active database is an easy task ONLY IF you follow all the steps accurately. Otherwise, it can be a complicated task, and you can waste your time troubleshooting. The following part is simplified step-by-step instructions for DUPLICATE from ACTIVE database: Step-by-step instructions. The diskgroup that will be used for this database is “+HR”. 1- Prepare auxiliary instance HRPRD1 on prd-db-01: Stop all instances of your cluster database except one. In this example, we will use only the HRPRD1 instance, which runs on prd-db-01. We need to stop the other instance, HRPRD2: srvctl stop instance -d HRPRD -i HRPRD2 Set the following parameters on HRPRD1 instance:. ![]() Oraenv HRPRD1 sqlplus / as sysdba alter system set db_name=HRPRD scope=spfile; alter system set cluster_database=false scope=spfile; alter system set db_create_file_dest='+HR'; alter system set db_create_online_log_dest_1='+HR'; shutdown immediate startup nomount 2- Enable status registration for HRPRD1 to run LISTENER: Add the following entries into listener.ora file in GI_HOME. Edit /apps/grid/11.2.0/network/admin/listener.ora and add the following lines: SID_LIST_LISTENER = (SID_LIST = ) (SID_DESC = (SID_NAME = HRPRD1) (ORACLE_HOME = /apps/oracle/product/11.2.0/db_1) (GLOBAL_DBNAME = HRPRD) ) ) Make sure that ORACLE_HOME in this entry points to correct home, which is the home from which HRPRD database runs. 3- Add following TNS entries to BOTH auxiliary and target tnsnames.ora file: HRDEV = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dev-db-01)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = HRDEV) ) ) HRPRD1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prd-db-01)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = HRPRD) ) ) 4- Ceate a password file for auxiliary instance HRPRD1 on prd-db-01: Connections to both instances will be through listener and TNS, so we need to use passwords for both auxiliary and target connections. Crack deep freeze standard v5 2048 unblocked. Rman Duplicate Database ExampleFor HRPRD, since it is a new and empty database, we may need to create a password file for it as follows:. Oraenv HRPRD1 cd $ORACLE_HOME/dbs orapwd password=sys file=orapwHRPRD1. This is an awesome post Kamran. In my case, I found that a few extra steps were needed however because I got this error after RMAN dup completed (only HRPRD1 will start (in my experience). Apr 6, 2018 - Download crack for Age of Empires II HD 1.0 or keygen: In Age of Empires II: HD Edition, fans of the original game and new players alike will. Crack age of empires ii hd the forgotten initiative. Mar 7, 2014 - Age of Empires 2 HD - The Forgotten v3.3 All No-DVD [Reloaded]. The unified Reprise will continue to partner with and support UM and Initiative, the global media networks within IPG Mediabrands, as well as cultivate its own. Here is the error message: [oracle@cgi-ma-uat-db1v ~]$ srvctl start database -d RATIONAL PRCR-1079: Failed to start resource ora.rational.db CRS-5017: The resource action “ora.rational.db start” encountered the following error: ORA-01618: redo thread 2 is not enabled – cannot mount. For details refer to “(:CLSN00107:)” in “/u01/app/11. The dragon hack version 2012 fosi rar download. 2.0/grid/log/cgi-ma-uat-db2v/agent/crsd/oraagent_oracle/oraagent_oracle.log”. CRS-2674: Start of ‘ora.rational.db’ on ‘cgi-ma-uat-db2v’ failed CRS-2632: There are no more servers to try to place resource ‘ora.rational.db’ on that would satisfy its placement policy Following is needed to fix and convert single-instance cloned DB to RAC 2-node (more steps would be needed for 3-node etc) but similar to below. Login to the HRPRD1 up and running instance. Alter database add logfile thread 2 group 4; alter database add logfile thread 2 group 5; alter database add logfile thread 2 group 6; Then also: create undo tablespace UNDOTBS2 datafile size 99614720; (I used size identical to UNDOTBS1). Now 2nd instance startup fine: srvctl start instance -d HRPRD -i HRPRD2 Thanks again for this awesome post Kamran!!! Hi Kamran Bakhshandeh, Another worthy point that I’m persuaded to emphasize is regards the “Directory Structure” and the “Host” wherein which you are been planning to DUPLICATE the database. CASE -1 ======= Duplicating a Database on a “Remote Host” with the ‘Same Directory Structure’ as source (HRDEV), then NO changes is required to be made for PFILE.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |