Actual Situation of migrating RMAN to an on-premise File System

Source: Internet
Author: User

Environment Description:

Source database: 192.168.0.10

Target Database: 192.168.0.11

 

Source database backup:

RMAN> run {

2> allocate channel c1 device type disk;

3> allocate channel c2 device type disk;

4> backup database format'/home/Oracle/full_database % U' include current controlfile;

5> SQL 'alter system archive log current ';

6> backup archivelog all format'/home/oracle/archivelog _ % U ';

7> crosscheck backup;

8> delete noprompt obsolete;

9> release channel c1;

10> release channel c2;

11>}

 

Copy the backup set to the slave database:

Scp/home/oracle/full * oracle@192.168.0.11:/home/oracle/target_bk/

Oracle@192.168.0.11:/home/oracle/archive *:/oracle/target_bk/

[Oracle @ targetdb target_bk] $ ls

Archivelog_0rnu4jbf_1_1 full_database0nnu4ja0_1_1 full_database0pnu4jb4_1_1

Archivelog_0snu4jbf_1_1 full_database0onu4ja0_1_1 full_database0qnu4jb5_1_1

 

Target database operations

[Oracle @ targetdb sourcedb] $ mkdir {a, B, c, u} dump

[Oracle @ targetdb sourcedb] $ ls

Adump bdump cdump udump

 

[Oracle @ targetdb oradata] $ mkdir sourcedb

[Oracle @ targetdb oradata] $ ls

Sourcedb

[Oracle @ targetdb oradata] $ cd sourcedb/

[Oracle @ targetdb sourcedb] $ mkdir arch

[Oracle @ targetdb sourcedb] $ ls

Arch

 

Start recovery:

Because no parameter file exists, start with rman with no Parameter

Export ORACLE_SID = sourcedb

RMAN> startup nomount;

 

Startup failure: ORA-01078: failure in processing system parameters

LRM-00109: cocould not open parameter file '/u01/oracle/product/10.2.0/dbs/initsourcedb. ora'

 

Starting Oracle instance without parameter file for retrival of spfile

Oracle instance started

 

Total System Global Area 159383552 bytes

 

Fixed Size 1218268 bytes

Variable Size 54528292 bytes

Database Buffers 100663296 bytes

Redo Buffers 2973696 bytes

 

RMAN> exit

 

Recovery Manager complete.

  • 1
  • 2
  • 3
  • 4
  • Next Page

Related Article

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.