• How To Import .bak File In Oracle

As a Linux sysadmin, you might recover a system from backup, which may include Oracle Database. So, it is essential for all admins to understand how to restore oracle database from backup. Typically, DBAs will use Oracle RMAN utility to take a hot backup of the database. This tutorial provides an introduction on how to restore an Oracle database from the RMAN backup. If you are new to RMAN, you should first understand how to using RMAN. For the impatient, here is a quick snippet of one particular rman restore scenario. Change this accordingly for your scenario.

Read below to understand more details about these commands. RMAN SET DBID 12345; RMAN STARTUP NOMOUNT; RMAN RESTORE CONTROLFILE FROM '/backup/rman/ctlc-1003-03'; RMAN RESTORE DATABASE; RMAN RECOVER DATABASE; RMAN ALTER DATABASE OPEN RESETLOGS; Verify Backup Location Before the restore, verify the current RMAN configuration on the server where you’ll be performing the restore.

To connect to RMAN, execute the following rman command, which will take you to the RMAN prompt. From here, you can execute all RMAN commands. $ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Mon Nov 17 11: Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to target database: DEVDB (DBID=821773) RMAN Execute “show all”, which will display all current RMAN configuration.

How To Import .bak File In Oracle

As you see below, the current RMAN backup is located under “/backup/rman” directory.