Rebuild the Oracle 11g DR configuration for SAP using File System Copy

Procedure :

a. Standby Site

      1. Shutdown the database.

                $ su – ora<sid>
                SQL> shutdown immediate;

       2. Delete all files under /oracle/SID/sapdata<n>, /oracle/SID/mirrlog<n>, /oracle/SID/origlog<n>.


b. Primary Site

       3. Begin Backup mode

                SQL> alter database begin backup;

       4. Copy all the under /oracle/SID/sapdata<n>, /oracle/SID/mirrlog<n>, /oracle/SID/origlog<n>.

       5. Create the standby database control file for standby

                SQL> alter database create standby controlfile as '/oracle/<SID>/stdby_control.dbf' reuse;

       6. End Backup Mode

                 SQL> alter database end backup;


c. Standby Site

        7. Start the database in mount

                  SQL> startup mount;

        8. Check the database role

                  SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance;

       
         9. Start the log replication and log apply

                   $ lsnrctl start
                   SQL> alter database recover managed standby database disconnect from session;

         10. Check the logs are getting applied

                   SQL>  select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;