Migrate Oracle11gR2 database using RMAN on the Linux6.4 Platform

Source: Internet
Author: User
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

,

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.