RMAN and recovering data
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: RMAN and recovering data

Hybrid View

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    RMAN and recovering data

    I have my database running in archive mode and I am trying to recover a table while running RMAN on the command line and this does not seem to be working for me.

    Can somebody outline the steps (with syntax) that I need to take to recover the table.


    Thanks in advance for all that answer

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you cant recover tables with rman, rman deals with blocks, datafiles and tablespaces

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    thanks, can you provide me with an outline on how to recover a tablespace or datafile?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    might be an idea to explain what you are trying to do

  5. #5
    Join Date
    Jul 2006
    Posts
    195
    I have a varchar2 column in a table, which contains binary data. We chose varchar2's columns based on how the RDBMS stores values for varchars as opposed to blobs. At least historically, blobs were stored separately and I was concerned about access times especially in light of the fact that we use select *. In addition, to
    change varchar2 to blobs or raws at this point is not worth the development time.

    Now we are porting our application to Oracle 10G I want to verify if RMAN can restore a table that has binary data in a varchar2 column without any data translation. So what I tried doing is placing one table that has varchar2 column with binary data into its own tablespace.

    I backed up the tablespace using RMAN.

    I went into SQLPLUS and dropped the tablespace including contents

    I tried restoring the tablespace via RMAN and I was not succesful.

    My database is in archive mode but I know I missing some step/(s) on the restoration side. That is where I need a bit of assitance.
    Any help and exact syntax would be appreciated.

    Thanks in advance to all who answer this post

  6. #6
    Join Date
    Nov 2000
    Posts
    224
    You may have to restore using backup control file as the current control file doesn't have entry for dropped tablespace. Can you paste you rman script?

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    doesnt matter what the data is, rman will restore it

    might be helpful to know what you did

  8. #8
    Join Date
    Jul 2006
    Posts
    195
    rman> backup tablespace pbh'

    sqlplus sys/"sys as sysdba"

    sqlplus > drop tablespace pbh including contents;

    rman> restore tablespace pbh;

    Starting restore at 10-AUG-06
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=138 devtype=DISK
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 08/10/2006 15:01:11
    RMAN-20202: tablespace not found in the recovery catalog
    RMAN-06019: could not translate tablespace name "PBH"

  9. #9
    Join Date
    Apr 2006
    Posts
    377
    So you are trying to restore the tablespace just like you were trying to do here ??

    The answer will be the same !!!

  10. #10
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Quote Originally Posted by BeefStu
    rman> backup tablespace pbh'

    sqlplus sys/"sys as sysdba"

    sqlplus > drop tablespace pbh including contents;

    rman> restore tablespace pbh;

    Starting restore at 10-AUG-06
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=138 devtype=DISK
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 08/10/2006 15:01:11
    RMAN-20202: tablespace not found in the recovery catalog
    RMAN-06019: could not translate tablespace name "PBH"
    This message shows that you are connecting RMAN thru target database control file and not thru recovery catalog.
    If you use recovery catalog, when you execute your backup,
    then use recovery catalog, before executing the restore command.

    If you execute your backup command using target database control file, then chances are, those entries have been aged out. And that is why your restore command no longer recognized by RMAN.
    ---------------

Posting Permissions

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



Click Here to Expand Forum to Full Width