1 2 Previous Next 19 Replies Latest reply: Feb 11, 2013 6:32 AM by DB Go to original post RSS
      • 15. Re: i got the above error while i restore the standby database using RMAN back
        Mihael
        hp-ux does not have "file" command ?
        also print output of "mount"
        • 16. Re: i got the above error while i restore the standby database using RMAN backu
          DB
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          control_file_record_keep_time        integer     7
          select from v$archived_log;
          from production:
               RECID      STAMP
          ---------- ----------
          NAME
          --------------------------------------------------------------------------------
             DEST_ID    THREAD#  SEQUENCE# RESETLOGS_CHANGE# RESETLOGS FIRST_CHANGE#
          ---------- ---------- ---------- ----------------- --------- -------------
          FIRST_TIM NEXT_CHANGE# NEXT_TIME     BLOCKS BLOCK_SIZE CREATOR REGISTR STA ARC
          --------- ------------ --------- ---------- ---------- ------- ------- --- ---
          APP DEL S COMPLETIO DIC DIC END BACKUP_COUNT ARCHIVAL_THREAD# ACTIVATION#
          --- --- - --------- --- --- --- ------------ ---------------- -----------
          10-FEB-13   1760134353 10-FEB-13     102398       1024 ARCH    ARCH    NO  YES
          NO  NO  A 10-FEB-13 NO  NO  NO             0                1  1287995239
          
          
               RECID      STAMP
          ---------- ----------
          NAME
          --------------------------------------------------------------------------------
             DEST_ID    THREAD#  SEQUENCE# RESETLOGS_CHANGE# RESETLOGS FIRST_CHANGE#
          ---------- ---------- ---------- ----------------- --------- -------------
          FIRST_TIM NEXT_CHANGE# NEXT_TIME     BLOCKS BLOCK_SIZE CREATOR REGISTR STA ARC
          --------- ------------ --------- ---------- ---------- ------- ------- --- ---
          APP DEL S COMPLETIO DIC DIC END BACKUP_COUNT ARCHIVAL_THREAD# ACTIVATION#
          --- --- - --------- --- --- --- ------------ ---------------- -----------
              343272  807047516
          /archive/esmsrv1/archive-esmsrv1_1_184778.arc
                   1          1     184778          22209351 08-MAR-07    1760134353
          
               RECID      STAMP
          ---------- ----------
          NAME
          --------------------------------------------------------------------------------
             DEST_ID    THREAD#  SEQUENCE# RESETLOGS_CHANGE# RESETLOGS FIRST_CHANGE#
          ---------- ---------- ---------- ----------------- --------- -------------
          FIRST_TIM NEXT_CHANGE# NEXT_TIME     BLOCKS BLOCK_SIZE CREATOR REGISTR STA ARC
          --------- ------------ --------- ---------- ---------- ------- ------- --- ---
          APP DEL S COMPLETIO DIC DIC END BACKUP_COUNT ARCHIVAL_THREAD# ACTIVATION#
          --- --- - --------- --- --- --- ------------ ---------------- -----------
          10-FEB-13   1760148629 10-FEB-13     102393       1024 ARCH    ARCH    NO  YES
          NO  NO  A 10-FEB-13 NO  NO  NO             0                1  1287995239
          
          
          2699 rows selected.
          • 17. Re: i got the above error while i restore the standby database using RMAN back
            DB
            is anything i need to change here?
            is any mismatch between these parameters and i given?
            ----
            CONFIGURE RETENTION POLICY TO REDUNDANCY 5;
            CONFIGURE BACKUP OPTIMIZATION OFF; # default
            CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
            CONFIGURE CONTROLFILE AUTOBACKUP OFF;
            CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradatabkp/rman/esmsrv1/controlfile/%F';
            CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
            CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
            CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
            CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/esmsrv1/esmsrv1_rmanbkp/%d_control_%U';
            CONFIGURE MAXSETSIZE TO UNLIMITED; # default
            CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/9.2.0/dbs/snapcf_esmsrv1.f'; # default
            Edited by: DB on Feb 11, 2013 9:56 AM
            • 18. Re: i got the above error while i restore the standby database using RMAN back
              Mihael
              is anything i need to change here?
              is any mismatch between these parameters and i given?
              ----
              CONFIGURE RETENTION POLICY TO REDUNDANCY 5;
              CONFIGURE BACKUP OPTIMIZATION OFF; # default
              CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
              CONFIGURE CONTROLFILE AUTOBACKUP OFF;
              CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradatabkp/rman/esmsrv1/controlfile/%F';
              CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
              CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
              CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
              CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/esmsrv1/esmsrv1_rmanbkp/%d_control_%U';
              CONFIGURE MAXSETSIZE TO UNLIMITED; # default
              CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/9.2.0/dbs/snapcf_esmsrv1.f'; # default
              this is OK, but "REDUNDANCY 5" will require much disk space
              also "CONFIGURE CONTROLFILE AUTOBACKUP FORMAT" makes no sence because of "CONFIGURE CONTROLFILE AUTOBACKUP OFF"
              • 19. Re: i got the above error while i restore the standby database using RMAN back
                DB
                hi all,
                Thank you Mihael.
                solved.

                its issue in Soft_link..finally our team rectified.

                Regards,
                DB.

                Edited by: DB on Feb 11, 2013 6:02 PM
                1 2 Previous Next