Oracle 11g中如何恢复.bak备份文件？Oracle新手求助

Hey there! Since you're new to Oracle 11g, let's break this down clearly—first, we need to figure out what type of .bak file you're working with, because Oracle uses a few different backup methods, and the restore steps change based on that. Here are the two most common scenarios:

Scenario 1: The .bak is an RMAN Backup (Oracle's Native Backup Tool) #

RMAN is Oracle's default backup utility, so this is the most likely case if the backup was created with Oracle's built-in tools. Follow these steps:

• Step 1: Prepare your environment
  Make sure your target Oracle 11g installation matches the version of the database that was backed up (same release and patch level). Also, ensure you have enough disk space to restore the database.

• Step 2: Start the database in NOMOUNT mode
  Open SQL*Plus as a privileged user (like sysdba):

  sqlplus / as sysdba
  startup nomount;
  

• Step 3: Restore the control file (if needed)
  If you don't have an existing control file for the database, restore it from your .bak file using RMAN:

  rman target /
  restore controlfile from '/full/path/to/your/backup.bak';
  

  Then mount the database:

  alter database mount;
  

• Step 4: Restore and recover the database
  Still in RMAN, run these commands:

  restore database from '/full/path/to/your/backup.bak';
  recover database;
  

• Step 5: Open the database
  If you're restoring to a new environment or doing an incomplete recovery, use:

  alter database open resetlogs;
  

  If you're restoring to the original database (same server, same setup), you can use:

  alter database open;
  

Scenario 2: The .bak is an Export File (exp/expdp) #

Sometimes people rename Oracle export files (usually .dmp) to .bak. These are logical backups (they contain data and schema objects, not raw database files). Here's how to restore them:

• If it's an old-style exp export:
  Use the imp utility. Open a command prompt and run:

  imp your_username/your_password file=/full/path/to/your/backup.bak full=y
  

  • full=y imports everything from the backup; if you only need specific objects, you can adjust this flag.

• If it's a Data Pump (expdp) export:
  Use the impdp utility. Run:

  impdp your_username/your_password dumpfile=/full/path/to/your/backup.bak full=y
  

  • Note: For Data Pump, you might need to create a directory object first if the backup isn't in Oracle's default directory. You can do this in SQL*Plus:

    create directory backup_dir as '/full/path/to/backup/folder';
    grant read, write on directory backup_dir to your_username;
    

    Then add directory=backup_dir to the impdp command.

Important Tips for Beginners #

• Always use absolute paths (like /u01/oracle/backups/backup.bak) instead of relative paths—this avoids confusion about where Oracle is looking for files.
• Before restoring, back up any existing data in your target database to avoid accidental data loss.
• If your .bak file was created with a third-party backup tool (like Windows Server Backup or other non-Oracle software), you'll need to use that same tool to restore the files first, then use Oracle tools to recover the database.

内容的提问来源于stack exchange，提问作者Revathi Vijay