Creating and updating duplicate databases with rman 11g

Data Guard is the name for Oracle's standby database solution, used for disaster recovery and high availability.

creating and updating duplicate databases with rman 11g-59creating and updating duplicate databases with rman 11g-41

All of these are discussed in the Oracle installation guide specific to your operating system.

Additionally, the Oracle Universal Installer will guide you through your installation and provide help in setting up environment variables, directory structure, and authorizations.

Adjust the ALTER SYSTEM SET FAL_SERVER=DB11G_STBY; --ALTER SYSTEM SET DB_FILE_NAME_CONVERT='DB11G_STBY','DB11G' SCOPE=SPFILE; --ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='DB11G_STBY','DB11G' SCOPE=SPFILE; ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO; Remember, some of the parameters are not modifiable, so the database will need to be restarted before they take effect.

Entries for the primary and standby databases are needed in the "$ORACLE_HOME/network/admin/tnsnames.ora" files on both servers.

Creating a database includes the following operations: statement to perform these operations, but other actions are necessary before you have an operational database.

A few of these actions are creating users and temporary tablespaces, building views of the data dictionary tables, and installing Oracle built-in packages.

For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and opens it with NORESET LOGS …

Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN).

Creating a database can also erase information in an existing database and create a new database with the same name and physical structure.

The following topics can help prepare you for database creation.

And lastly, where can I find out the SID of my database? We can have more then 1 database on the same oracle home so we need a way to id them. I know you are on unix, so here are the steps for changing it (or the database name) under Unix - they are different on NT.

Comments are closed.