Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    55

    Unanswered: restore data in rman

    Hi,
    I backup the database by rman in below

    input datafile fno=00003 name=/database/oradata2/DEMO/TOOL_FRWK_001_00.dbf
    input datafile fno=00011 name=/database/oradata2/DEMO/USER_FRWK_001_00.dbf
    input datafile fno=00019 name=/database/oradata2/DEMO/USER_GCCM_00.dbf
    input datafile fno=00025 name=/database/oradata2/DEMO/USER_SAS_REF_001_00.dbf
    input datafile fno=00035 name=/database/oradata2/DEMO/USER_MBRCA_001_00.dbf
    input datafile fno=00048 name=/database/oradata2/DEMO/USER_RCA_001_00.dbf
    channel ORA_DISK_1: starting piece 1 at 01-OCT-09
    channel ORA_DISK_1: finished piece 1 at 01-OCT-09
    piece handle=/opt/oracle/9.2.0/dbs/04kqmtgv_1_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:05:57
    Finished backup at 01-OCT-09

    RMAN> list backup ;


    List of Backup Sets
    ===================

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    52 Full 64K DISK 00:00:02 30-SEP-09
    BP Key: 53 Status: AVAILABLE Tag: TAG20090930T222421
    Piece Name: /opt/oracle/9.2.0/dbs/02kqis4l_1_1
    List of Datafiles in backup set 52
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    3 Full 1114345 30-SEP-09 /database/oradata2/DEMO/TOOL_FRWK_001_00.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    56 Full 183M DISK 00:05:49 01-OCT-09
    BP Key: 57 Status: AVAILABLE Tag: TAG20091001T111230
    Piece Name: /opt/oracle/9.2.0/dbs/04kqmtgv_1_1
    Controlfile Included: Ckp SCN: 1114692 Ckp time: 01-OCT-09
    List of Datafiles in backup set 56
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 Full 1114693 01-OCT-09 /database/oradata1/DEMO/SYSTEM_FRWK_001_00.dbf
    2 Full 1114693 01-OCT-09 /database/oradata2/DEMO/RBS_FRWK_001_00.dbf
    3 Full 1114693 01-OCT-09 /database/oradata2/DEMO/TOOL_FRWK_001_00.dbf
    4 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_REP_FRWK_00.dbf
    5 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_REP_FRWK_00.dbf
    6 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_INV_FRWK_00.dbf
    7 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_TRAIL_FRWK_00.dbf
    8 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_CI_FRWK_00.dbf
    9 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_CI_FRWK_00.dbf
    10 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_INV_FRWK_00.dbf
    11 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_FRWK_001_00.dbf
    12 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_TRAIL_FRWK_P_00.dbf
    13 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_INV_FRWK_P_00.dbf
    14 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_INV_FRWK_P_00.dbf
    15 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_REP_GCCM_00.dbf
    16 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_REP_GCCM_00.dbf
    17 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_REP_GCCM_00.dbf
    18 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_TARGET_GCCM_00.dbf
    19 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_GCCM_00.dbf
    20 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_SERVICE_GCCM_P_00.dbf
    21 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_TARGET_GCCM_P_00.dbf
    22 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_TARGET_GCCM_P_00.dbf
    23 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_SERVICE_GCCM_P_00.dbf
    24 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_SAS_REF_001_00.dbf
    25 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_SAS_REF_001_00.dbf
    26 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_SAS_REF_001_00.dbf
    27 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_SAS_REF_001_00.dbf
    28 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_MB_REP_RCA_00.dbf
    29 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_MB_CSD_RCA_00.dbf
    30 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_MB_CSD_RCA_00.dbf
    31 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_MB_KEY_RCA_00.dbf
    32 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_MB_KEY_RCA_00.dbf
    33 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_MB_SYNC_RCA_00.dbf
    34 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_MB_SYNC_RCA_00.dbf
    35 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_MBRCA_001_00.dbf
    36 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_CFM_RCA_00.dbf
    37 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_FILE_RCA_00.dbf
    38 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_FILE_RCA_00.dbf
    39 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_APPLI_RCA_00.dbf
    40 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_JAVA_RCA_00.dbf
    41 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_JAVA_RCA_00.dbf
    42 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_APPLI_RCA_00.dbf
    43 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_SWAP_RCA_00.dbf
    44 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_CFM_RCA_00.dbf
    45 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_REP_RCA_00.dbf
    46 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_REP_RCA_00.dbf
    47 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_REP_RCA_00.dbf
    48 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_RCA_001_00.dbf
    49 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_SWAP_RCA_P_00.dbf
    50 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_ACTION_RCA_P_00.dbf
    51 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_ACTION_RCA_P_00.dbf
    52 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_FILE_RCA_P_00.dbf
    53 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_FILE_RCA_P_00.dbf
    54 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_SWAP_RCA_P_00.dbf
    55 Full 1114693 01-OCT-09 /database/oradata_rman/rman_01.dbf

    RMAN> quit

    If I delete the file /database/oradata1/DEMO/SYSTEM_FRWK_001_00.dbf
    , Can I still restore the data by rman without problem ??
    If I delete the file /opt/oracle/9.2.0/dbs/04kqmtgv_1_1
    ,Can I still restore the data by rman without problem ???

    Please advice

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    There's one way to find out! Try it & see...
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •