Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Unanswered: restore datafile without backupset

    Hi All,

    I created a new database 10.2.0.1.0, took an RMAN hot backup.

    I deleted the backupset created and droped the datafile after shutting down the database.
    When I again try to open, it throws me an error in opening as expected.

    Now when I try to restore the datafile using RMAN(backupset already expired)
    , it restored the datafile after throwing an error

    MAN-03090: Starting restore at 10-JUN-10
    RMAN-06009: using target database control file instead of recovery catalog
    RMAN-08030: allocated channel: ORA_DISK_1
    RMAN-08500: channel ORA_DISK_1: sid=156 devtype=DISK

    RMAN-06064: creating datafile fno=5 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\ASHU\ASHU_1. DBF
    RMAN-06177: restore not done; all files readonly, offline, or already restored
    RMAN-03091: Finished restore at 10-JUN-10

    RMAN>

    Can anyone please help let me know, how it is possible:
    1. without backup set available.
    2.controlfile is autobackup
    3.database in archive mode

  2. #2
    Join Date
    May 2006
    Posts
    132
    I assume E:\ORACLE\PRODUCT\10.2.0\ORADATA\ASHU\ASHU_1. DBF was the file you supposedly deleted? Do you still see this file on the filesystem?

    Quote Originally Posted by ashish bahugun View Post
    Now when I try to restore the datafile using RMAN(backupset already expired)
    , it restored the datafile after throwing an error

    Can anyone please help let me know, how it is possible:
    1. without backup set available.
    So do you actually have a backup or not?

Posting Permissions

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