Shulou(Shulou.com)06/01 Report--

This lab is about how to register to database and open the database after copying the ASM file to the operating system file system using the cp command.

The environment is linux5.7+oracle11.2.0.4

RMAN > catalog datafilecopy'/ s01Accord USERS.268.962900225'

Cataloged datafile copy

Datafile copy file name=/s01/oracle/USERS.268.962900225 RECID=2 STAMP=963047096

RMAN > run

2 > {

3 > set newname for datafile'+ DATA/DAVID/DATAFILE/USERS.268.962900225' to'/ s01Universe USERS.268.962900225'

4 > switch datafile all

5 >}

Executing command: SET NEWNAME

Datafile 4 switched to datafile copy

Input datafile copy RECID=2 STAMP=963047096 file name=/s01/oracle/USERS.268.962900225

RMAN > recover datafile 4

Starting recover at 18-DEC-17

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=20 device type=DISK

Starting media recovery

Media recovery complete, elapsed time: 00:00:01

Finished recover at 18-DEC-17

RMAN > exit

Recovery Manager complete.

[oracle@rac1 ~] $sqlplus / nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 18 09:06:09 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

SQL > connect / as sysdba

Connected.

SQL > alter database open

Database altered.

SQL > select file_name

2 from dba_data_files

FILE_NAME

/ s01/oracle/USERS.268.962900225

+ DATA/david/datafile/undotbs1.261.962900225

+ DATA/david/datafile/sysaux.260.962900225

+ DATA/david/datafile/system.270.962900225

+ DATA/david/datafile/example.262.962900447

SQL > select *

2 from scott.dept

DEPTNO DNAME LOC

10 ACCOUNTING NEW YORK

20 RESEARCH DALLAS

30 SALES CHICAGO

40 OPERATIONS BOSTON

SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.