10 Replies Latest reply: Sep 17, 2012 12:15 AM by abdul: RSS

    Steps To Create Physical Standby Database In Windows 7

    940673
      Hi All,

      I want to create a physical standby database in my windows 7 system. I have created one service stdby in my machine with all your help and now I need your help to configure standby configuration.

      I am using Oracle 10G version 10.2.0.1.0.

      Please suggest.

      Regards,
      Arijit
        • 1. Re: Steps To Create Physical Standby Database In Windows 7
          abdul:
          hi,
          can you paste here your pfile so that i would watch some parameters.
          • 2. Re: Steps To Create Physical Standby Database In Windows 7
            940673
            Hi Abdul,

            I have done some parameter changes in primary database and created the latest pfile from Spfile. My Database is running on spfile. I have pasted below my initPROD.ora configurations:-

            xe.__db_cache_size=591396864
            xe.__java_pool_size=4194304
            xe.__large_pool_size=4194304
            xe.__shared_pool_size=201326592
            xe.__streams_pool_size=0
            *.fal_client='STBY'
            *.fal_server='XE'
            *.log_archive_dest_1='LOCATION=C:\oraclexe\app\oracle\flash_recovery_area\XE\ARCHIVELOG MANDATORY'
            *.nls_date_format='MM-DD-YY'
            *.SPFILE='C:\oraclexe\app\oracle\product\10.2.0\server\dbs/spfileXE.ora'
            *.standby_archive_dest='E:\Arijit\oraclestby\archivelog'
            *.standby_file_management='AUTO'

            Please check and let me know if I have to add few more in the init file.

            Regards,
            Arijit
            • 3. Re: Steps To Create Physical Standby Database In Windows 7
              940673
              Hi Abdul,

              As you know I have created one standby instance STDBY using ORADIM utility. But can you assist me how to start that instance.

              Regards,
              Arijit
              • 4. Re: Steps To Create Physical Standby Database In Windows 7
                abdul:
                if i am maintaining my database i wont change my primary db pfile:

                so it should be like:
                paceview.__db_cache_size=754974720
                paceview.__java_pool_size=4194304
                paceview.__large_pool_size=4194304
                paceview.__shared_pool_size=301989888
                paceview.__streams_pool_size=0
                *.control_files='/PGHProdDB/oradata/paceview/control1.ctl','/PGHProdDB/oradata/paceview/control2.ctl','/PGHProdDB/oradata/paceview/control3.ctl'
                *.db_block_size=8192
                *.db_name='paceview'
                *.log_archive_dest_1='location=/PGHProdDB/archive/paceview/'
                *.sga_max_size=1073741824#one gig
                *.sga_target=1073741824#one gig
                *.shared_pool_size=300000000
                *.undo_management='AUTO'
                *.undo_tablespace='UNDOTBS1'
                do as i :)
                • 5. Re: Steps To Create Physical Standby Database In Windows 7
                  Mahir M. Quluzade
                  Hi,

                  please watch my video : http://www.mahir-quluzade.com/2012/01/overview-data-guard-configuration.html

                  Regards
                  Mahir M. Quluzade
                  • 6. Re: Steps To Create Physical Standby Database In Windows 7
                    abdul:
                    [on primary]
                    step-1 check if archiving is enable
                    SQL> archive log list;
                    Database log mode              Archive Mode
                    Automatic archival             Enabled
                    Archive destination            /PGHProdDB/archive/paceview/
                    Oldest online log sequence     52
                    Next log sequence to archive   54
                    Current log sequence           54
                    step-2
                    sqlplus> ALTER DATABASE force logging;
                    step-3
                    connect to rman
                    take an full backup
                    RMAN RUN {
                    allocate channel d1 type disk;
                    backup format '/u01/backups/PRIMARY/df_t%t_s%s_p%p' database;
                    sql 'alter system archive log current';
                    backup format '/u01/backups/PRIMARY/al_t%t_s%s_p%p' archivelog all;
                    backup current controlfile for standby format '/u01/backups/PRIMARY/sb_t%t_s%s_p%p';
                    release channel d1;
                    }
                    step-4
                    now copying initpfile,pwdfile on appropriate destination and rename it.
                    
                    step 5 
                    now create listener on standby db side::
                    
                    and restart it by ----
                    lsnrctl reload
                    
                    
                    and login to primary db and register listener information in tnsfile.ora---
                    
                    
                    standby=
                      (DESCRIPTION =
                        (ADDRESS_LIST =
                          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.13)(PORT = 1521))
                        )
                        (CONNECT_DATA =
                          (SERVICE_NAME = standby)
                    Step 6 Startup the standby
                    SQL> startup nomount pfile='/u01/app/oracle/admin/PRIMARY/pfile/init.ora';
                    step 7
                    though our primary db is ready to connect with standby db
                    [oracle@PGH-DB ~]$ rman target / auxiliary sys/tiger@standby
                    
                    Recovery Manager: Release 10.2.0.4.0 - Production on Mon Aug 6 12:16:08 2012
                    
                    Copyright (c) 1982, 2007, Oracle.  All rights reserved.
                    
                    connected to target database: primary (DBID=2092349485)
                    connected to auxiliary database (not started)
                    
                    RMAN> run {
                    allocate channel C1 device type disk;
                    allocate auxiliary channel C2 device type disk;
                    duplicate target database for standby nofilenamecheck;
                    }
                    When this completes

                    Make sure you shutdown the database and then switch the ORACLE_SID=STANDBY

                    when you perform that much let me know :)

                    Edited by: abdul_ora on Sep 12, 2012 11:37 AM
                    • 7. Re: Steps To Create Physical Standby Database In Windows 7
                      Mahir M. Quluzade
                      hi, abdul_ora.

                      Looks nice your post, thanks!


                      Regards
                      Mahir M. Quluzade
                      • 8. Re: Steps To Create Physical Standby Database In Windows 7
                        abdul:
                        awaww..!! its been so nice of you

                        thanks for appreciation ;)
                        • 10. Re: Steps To Create Physical Standby Database In Windows 7
                          abdul:
                          hi user,
                          have you tried that what i have suggested you? look donot pending your session on as it is not good for forum

                          thanks