DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rman Restore

  1. #1
    Join Date
    Nov 2003
    Location
    Brasil -
    Posts
    16

    Question Rman Restore

    Hi all,
    I was performing restore tests in my Oracle 9i server. With RMAN, I backup a tablespace 'EXAMPLE' in the file 'example.bak'. Then I dropped the table 'jobs', off user 'hr', in tablespace 'EXAMPLE'. After that I restored the tablespace 'EXAMPLE', but the table was not restored, and the restore script did not returned any error. There goes the backup and restore script:
    # backup script
    Run {
    allocate channel canaldefault device type disk format'd:\EXAMPLE.bak';
    backup (tablespace 'EXAMPLE'); }

    #restore script
    SQL "ALTER TABLESPACE EXAMPLE OFFLINE for restore";
    run {
    allocate channel canaldefault device type disk format'd:\EXAMPLE.bak';
    restore (Tablespace 'EXAMPLE');
    recover tablespace 'EXAMPLE';}
    SQL "ALTER TABLESPACE EXAMPLE ONLINE";

    Is there something wrong with my script? How can I make a 'restorable' backup?

    Since now thanks, Pvaliati.
    Pedro Valiati - Brasil

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    #restore script
    SQL "ALTER TABLESPACE EXAMPLE OFFLINE for restore";
    run {
    allocate channel canaldefault device type disk format'd:\EXAMPLE.bak';
    restore (Tablespace 'EXAMPLE');
    recover tablespace 'EXAMPLE';}
    SQL "ALTER TABLESPACE EXAMPLE ONLINE";

    You are doing a complete recovery. Do a PIT recovery.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Nov 2003
    Location
    Brasil -
    Posts
    16
    OK...Could you explain what PIT recovery is? Do you have any example?
    Thanks. Pvaliati
    Pedro Valiati - Brasil

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Point-in-time recovery.
    Read this..
    http://download-west.oracle.com/docs...spi.htm#443831
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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