Recovery as Normal Files(Oracle) - Revision history

Sachin at 12:06, 14 July 2021

2021-07-14T12:06:37Z

Sachin at 15:25, 18 May 2021

2021-05-18T15:25:00Z

Sachin at 15:23, 18 May 2021

2021-05-18T15:23:32Z

Sachin at 12:37, 18 May 2021

2021-05-18T12:37:49Z

Sachin: Created page with "The restore of Oracle data can be done from within '''RMAN''' and we restore the backup files from NetBackup to a temporary location on the Oracle server. To log in to '''RM..."

2021-05-18T10:33:21Z

Created page with "The restore of Oracle data can be done from within '''RMAN''' and we restore the backup files from NetBackup to a temporary location on the Oracle server. To log in to '''RM..."

New page

The restore of Oracle data can be done from within '''RMAN''' and we restore the backup files from NetBackup to a temporary location on the Oracle server.

To log in to '''RMAN''', type the command below into a Command Line window.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
rman target /
|}
As soon as you log in to the database, the DBID currently in use will be displayed.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Nov 9 11:53:46 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1490584423)

RMAN>
|}
__NOTOC__

==='''Step 2'''===
From Netbackup restore the Oracle backup as files, and then copy them to a temporary location on the Oracle server.

[[File:Restore_Oracle_Files.jpg]]

In our example, we have copied them to the location of '''"C:\Backup\Oracle"'''.

==='''Step 3'''===
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
RMAN> STARTUP NOMOUNT;
|}

==='''Step 4'''===
Restore the control file.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
RMAN> REPLICATE CONTROLFILE FROM "C:\Backup\Oracle\ctrl_ORCL_2924.dbf";
|}

Restore of control file changes the DBID to the target DBID. Run a select DBID from v$database; from SQL to verify that.

==='''Step 5'''===
Mount the database.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
RMAN> ALTER DATABASE MOUNT;
|}

==='''Step 6'''===
Configure sbt device.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
RMAN> CONFIGURE DEVICE TYPE sbt_tape PARALLELISM 1;
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt_tape PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=C:\Backup\Oracle)';
|}

==='''Step 7'''===
Catalog each of the dbf files in turn.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_10%3A962806106%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_11%3A977481621%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_12%3A977481656%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_16%3A977491557%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_17%3A977491557%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_18%3A977491557%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_19%3A977491557%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_2%3A962805087%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_20%3A977491575%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_21%3A977491602%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_22%3A977491602%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_23%3A977492038%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_24%3A977492038%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_25%3A977492038%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_26%3A977492046%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_27%3A977492058%3A1%3E.dbf';
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_9%3A962806071%3A1%3E.dbf';
|}

==='''Step 8'''===
Do a crosscheck backup files on disk with entries in the catalog or controlfile.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
RMAN> CROSSCHECK BACKUP;
|}

==='''Step 9'''===
Restore the database.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
RMAN> RESTORE DATABASE;
|}

==='''Step 10'''===
Perform this step if redo of all online datafiles needs to be applied.

{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
|
RMAN> RECOVER DATABASE;
|}

----
Use this link to go back to the main [[recoverydocs]] Page.

@@ Line 1: / Line 1: @@
 Below documentation shows how to restore Oracle data after it has been recovered as normal files using steps as shown in [[ Recovery as Normal Files(FileSystem) | Recovery as Normal Files ]].
-Please recover the Oracle database files (mdf's). Once you have the files, please follow the steps to restore.
+Please recover the Oracle files (dbf's). Once you have the files, please follow the steps to restore.
 The restore of Oracle data can be done from within '''RMAN''' and we restore the backup files from NetBackup to a temporary location on the Oracle server.

← Older revision		Revision as of 12:37, 18 May 2021
Line 21:		Line 21:
	__NOTOC__		__NOTOC__

−
−	~~==='''Step 2'''===~~
−	~~From Netbackup restore the Oracle backup as files, and then copy them to a temporary location on the Oracle server.~~
−
−	~~[[File:Restore_Oracle_Files.jpg]]~~
−
−	~~In our example, we have copied them to the location of '''"C:\Backup\Oracle"'''.~~

	==='''Step 3'''===		==='''Step 3'''===

@@ Line 106: / Line 106: @@
 |}
-----
-Use this link to go back to the main [[recoverydocs]] Page.

@@ Line 1: / Line 1: @@
 The restore of Oracle data can be done from within '''RMAN''' and we restore the backup files from NetBackup to a temporary location on the Oracle server.
@@ Line 22: / Line 25: @@
-==='''Step 3'''===
+==='''Step 1'''===
 {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
+|
@@ Line 28: / Line 31: @@
 |}
-==='''Step 4'''===
+==='''Step 2'''===
 Restore the control file.
@@ Line 38: / Line 41: @@
 Restore of control file changes the DBID to the target DBID. Run a select DBID from v$database; from SQL to verify that.
-==='''Step 5'''===
+==='''Step 3'''===
 Mount the database.
@@ Line 46: / Line 49: @@
 |}
-==='''Step 6'''===
+==='''Step 4'''===
 Configure sbt device.
@@ Line 55: / Line 58: @@
 |}
-==='''Step 7'''===
+==='''Step 5'''===
 Catalog each of the dbf files in turn.
@@ Line 79: / Line 82: @@
 |}
-==='''Step 8'''===
+==='''Step 6'''===
 Do a crosscheck  backup files on disk with entries in the catalog or controlfile.
@@ Line 87: / Line 90: @@
 |}
-==='''Step 9'''===
+==='''Step 7'''===
 Restore the database.
@@ Line 95: / Line 98: @@
 |}
-==='''Step 10'''===
+==='''Step 8'''===
 Perform this step if redo of all online datafiles needs to be applied.