[oracle@rac1 ~]$ cat initbr8dba.ora *.audit_file_dest='/u01/app/oracle/admin/br8dba/adump' *.audit_trail='db' *.cluster_database=false *.compatible='11. Decyfer Down Crash Rar. 2.0.0.0' *.control_files='+TEST','+DATA' *.db_block_size=8192 *.db_create_file_dest='+TEST' *.db_domain=' *.db_name='w5005pr'. [oracle@rac1 ~]$. Oraenv ORACLE_SID = [br8dba]? The Oracle base remains unchanged with value /u01/app/oracle [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 5 21: Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL>startup nomount pfile='/home/oracle/initbr8dba.ora'; ORACLE instance started.

Creating a RAC Database Manually (without dbca). To create your RAC databases. $ srvctl start database -d DEVDB. Creation of a new Oracle 11gR2 11.2.0.4 database instance simply called 'emrep' using the DBCA tool and archiving enabled. In the following example, we will create a 6 node RAC database on the clustered nodes viscosityoradb1 to viscosityoradb6. We will create a general purpose database.

Total System Global Area bytes Fixed Size 2227984 bytes Variable Size 754974960 bytes Database Buffers 503316480 bytes Redo Buffers 8847360 bytes SQL>SQL>create spfile from pfile='/home/oracle/initbr8dba.ora'; File created. SQL>shut immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL>SQL>startup nomount; ORACLE instance started. [oracle@rac1 ~]$ rman target / Recovery Manager: Release 11.2.0.3.0 - Production on Wed Oct 5 22: Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to target database: W5005PR (not mounted) RMAN>restore controlfile from '/u01/share/backup/database_W5005PR_02rhkeo7_2'; Starting restore at 05-OCT-16 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=16 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=+TEST/br8dba/controlfile/current.229 output file name=+DATA/br8dba/controlfile/current.331 Finished restore at 05-OCT-16 RMAN>Step 9: Mount database. RMAN>catalog start with '/u01/share/backup/'; searching for all files that match the pattern /u01/share/backup/ List of Files Unknown to the Database ===================================== File Name: /u01/share/backup/database_W5005PR_02rhkeo7_2 File Name: /u01/share/backup/Control_W5005PR_04rhkeop_4 File Name: /u01/share/backup/arch_W5005PR_03rhkeoh_3 Do you really want to catalog the above files (enter YES or NO)?