This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Feb 11, 2013 4: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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points