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
,