single mom of 2 dating - Creating and updating duplicate databases with rman 11g

duplicate target database for standby dorecover; Starting Duplicate Db at 27-JAN-13 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=19 device type=DISK contents of Memory Script: executing Memory Script executing command: SET until clause Starting restore at 27-JAN-13 using channel ORA_AUX_DISK_1 . That’s because it is standby database and it should not be in open state anyway and that’s why RMAN did not attempted to open it.

Even if you open the database it will still be in read only mode.

For this illustration, we will use ACTIVE DUPLICATE as this is one of the most popular DUPLICATE method in use since it's introduced in 11g. In Node 1 of UAT cluster, from grid user, add static listener entry for "UAT" database in GRID_HOME/network/admin/and reload the listener to show up the static service UAT: [[email protected] ~]$ . ASM1 The Oracle base has been set to /u01/app/oracle Add below: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UAT) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = UAT) ) ) [[email protected] ~]$ lsnrctl reload LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-AUG-2014 Copyright (c) 1991, 2011, Oracle. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) The command completed successfully [[email protected] ~]$ lsnrctl services LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-AUG-2014 Copyright (c) 1991, 2011, Oracle. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) Services Summary... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER The command completed successfully [[email protected] ~]$ [[email protected] ~]$ sqlplus sys/[email protected] as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 4 2014 Copyright (c) 1982, 2011, Oracle. On Node 1 of UAT cluster, from oracle user, create parameter file init in $ORACLE_HOME/dbs directory with just below parameters: [[email protected]]$ sqlplus sys/[email protected] as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 4 2014 Copyright (c) 1982, 2011, Oracle. [[email protected]]$ export NLS_DATE_FORMAT="DD-MON-YYYY HH24: MI: SS" [[email protected]]$ rman target sys/[email protected] auxiliary sys/[email protected] | tee /tmp/rman Recovery Manager: Release 11.2.0.3.0 - Production on Mon Aug 4 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. connected to target database: PROD (DBID=2126157328) connected to auxiliary database: UAT (not mounted) RMAN Execute below RMAN DUPLICATE run block. UNDO_TABLESPACE, REMOTE_LISTENER, etc...) for UAT as needed for your environment.

However, make sure that CLUSTER_DATABASE is set to FALSE.

Just change the name of file and use instance name as an indicator. Total System Global Area 845348864 bytes Fixed Size 1339796 bytes Variable Size 532680300 bytes Database Buffers 306184192 bytes Redo Buffers 5144576 bytes Database mounted. SQL The password file will be created at below mentioned location. SQL startup nomount pfile=/u01/app/Oracle/admin/stby/pfile/Oracle instance started. Total System Global Area 841162752 bytes Fixed Size 1339768 bytes Variable Size 499125896 bytes Database Buffers 335544320 bytes Redo Buffers 5152768 bytes The next step is to configure the network setting for database.

/u01/app/Oracle/product/11.2.0/dbhome_1/dbs It’s time to start the auxiliary database in the nomount state. [[email protected] ~]$ Oracle_SID=stby [[email protected] ~]$ export Oracle_SID [[email protected] ~]$ sqlplus / as sysdba $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 27 2013 Copyright (c) 1982, 2009, Oracle. Open the file located at /u01/app/Oracle/product/11.2.0/dbhome_1/network/admin and paste the following content in it and save the changes in the file.

For ASM storage, create required ASM diskgroups to store UAT RAC database files.

There are various methods to perform RMAN DUPLICATE, mainly categorized in Backup based DUPLICATE and ACTIVE DUPLICATE (11g onwards). Instance "UAT", status UNKNOWN, has 1 handler(s) for this service... SQL You need to carefully review the parameters of PROD database and pre-create the directory structures for UAT as needed. SQL Note: If STARTUP fails with error ORA-00304: requested INSTANCE_NUMBER is busy, then add below parameter in init with some odd instance number which possibly not in use: instance_number=11 Now, restart again in NOMOUNT and it should succeed.

The most important change that is required is updating the DB_NAME parameter to match the primary database name.

This is because the standby database will still be dependent on primary database.

You can use the operating system specific copy command to create a copy of the files.

However if you are using spfile on the source or target database then you will have to generate it using the following command.

Target Oracle Home: /u01/app/oracle/product/11.2.0/dbhome_1.

Tags: , ,