Tuesday, 31 December 2013

RMAN copy command

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\UserXP>cd\

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: KUMAR (DBID=1995632557)

RMAN>


RMAN> report schema;

Report of database schema
File K-bytes    Tablespace           RB segs Datafile Name
---- ---------- -------------------- ------- -------------------
1        419840 SYSTEM               ***     E:\ORACLE\ORADATA\KUMAR\SYSTEM01.DB
F
2        204800 UNDOTBS1             ***     E:\ORACLE\ORADATA\KUMAR\UNDOTBS01.D
BF
3         20480 CWMLITE              ***     E:\ORACLE\ORADATA\KUMAR\CWMLITE01.D
BF
4         20480 DRSYS                ***     E:\ORACLE\ORADATA\KUMAR\DRSYS01.DBF

5        152320 EXAMPLE              ***     E:\ORACLE\ORADATA\KUMAR\EXAMPLE01.D
BF
6         25600 INDX                 ***     E:\ORACLE\ORADATA\KUMAR\INDX01.DBF
7         20480 ODM                  ***     E:\ORACLE\ORADATA\KUMAR\ODM01.DBF
8        100160 TOOLS                ***     E:\ORACLE\ORADATA\KUMAR\TOOLS01.DBF

9         25600 USERS                ***     E:\ORACLE\ORADATA\KUMAR\USERS01.DBF

10        39040 XDB                  ***     E:\ORACLE\ORADATA\KUMAR\XDB01.DBF
11        35848 OEM_REPOSITORY       ***     E:\ORACLE\ORADATA\KUMAR\OEM_REPOSIT
ORY.DBF

RMAN> copy datafile 7 to 'c:\backup\odm01.dbf',
2>  datafile 10 to 'c:\backup\xdm01.dbf';

Starting copy at 14-FEB-10
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: copied datafile 7
output filename=C:\BACKUP\ODM01.DBF recid=7 stamp=710963147
channel ORA_DISK_2: copied datafile 10
output filename=C:\BACKUP\XDM01.DBF recid=8 stamp=710963148
Finished copy at 14-FEB-10

RMAN>

No comments:

Post a Comment