RMAN:Restore datafiles to Nondefault location

You have just experiences a serious media failure and won't able to restore datafiles to their original location.In this case, you need to restore datafiles to a nondafault location.

You can use set newname and switch commands to restore datafiles to nondefault locations. You must set newaname command and the switch command from within a run{} block.
The switch command updates the target database controlfile with new location of the datafile. It's OK to use switch datafile all, which updates all datafile locations.

If you are performing Point in time recovery (POITR) ensure you switch datafiles before you perform the recovery.

You can read from http://mohamedazar.wordpress.com/2010/09/01/rman-restoring-datafile...

Now we can see the examples.
I have created one tablespace.Its name TEST with two datafiles test01.dbf,test02.dbf
The location is

C:\APP\MAZAR\ORADATA\OWN\TEST01.DBF (6) --> C:\APP\MAZAR\ORADATA\OWN\new\TEST01.DBF (Target new location)

C:\APP\MAZAR\ORADATA\OWN\TEST02.DBF (7) --> C:\APP\MAZAR\ORADATA\OWN\new\TEST02.DBF (Target new location)


6,7 Datafile ID

startup mount stage

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1046224896 bytes
Fixed Size 1379212 bytes
Variable Size 167773300 bytes
Database Buffers 872415232 bytes
Redo Buffers 4657152 bytes
Database mounted.
SQL> host
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\mazar>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Sep 1 11:31:13 2010

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

connected to target database: OWN (DBID=1547349083, not open)

RMAN> run{
2> set newname for datafile 6 to 'C:\APP\MAZAR\ORADATA\OWN\new/test01.dbf';
3> set newname for datafile 7 to 'C:\APP\MAZAR\ORADATA\OWN\new\test02.dbf';
4> restore tablespace "TEST";
5> switch datafile all;
6> recover tablespace "TEST";
7> alter database open;
8> }

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 01-SEP-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00006 to C:\APP\MAZAR\ORADATA\OWN\new/tes
t01.dbf
channel ORA_DISK_1: restoring datafile 00007 to C:\APP\MAZAR\ORADATA\OWN\new\tes
t02.dbf
channel ORA_DISK_1: reading from backup piece C:\APP\MAZAR\FLASH_RECOVERY_AREA\O
WN\BACKUPSET\2010_09_01\O1_MF_NNNDF_TAG20100901T112433_67W3G28B_.BKP
channel ORA_DISK_1: piece handle=C:\APP\MAZAR\FLASH_RECOVERY_AREA\OWN\BACKUPSET\
2010_09_01\O1_MF_NNNDF_TAG20100901T112433_67W3G28B_.BKP tag=TAG20100901T112433
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 01-SEP-10

datafile 6 switched to datafile copy
input datafile copy RECID=3 STAMP=728566586 file name=C:\APP\MAZAR\ORADATA\OWN\N
EW\TEST01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=728566586 file name=C:\APP\MAZAR\ORADATA\OWN\N
EW\TEST02.DBF

Starting recover at 01-SEP-10
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 01-SEP-10

database opened

If the database is open, you can place the datafile offline and then set their new names for restore and recovery.

RMAN> run{
2> sql 'alter database datafile 6,7 offline';
3> set newname for datafile 6 to 'C:\APP\MAZAR\ORADATA\OWN\new\test01.dbf';
4> set newname for datafile 7 to 'C:\APP\MAZAR\ORADATA\OWN\new\test02.dbf';
5> restore datafile 6,7;
6> switch datafile all;
7> recover datafile 6,7;
8> sql 'alter database datafile 6,7 online';
9> }

sql statement: alter database datafile 6,7 offline

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 01-SEP-10
using channel ORA_DISK_1

channel ORA_DISK_1: restoring datafile 00006
input datafile copy RECID=5 STAMP=728566586 file name=C:\APP\MAZAR\ORADATA\OWN\T
EST01.DBF
destination for restore of datafile 00006: C:\APP\MAZAR\ORADATA\OWN\new\test01.d
bf
channel ORA_DISK_1: copied datafile copy of datafile 00006
output file name=C:\APP\MAZAR\ORADATA\OWN\NEW\TEST01.DBF RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00007
input datafile copy RECID=6 STAMP=728566586 file name=C:\APP\MAZAR\ORADATA\OWN\T
EST02.DBF
destination for restore of datafile 00007: C:\APP\MAZAR\ORADATA\OWN\new\test02.d
bf
channel ORA_DISK_1: copied datafile copy of datafile 00007
output file name=C:\APP\MAZAR\ORADATA\OWN\NEW\TEST02.DBF RECID=0 STAMP=0
Finished restore at 01-SEP-10
Starting recover at 01-SEP-10
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 01-SEP-10

sql statement: alter database datafile 6,7 online

RMAN>

You can check the new datafiles locations using report schema command.

RMAN> report schema;

Report of database schema for database with db_unique_name OWN

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 700 SYSTEM *** C:\APP\MAZAR\ORADATA\OWN\SYSTEM01.DBF

2 600 SYSAUX *** C:\APP\MAZAR\ORADATA\OWN\SYSAUX01.DBF

3 500 UNDOTBS1 *** C:\APP\MAZAR\ORADATA\OWN\UNDOTBS01.DBF
4 5 USERS *** C:\APP\MAZAR\ORADATA\OWN\USERS01.DBF
5 100 RMAN001 *** C:\APP\MAZAR\ORADATA\OWN\RMAN01.DBF
6 100 TEST *** C:\APP\MAZAR\ORADATA\OWN\NEW\TEST01.DBF
7 100 TEST *** C:\APP\MAZAR\ORADATA\OWN\NEW\TEST02.DBF

and also you can check from v$datafile view.

Views: 2742

Comment

You need to be a member of Oracle Community to add comments!

Join Oracle Community

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Why you Should Include Push Notifications in your Mobile App?

Push notifications are a display of your application’s icon and a message in the status bar of your device. We stress the importance of including push notifications in your mobile application for three major reasons:-

  1. Push Notifications allow direct marketing to your clients: When a customer downloads your application and enables push notification, it gives you direct…

Continue

Posted by Alvaro Dee on August 23, 2016 at 10:50pm

Amazon Virtual Assistant Services for Efficient e-store Management

Virtual assistant (VA) is a term that has been buzzing around in the business world for quite some time now. Essentially, a VA is skilled administrator who takes care of your technical/creative business support activities while working offsite. If you already have a designated eCommerce store on Amazon seller central or wish to start one, an Amazon VA will help you manage the store and update it regularly with utmost precision.

Amazon VA creates and updates the…

Continue

Posted by Alvaro Dee on August 23, 2016 at 2:56am

What to Expect When Investing in Data Cleansing Services?

Why invest in data cleansing services?

Imagine a scenario- You are maintaining huge databases containing information about your potential customers and you are all geared up with next direct mailing campaigns. After promotional mailers have been sent, you realize the fact that the major part of your database actually contained supplier information.

Such blunders can happen anytime and can…

Continue

Posted by Alvaro Dee on July 25, 2016 at 11:30pm

Avail Affordable and Specialized Android Games Development Services

Cellular gaming has become hugely popular in the last few years. With cellular gaming and amazing features of the Android operating system mixed together, the demand for Android games development services has increased drastically. Gaming becomes fun on Android based Smartphones with its great features getting the users hooked from the word go!

Android supports clarity…

Continue

Posted by Alvaro Dee on July 24, 2016 at 10:47pm

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service