![]() Target system concurrent processing node :abcap Target system database domain name :fd.re.comĭoes the target system have more than one application tier server node (y/n) ? nĭoes the target system application tier utilize multiple domain names (y/n) ? n Target system database server node :abcdb Log on to the target system as the APPLMGR user and type the following commands:ĭo you want to use a virtual hostname for the target node (y/n) ? n Shutdown database TST and startup using backup initfile ()Ĭonfigure the Target System Application nodes (abcap) Started testing the availabilty of ports in port pool 21 ![]() Target system DATA_TOP 3:/u02/oradata/TST/datafilesĭo you want to preserve the Display set to localhost:12.0 (y/n) ?:yĭo you want to preserve the port values from the source system on the target system (y/n) ? ![]() Target system DATA_TOP 2:/u02/oradata/TST/redo Target system DATA_TOP 1 :/u02/oradata/TST/datafiles Number of DATA_TOP’s on the target system Target system utl_file accessible directories list :/usr/tmp Target system RDBMS ORACLE_HOME directory Target instance is a Real Application Cluster (RAC) instance (y/n) :n $ORACLE_HOME/bin Connect to catalog and source, target databases and run restore.rcvĬonnect target catalog auxiliary above step will duplicate and open the database to TSTĭo you want to use a virtual hostname for the target node (y/n) ?:n ![]() NB_ORA_CLIENT= Client Name with backup was done ( PROD Server Name)Ĭreate a init file $ORACLE_HOME/dbs/initTST.ora NB_ORA_SERV=Server name of the tape library GROUP 3 ( ‘/u02/oradata/TST/redo/redo03.log’) SIZE 50M Set newname for datafile 4 to ‘/u02/oradata/TST /datafiles/ctxd01.dbf’ ĭuplicate target database to “TST” nofilenamecheck logfile Set newname for datafile 3 to ‘/u02/oradata/TST/datafiles/SYSAUX01.dbf’ ![]() Set newname for datafile 2 to ‘/u02/oradata/TST/redo/UNDOTBS101.dbf’ Set newname for datafile 1 to ‘/u02/oradata/TST/datafiles/SYSTEM01.dbf’ SEND ‘NB_ORA_SERV=sunvrts1, NB_ORA_CLIENT=xyzdb’ On Node : abcdb Path: /u00/app/oracle/TST/bin ( Target ORACLE_HOME)Ī) tocuh restore.rcv & copy the spool result from above, Use the last log sequence number backed up in the script.ī) allocate channels for restoring database on abcdb.Īllocate auxiliary channel t1 type ‘SBT_TAPE’ Īllocate auxiliary channel t2 type ‘SBT_TAPE’ Īllocate auxiliary channel t3 type ‘SBT_TAPE’ Sql>select ‘set newname for datafile’file#’ to ”’name”’ ’ from v$datafile ī)Get the latest sequence number backed up on PROD (last log sequence=2153) Orapwd file=orapwdTST password=clonetst entries=5Ĭollect the information from PROD database ( Files to be Restored on TST) (Refer : Doc ID 246241 Basic steps for running an alternate Client restore of Oracle database using Recovery Manager without a catalog ) Copy RDBMS Oracle Home(ORACLE_HOME) from source (PROD,xyzdb) to target instance abcdbĢ.Copy APPL_TOP, COMMON_TOP, ORA_TOP from xyzap to abcapģ.Cloning of Oracle Database normally can be done in 3 waysĬonfiguring Veritas Netbackup on abcdb node (Target)Ĭhange the client name to xyzdb ( Client name should be same as on Production)Ģ) Create a user (appown) to perform the restore (this user’s name and group must match the user that performed the backup on the original client). Database Node: xyzdb Application Node : xyzapġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |