Migrate Oracle11gR2 database using RMAN on the Linux6.4 Platform

Migrate Oracle11gR2 database using RMAN on the Linux6.4 Platform

Migrate Oracle 11g R2 database using RMAN on Linux 6.4

Host A and host B are installed in the testing environment respectively.
Operating System: linux 6.4,
Database: Oracle 11g r2
Host A: Install the oracle 11g r2 Database
Host B: Only oracle 11g r2 software is installed

Step 1: run the following rman command to back up the database
Run {
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to '/u01/app/dbback/config _ % F ';
Allocate channel c1 type disk format'/u01/app/dbback/full _ % U ';
Backup database tag 'full _ gpodb_data 'FILESPERSET 10 plus archivelog filesperset 20 delete all input;
Release channel c1;
}


[Root @ bogon ~] # Su-oracle
[Oracle @ bogon ~] $ Rman target/

Recovery Manager: Release 11.2.0.1.0-Production on Sat Oct 26 05:16:55 2013

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

Connected to target database: DB (DBID = 1587060738) ------------ remember this DBID will be used to restore the database
RMAN> run {
2> configure controlfile autobackup on;
3> configure controlfile autobackup format for device type disk to '/u01/app/dbback/config _ % F ';
4> allocate channel c1 type disk format'/u01/app/dbback/full _ % U ';
5> backup database tag 'full _ gpodb_data 'FILESPERSET 10 plus archivelog filesperset 20 delete all input;
6> release channel c1;
7>}

Old RMAN configuration parameters:
Configure controlfile autobackup on;
New RMAN configuration parameters:
Configure controlfile autobackup on;
New RMAN configuration parameters are successfully stored

Old RMAN configuration parameters:
Configure controlfile autobackup format for device type disk to '/u01/app/dbback/gpofullbak/% F ';
New RMAN configuration parameters:
Configure controlfile autobackup format for device type disk to '/u01/app/dbback/config _ % F ';
New RMAN configuration parameters are successfully stored

Allocated channel: c1
Channel c1: SID = 47 device type = DISK


Starting backup at 26-OCT-13
Current log archived
Channel c1: starting archived log backup set
Channel c1: specifying archived log (s) in backup set
Input archived log thread = 1 sequence = 21 RECID = 12 STAMP = 829805117
Channel c1: starting piece 1 at 26-OCT-13
Channel c1: finished piece 1 at 26-OCT-13
Piece handle =/u01/app/dbback/full_08onbkhu_1_1 tag = TAG20131026T052518 comment = NONE
Channel c1: backup set complete, elapsed time: 00:00:01
Channel c1: deleting archived log (s)
Archived log file name =/u01/app/archiv/export 21_823244933.dbf RECID = 12 STAMP = 829805117
Finished backup at 26-OCT-13

Starting backup at 26-OCT-13
Channel c1: starting full datafile backup set
Channel c1: specifying datafile (s) in backup set
Input datafile file number = 00001 name =/u01/app/oracle/oradata/db/system01.dbf
Input datafile file number = 00002 name =/u01/app/oracle/oradata/db/sysaux01.dbf
Input datafile file number = 00005 name =/u01/app/oracle/oradata/db/anfei01.dbf
Input datafile file number = 00003 name =/u01/app/oracle/oradata/db/undotbs01.dbf
Input datafile file number = 00006 name =/u01/app/oracle/oradata/db/DB/datafile/o1_mf_dbs_91x4vt9f _. dbf
Input datafile file number = 00007 name =/u01/app/oracle/oradata/db/dbt. dbf
Input datafile file number = 00004 name =/u01/app/oracle/oradata/db/users01.dbf
Channel c1: starting piece 1 at 26-OCT-13
Channel c1: finished piece 1 at 26-OCT-13
Piece handle =/u01/app/dbback/full_09onbkhv_1_1 tag = FULL_GPODB_DATA comment = NONE
Channel c1: backup set complete, elapsed time: 00:01:36
Finished backup at 26-OCT-13

Starting backup at 26-OCT-13
Current log archived
Channel c1: starting archived log backup set
Channel c1: specifying archived log (s) in backup set
Input archived log thread = 1 sequence = 22 RECID = 13 STAMP = 829805216
Channel c1: starting piece 1 at 26-OCT-13
Channel c1: finished piece 1 at 26-OCT-13
Piece handle =/u01/app/dbback/full_0aonbkl1_1_1 tag = TAG20131026T052657 comment = NONE
Channel c1: backup set complete, elapsed time: 00:00:01
Channel c1: deleting archived log (s)
Archived log file name =/u01/app/archiv/export 22_823244933.dbf RECID = 13 STAMP = 829805216
Finished backup at 26-OCT-13

Starting Control File and SPFILE Autobackup at 26-OCT-13
Piece handle =/u01/app/dbback/config_c-1587060738-20131026-01 comment = NONE
Finished Control File and SPFILE Autobackup at 26-OCT-13

Released channel: c1

RMAN>

For more details, please continue to read the highlights on the next page:

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

,