Pular para o conteúdo

Criar uma cópia de todos os DATAFILEs com RMAN

Criar uma cópia de todos os DATAFILEs com RMAN

Ao invés de fazer um BACKUP / RESTORE, é mais fácil fazer uma cópia direta, com o COPY DATAFILE.

[oracle@nerv11 ~]$ rman TARGET /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 23 09:21:09 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1249620830)

RMAN> RUN {
2> COPY DATAFILE 1 TO '/tmp/system01.dbf';
3> COPY DATAFILE 2 TO '/tmp/sysaux01.dbf';
4> COPY DATAFILE 3 TO '/tmp/undotbs01.dbf';
5> COPY DATAFILE 4 TO '/tmp/users01.dbf';
6> COPY DATAFILE 5 TO '/tmp/example01.dbf';
7> }

Starting backup at 23-JUN-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=148 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf
output file name=/tmp/system01.dbf tag=TAG20100623T092135 RECID=8 STAMP=722424119
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
Finished backup at 23-JUN-10

Starting backup at 23-JUN-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf
output file name=/tmp/sysaux01.dbf tag=TAG20100623T092200 RECID=9 STAMP=722424139
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
Finished backup at 23-JUN-10

Starting backup at 23-JUN-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf
output file name=/tmp/undotbs01.dbf tag=TAG20100623T092225 RECID=10 STAMP=722424157
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 23-JUN-10

Starting backup at 23-JUN-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/users01.dbf
output file name=/tmp/users01.dbf tag=TAG20100623T092241 RECID=11 STAMP=722424161
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 23-JUN-10

Starting backup at 23-JUN-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/example01.NEWNAME.dbf
output file name=/tmp/example01.dbf tag=TAG20100623T092242 RECID=12 STAMP=722424165
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 23-JUN-10

RMAN> EXIT;

Recovery Manager complete.
[oracle@nerv11 ~]$ ls -lh /tmp/*.dbf
-rw-r----- 1 oracle oinstall 101M Jun 23 09:22 /tmp/example01.dbf
-rw-r----- 1 oracle oinstall 491M Jun 23 09:22 /tmp/sysaux01.dbf
-rw-r----- 1 oracle oinstall 681M Jun 23 09:21 /tmp/system01.dbf
-rw-r----- 1 oracle oinstall 306M Jun 23 09:22 /tmp/undotbs01.dbf
-rw-r----- 1 oracle oinstall 5.1M Jun 23 09:22 /tmp/users01.dbf
[oracle@nerv11 ~]$

Quão útil foi este post ?

Clique em uma estrela para classificar o post

nota média 5 / 5. Contagem de votos: 1

Sem votos ! Seja o primeiro a classificar !

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

plugins premium WordPress