SQL>grant connect, resource, recovery_catalog_owner to <username>;
Statement processed.
3. Manually transfer the Oracle password file orapw<Oracle SID name> from the source computer to the destination computer. Usually, this file resides in ORACLE_HOME/dbs.
4. Export the recovery catalog data for the catalog user.
For example, if the user ID for the recovery catalog owner is user1, you need to export the database backup information for user1.
5. Import the recovery catalog data to the new user account for the destination computer.
Example using IMPORT CATALOG Command::
RMAN>IMPORT CATALOG user1/user1@src;
6. Copy the recovery catalog’s connect string entry in the tnsnames.ora file from the source host to the destination host.
<;service_name> = (DESCRIPTION =
(ADDRESS = (PROTOCOL = <protocol>)(HOST = <host>) (PORT = <##>))
(CONNECT_DATA = (SID = <Recovery Catalog database>)))
7. Make sure that the ORACLE_SID and ORACLE_HOME are appropriately configured on the destination computer.
Example:: For Unix:
#export ORACLE_SID= <target database SID> #export ORACLE_HOME= <Oracle home directory>
For Windows:
C:\set ORACLE_SID= <target database SID> C:\set ORACLE_HOME= <Oracle home directory>
8. Create the Oracle RAC client and configure it as a client in the same CommServe in which the source machine resides.
9. Create and configure a new Oracle instance in the RAC Client on the destination computer, similar to the one existing in the source computer. Ensure that this instance is in NOMOUNT mode.
RESTORING THE DATABASE
10. From the CommCell Browser, navigate to Client Computers | <RAC Client> 11. Right-click the <Instance> point to All Tasks and then click Restore. 12. Select the name of the client computer from the Destination Client list. 13. Verify that the Restore Data and Recover options are selected. 14. Select Restore Control File check box.
15. Click Advanced.
16. Click the Options tab.
17. If the database is in NOARCHIVELOG mode, then select No Redo Logs. 18. Click OK.
If the shared computer on which you hosted a RAC database is damaged or destroyed, you can restore and recover the lost database on a new standalone host computer with a different directory structure. You can restore a database either in ARCHIVELOG or NOARCHIVELOG mode on a new host.
By default, the database is restored in the ARCHIVELOG mode, You can also choose to restore the db in NOARCHIVELOG mode. Use the following steps to restore and recover a database to a new host with a different directory structure:
PREREQUISITES
1. Verify the following in both the source and destination computers:
z The connection specifications (host, service name, port) in the tnsnames.ora file on both the source and destination computers should be different.
z The <username> you use for the destination computer is different than the username for the source computer.
z Sufficient disk space is available on the destination computer to accommodate the restored database.
z Both the source and destination computers should have the following similar features: { Operating systems
{ Oracle version { ORACLE_SID { init <SID>.ora file { Processor (32-bit or 64-bit) { Datafile directory structures
CONFIGURING THE INIT <SID>.ORA FILE
2. Copy the init<SID>.ora from the old host to the new host.
3. Edit the init<SID>.ora file on the new host to reflect all the directory structure changes (i.e., change the path for control files, archivelog destination and *dump destinations).
4. Create the directory structures as defined in init<SID>.ora file for all paths.
SETTING UP THE SOURCE AND DESTINATION HOSTS
5. Create a new user account with recovery catalog owner permission within the Recovery Catalog for the destination computer. Use a different <username>
Example:
SQL>create user <username> identified by <password> 2>temporary tablespace <temp_tablespace_name> 3>default tablespace <default_tablespace_name> 4>quota unlimited on <default_tablespace_name>; Statement processed.
SQL>grant connect, resource, recovery_catalog_owner to <username>;
Statement processed.
6. Manually transfer the Oracle password file orapw<Oracle SID name> from the source computer to the destination computer. Usually, this file resides in ORACLE_HOME/dbs.
7. Export the recovery catalog data for the catalog user.
For example, if the user ID for the recovery catalog owner is user1, you need to export the database backup information for user1.
8. Import the recovery catalog data to the new user account for the destination computer.
Example using IMPORT CATALOG Command:
RMAN>IMPORT CATALOG user1/user1@src;
9. Copy the recovery catalog’s connect string entry in the tnsnames.ora file from the source host to the destination host.
<service_name> = (DESCRIPTION =
(ADDRESS = (PROTOCOL = <protocol>)(HOST = <host>) (PORT = <##>))
(CONNECT_DATA = (SID = <Recovery Catalog database>)))
10. Make sure that the ORACLE_SID and ORACLE_HOME are appropriately configured on the destination computer.
Example: For Unix:
#export ORACLE_SID= <target database SID> #export ORACLE_HOME= <Oracle home directory>
For Windows:
C:\set ORACLE_SID= <target database SID> C:\set ORACLE_HOME= <Oracle home directory>
11. Create the Oracle RAC client and configure it as a client in the same CommServe in which the source machine resides.