Procedure for migrating data files using RMAN (RAC-ASM environment)

Step 1: Run copycopydatafile1to In The rman window

Step 1: Run copycopy datafile 1

Homepage → Database Technology

Background:

Read News

Procedure for migrating data files using RMAN (RAC-ASM environment)

[Date: 2013-12-05] Source: Linux community Author: zhou1862324 [Font:]

To migrate data files using rman:

1. Run copy in the rman window.
Copy datafile 1 to '+ TESTDG/rac/datafile/system. dbf ';
Copy datafile 2 to '+ TESTDG/rac/datafile/sysaux. dbf ';
Copy datafile 3 to '+ TESTDG/rac/datafile/undotbs1.dbf ';
Copy datafile 4 to '+ TESTDG/rac/datafile/users. dbf ';
Copy datafile 5 to '+ TESTDG/rac/datafile/undotbs2.dbf ';

2. Disable all node instances

3. Start any node to the mount status

4. Perform the rename operation

Alter database rename file '+ DATA/rac/datafile/system.416.833384105' TO '+ TESTDG/rac/datafile/system. dbf ';
Alter database rename file '+ DATA/rac/datafile/sysaux.ux.8333820.7' TO '+ TESTDG/rac/datafile/sysaux. dbf ';
Alter database rename file '+ DATA/rac/datafile/undotbs1.418.8333820.7' TO '+ TESTDG/rac/datafile/undotbs1.dbf ';
Alter database rename file '+ DATA/rac/datafile/users.419.833384109' TO '+ TESTDG/rac/datafile/users. dbf ';
Alter database rename file '+ DATA/rac/datafile/undotbs2.20..833384491' TO '+ TESTDG/rac/datafile/undotbs2.dbf ';

5. Perform the restoration operation.
SQL> recover database;

Recommended reading:

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

0

Error ORA-01276 when executing RMAN copy

Rename datafile reports error ORA-01511, ORA-01121, ORA-01110

Related information: RMAN data migration

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2011 Linux community All rights reserved Zhejiang ICP backup No. 06018118