Creating and updating duplicate databases with rman 11g Freegrannyvideochat
In this article, you will learn the traditional use of UNIX shell scripts and crontab to set up and schedule Oracle Recovery Manager (Oracle RMAN) backups, including a technical explanation of the supplied scripts (in Part I).
You will also see how the same end result of setting up and scheduling Oracle RMAN backups can be achieved seamlessly and easily via Oracle Grid Control, without using any UNIX shell scripts or cron (in Part II).
Ingeniero de Sistemas con énfasis en software y Especialización en Gerencia de Proyectos, Instructor y Especialista Oracle Certificate 10G - 11G, Experiencia Oracle 8I 9I 10G 11G 12C OCA - OCP Experiencia (Real Application Cluster) Cloud Control 12C - (Data Guard) Oracle Web Logic, Certificate ITIL V3, Experiencia en Plataformas Unix-AIX-HPUX-SUN-Linux, Admon (OAS - BEA WEBLOGIC) programación Power Builder Visual Basic C, C , Informix R4gl, Oracle PL/SQL, BI (COGNOS – HYPERION)db_file_name_convert and the log_file_name_convert Once you specify the spfile parameter during the database duplication, you can provide your list of initialization parameters and the values for them through the parameter_value_convert clause and the set clause.
It’s easiest to use the parameter_value_convert clause in the duplicate database command to specify all parameters that specify a directory path.
Presently I’m working as a Senior Oracle Database Administrator for HP (hewlett packard) in Kingdom of Saudi Arabia, (Riyadh). I have extensive experience with Oracle 8i, 9i, 10g & 11g, and Oracle E-Business Suite 11i, Specializing in Installation, Configuration and Administration of Oracle 8i, 9i, 10g, & 11g Oracle 10g/11g RAC, and Oracle E-Business Suite 11i on different UNIX and Linux OS including Solaris, HP-Unix, IBM AIX and Red Hat.
Experience in Upgrading Oracle 8i, 9i, 10g, & 11g and Oracle E-Business Suite 11i.
The demonstration presented in this article is drawn from the real-life experiences of a DBA working at a large corporate site, who used both approaches in his career history.
I have main database Server which is located on Server A, now I have to take the RMAN Backup of Server A and then shift the complete database on new Server B.You can contact me at @ Dear Friends and Blog Readers, I have been asked many times about the Cloning and Refresh process of Oracle Database by emails of blog readers and the users of the Oracle Technology Network (OTN) Forums.Here, in this post, I would like to explain and provide the information on the following Questions about Cloning and Refreshing of a Database with my simple terms.* A database clone is an activity/procedure which is performed by every DBA on regular basis or when there is a requirement or request to do so from the different departments i.e.Test/Development teams.* Cloning is nothing but creating a copy of production system in to a test or development environment. Having an exact image of production database in test area.* Cloning is a procedure for preparing and creating a test or development servers with the copy of Oracle production database for testing upgrades, migrating an existing system to new hardware.* A cloning process includes a copy of Oracle Home (Directories and Binaries) backup and Database (Database related files) backup to prepare the instance on another server.* Though, it is possible to clone a database on the same server, Oracle doesn’t suggest to clone a database on the same server, where the production database is running.* Refreshing a database is something like applying the changes or updates of production database to the database where the database is already cloned. let’s say you have cloned a database a month back, and now you are asked for doing refresh of a database, then you will perform the backup of database and prepare the clone the instance again on test server.This is nothing but refreshing.* When an Oracle patch is applied on Production System, or in doubt, you have to prepare and clone the database again with the copy of Oracle Home (Directories and Binaries) Backup and Database (Database related files) Backup to prepare the instance.* Generally production (PROD) database is cloned for various reasons and needs i.e.