Menu de navegação

[vieriParticipante]

Caros,

estou restaurando um ambiente de testes.

O meu restore possui os seguintes pontos:

1)Base archivelog.
2)Backupfull sem cataloo.
2)Restore em outro servidor s.o e bd mesma versão…
tudo redondo exceto que a estrutura dedireórios que quero
restaurar os datafiles é diferente no destino… at´ai td bem.. seguindo
as recomnaçções basta user o set newname seguido do switch datafile all, mas… 🙁 … nada feito… toma-lhe erro.

Alguem pode me ajudar nesse how to(cenârio) de restore.

meu script :

CONNECT TARGET /
STARTUP NOMOUNT
SET DBID=428367008;
RESTORE CONTROLFILE FROM ‘/u03/wis/full_wis_692811273_2’;
ALTER DATABASE MOUNT;
RUN {
ALLOCATE CHANNEL C1 DEVICE TYPE DISK;
ALLOCATE CHANNEL C2 DEVICE TYPE DISK;
ALLOCATE CHANNEL C3 DEVICE TYPE DISK;
ALLOCATE CHANNEL C4 DEVICE TYPE DISK;
SET UNTIL SEQUENCE 1184 THREAD 1;
set newname for datafile 1 to ‘/u03/wis/system01.dbf’;
set newname for datafile 2 to ‘/u03/wis/undotbs1.dbf’;
set newname for datafile 3 to ‘/u03/wis/sysauy01.dbf’;
set newname for datafile 4 to ‘/u03/wis/data_entrega.dbf’;
set newname for datafile 5 to ‘/u03/wis/data_entrega_small.dbf’;
set newname for datafile 6 to ‘/u03/wis/gkoscf_dtau.dbf’;
set newname for datafile 7 to ‘/u03/wis/gkoscf_inau.dbf’;
set newname for datafile 8 to ‘/u03/wis/gkoscf_indy.dbf’;
set newname for datafile 9 to ‘/u03/wis/indy_entrega.dbf’;
set newname for datafile 10 to ‘/u03/wis/tbs_data_asstec.dbf’;
set newname for datafile 11 to ‘/u03/wis/tbs_data_cestqhist_32m.dbf’;
set newname for datafile 12 to ‘/u03/wis/tbs_data_detprep_32m.dbf’;
set newname for datafile 13 to ‘/u03/wis/tbs_data_hist_256k.dbf’;
set newname for datafile 14 to ‘/u03/wis/tbs_data_hist_32m.dbf’;
set newname for datafile 15 to ‘/u03/wis/tbs_data_hist_5m.dbf’;
set newname for datafile 16 to ‘/u03/wis/tbs_data_hist_64m.dbf’;
set newname for datafile 17 to ‘/u03/wis/tbs_data_inet.dbf’;
set newname for datafile 18 to ‘/u03/wis/tbs_data_sge.dbf’;
set newname for datafile 19 to ‘/u03/wis/tbs_data_trcmovestq_64m.dbf’;
set newname for datafile 20 to ‘/u03/wis/tbs_data_wis_256k.dbf’;
set newname for datafile 21 to ‘/u03/wis/tbs_data_wis_32m.dbf’;
set newname for datafile 22 to ‘/u03/wis/tbs_data_wis_5m.dbf’;
set newname for datafile 23 to ‘/u03/wis/tbs_indy_asstec.dbf’;
set newname for datafile 24 to ‘/u03/wis/tbs_indy_cestqhist_32m.dbf’;
set newname for datafile 25 to ‘/u03/wis/tbs_indy_detprep__32m.dbf’;
set newname for datafile 26 to ‘/u03/wis/tbs_indy_hist_256k.dbf’;
set newname for datafile 27 to ‘/u03/wis/tbs_indy_inet.dbf’;
set newname for datafile 28 to ‘/u03/wis/tbs_indy_sge.dbf’;
set newname for datafile 29 to ‘/u03/wis/tbs_indy_trcmovestq_64m.dbf’;
set newname for datafile 30 to ‘/u03/wis/tbs_indy_wis_256k.dbf’;
set newname for datafile 31 to ‘/u03/wis/tbs_indy_wis_32m.dbf’;
set newname for datafile 32 to ‘/u03/wis/tbs_indy_wis_5m.dbf’;
set newname for datafile 33 to ‘/u03/wis/tools.dbf’;
set newname for datafile 34 to ‘/u03/wis/undotbs2.dbf’;
set newname for datafile 35 to ‘/u03/wis/users.dbf’;
set newname for datafile 36 to ‘/u03/wis/gkoscf_data.dbf’;
RESTORE DATABASE;
RECOVER DATABASE ;
switch datafile all;
ALTER DATABASE OPEN RESETLOGS;
}

LOG de erro:

Oracle instance started

Total System Global Area 536870912 bytes

Fixed Size 1262788 bytes
Variable Size 155192124 bytes
Database Buffers 373293056 bytes
Redo Buffers 7122944 bytes

RMAN> set newname for datafile 29 to ‘/u03/wis/tbs_indy_trcmovestq_64m.dbf’;
set newname for datafile 30 to ‘/u03/wis/tbs_indy_wis_256k.dbf’;
set newname for datafile 31 to ‘/u03/wis/tbs_indy_wis_32m.dbf’;
set newname for datafile 32 to ‘/u03/wis/tbs_indy_wis_5m.dbf’;
set newname for datafile 33 to ‘/u03/wis/tools.dbf’;
set newname for datafile 34 to ‘/u03/wis/undotbs2.dbf’;
set newname for datafile 35 to ‘/u03/wis/users.dbf’;
set newname for datafile 36 to ‘/u03/wis/gkoscf_data.dbf’;
RESTORE DATABASE;
RECOVER DATABASE ;
switch datafile all;
ALTER DATABASE OPEN RESETLOGS;

executing command: SET DBID

RMAN>
Starting restore at 23-JUL-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u03/wis/control01.ctl
output filename=/u03/wis/control02.ctl
Finished restore at 23-JUL-09

RMAN>
database mounted
released channel: ORA_DISK_1

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> }

12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47>
allocated channel: C1
channel C1: sid=157 devtype=DISK

allocated channel: C2
channel C2: sid=156 devtype=DISK

allocated channel: C3
channel C3: sid=154 devtype=DISK

allocated channel: C4
channel C4: sid=153 devtype=DISK

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 23-JUL-09

creating datafile fno=1 name=/u03/wis/system01.dbf
released channel: C1
released channel: C2
released channel: C3
released channel: C4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/23/2009 12:30:27
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘/u02/oracle/oradata/wis/system01.dbf’

não possuo filsyste /u02 , não quero que ele restaure os datafles
neste patch, quero no patch ‘/u03/wis/’.

Alguem tem alguma idéia ????

obs: meu diretóro está ok.

drwxr-xr-x 3 oracle oinstall 8192 Jul 23 12:30 wis

[oracle@admbidev wis]$ pwd
/u03/wis

😯

[David SiqueiraParticipante]

Vieri achei essa nota aqui, veja se te ajuda :

http://www.experts-exchange.com/Database/Oracle/10.x/Q_22632490.html

Abraços.

[vieriParticipante]

nesse site ele diz para usar o mesmo diretório ara o restore

não disse nada.. 😮

[David SiqueiraParticipante]

De volta a prancheta então..!!!! 😕

Abraços

[Rodrigo AlmeidaParticipante]

Uma pequena mudança no seu script vai fazer a diferença!!!

RUN {
ALLOCATE CHANNEL C1 DEVICE TYPE DISK;
ALLOCATE CHANNEL C2 DEVICE TYPE DISK;
ALLOCATE CHANNEL C3 DEVICE TYPE DISK;
ALLOCATE CHANNEL C4 DEVICE TYPE DISK;
SET UNTIL SEQUENCE 1184 THREAD 1;
set newname for datafile 1 to ‘/u03/wis/system01.dbf’;
set newname for datafile 2 to ‘/u03/wis/undotbs1.dbf’;
set newname for datafile 3 to ‘/u03/wis/sysauy01.dbf’;
set newname for datafile 4 to ‘/u03/wis/data_entrega.dbf’;
set newname for datafile 5 to ‘/u03/wis/data_entrega_small.dbf’;
set newname for datafile 6 to ‘/u03/wis/gkoscf_dtau.dbf’;
set newname for datafile 7 to ‘/u03/wis/gkoscf_inau.dbf’;
set newname for datafile 8 to ‘/u03/wis/gkoscf_indy.dbf’;
set newname for datafile 9 to ‘/u03/wis/indy_entrega.dbf’;
set newname for datafile 10 to ‘/u03/wis/tbs_data_asstec.dbf’;
set newname for datafile 11 to ‘/u03/wis/tbs_data_cestqhist_32m.dbf’;
set newname for datafile 12 to ‘/u03/wis/tbs_data_detprep_32m.dbf’;
set newname for datafile 13 to ‘/u03/wis/tbs_data_hist_256k.dbf’;
set newname for datafile 14 to ‘/u03/wis/tbs_data_hist_32m.dbf’;
set newname for datafile 15 to ‘/u03/wis/tbs_data_hist_5m.dbf’;
set newname for datafile 16 to ‘/u03/wis/tbs_data_hist_64m.dbf’;
set newname for datafile 17 to ‘/u03/wis/tbs_data_inet.dbf’;
set newname for datafile 18 to ‘/u03/wis/tbs_data_sge.dbf’;
set newname for datafile 19 to ‘/u03/wis/tbs_data_trcmovestq_64m.dbf’;
set newname for datafile 20 to ‘/u03/wis/tbs_data_wis_256k.dbf’;
set newname for datafile 21 to ‘/u03/wis/tbs_data_wis_32m.dbf’;
set newname for datafile 22 to ‘/u03/wis/tbs_data_wis_5m.dbf’;
set newname for datafile 23 to ‘/u03/wis/tbs_indy_asstec.dbf’;
set newname for datafile 24 to ‘/u03/wis/tbs_indy_cestqhist_32m.dbf’;
set newname for datafile 25 to ‘/u03/wis/tbs_indy_detprep__32m.dbf’;
set newname for datafile 26 to ‘/u03/wis/tbs_indy_hist_256k.dbf’;
set newname for datafile 27 to ‘/u03/wis/tbs_indy_inet.dbf’;
set newname for datafile 28 to ‘/u03/wis/tbs_indy_sge.dbf’;
set newname for datafile 29 to ‘/u03/wis/tbs_indy_trcmovestq_64m.dbf’;
set newname for datafile 30 to ‘/u03/wis/tbs_indy_wis_256k.dbf’;
set newname for datafile 31 to ‘/u03/wis/tbs_indy_wis_32m.dbf’;
set newname for datafile 32 to ‘/u03/wis/tbs_indy_wis_5m.dbf’;
set newname for datafile 33 to ‘/u03/wis/tools.dbf’;
set newname for datafile 34 to ‘/u03/wis/undotbs2.dbf’;
set newname for datafile 35 to ‘/u03/wis/users.dbf’;
set newname for datafile 36 to ‘/u03/wis/gkoscf_data.dbf’;
RESTORE DATABASE;
switch datafile all;
RECOVER DATABASE ;
ALTER DATABASE OPEN RESETLOGS;
}

Posta o resultado depois!

Abraços,

Rodrigo Almeida

[vieriParticipante]

Nada Rodrigo 😯 ,
mesmo erro.

Eu não consigo fazer o switch por nada desse mundo…

Alguma outra idéia ?

executing command: SET DBID

RMAN>
Starting restore at 23-JUL-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u03/wis/control01.ctl
output filename=/u03/wis/control02.ctl
Finished restore at 23-JUL-09

RMAN>
database mounted
released channel: ORA_DISK_1

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47>
allocated channel: C1
channel C1: sid=157 devtype=DISK

allocated channel: C2
channel C2: sid=156 devtype=DISK

allocated channel: C3
channel C3: sid=154 devtype=DISK

allocated channel: C4
channel C4: sid=153 devtype=DISK

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 23-JUL-09

creating datafile fno=1 name=/u03/wis/system01.dbf
released channel: C1
released channel: C2
released channel: C3
released channel: C4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/23/2009 14:03:59
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘/u02/oracle/oradata/wis/system01.dbf’

[Rodrigo AlmeidaParticipante]

Vieri,

Faz um teste rápido. Substitui SWITCH DATAFILE ALL por SWITCH DATAFILE 1.

E vamos ver se o erro é no momento da criação do 2.

Abraços,

Rodrigo Almeida

[Rodrigo AlmeidaParticipante]

Esqueci do resto do comando, segue.

SWITCH DATAFILE ‘/u02/?/system.dbf’ TO DATAFILECOPY ‘/u03/?/system.dbf’;

Abraços,

Rodrigo Almeida

[vieriParticipante]

Rodrigo,

mesma coisa…

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 23-JUL-09

creating datafile fno=1 name=/u03/wis/system01.dbf
released channel: C1
released channel: C2
released channel: C3
released channel: C4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/23/2009 14:26:04
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘/u02/oracle/oradata/wis/system01.dbf’

😯

comando switch não é apenas quando estou usando catalogo ?

🙄

obrigado,
Vieri

[Rodrigo AlmeidaParticipante]

Vieri,

Quais as permissões nos BSs?
E os novos diretorios estão criados com o usuários ORACLE e grupo OINSTALL|DBA?

Passa um chmod 777 para os BSs.

Abraços,

Rodrigo Almeida

[Rodrigo AlmeidaParticipante]

Vieri,

Conecta no rman com target / e executa um crosscheck.

O seu controlfile não está validando os novos caminhos!!!

RMAN> CROSSCHECK backup;
RMAN> CROSSCHECK backup of database;
RMAN> CROSSCHECK backup of controlfile;
RMAN> CROSSCHECK archivelog all;

Abraços,

Rodrigo Almeida

[Rodrigo AlmeidaParticipante]

Estava esquencedo…

Depois do crosscheck seus backups vão estar indisponiveis, você então deverá catalogar os BS para ele ler o seu novo caminho. EXEMPLO:

RMAN> catalog backuppiece ”;

Faça isso para todos os bs que foi gerado do seu backup!!!

Manda um list backup of database summary para verificar.

Abraços,

Rodrigo Almeida

[vieriParticipante]

Vamos lá:

diretórios:

drwxr-xr-x 3 oracle oinstall 8192 Jul 23 14:25 wis
chmod 777 /u03/wis
drwxrwxrwx 3 oracle oinstall 8192 Jul 23 14:25 wis

drwxrwx— 12 oracle oinstall 4096 Jul 21 13:35 u03
chmod 777 u03
drwxrwxrwx 12 oracle oinstall 4096 Jul 21 13:35 u03

está ok né ?

mesmo erro :

creating datafile fno=1 name=/u03/wis/system01.dbf
released channel: C1
released channel: C2
released channel: C3
released channel: C4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/23/2009 14:57:00
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘/u02/oracle/oradata/wis/system01.dbf’

crosscheck’s:

RMAN> CROSSCHECK backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

RMAN> CROSSCHECK backup of database;

using channel ORA_DISK_1

RMAN> CROSSCHECK backup of controlfile;

using channel ORA_DISK_1

RMAN> CROSSCHECK archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
specification does not match any archive log in the recovery catalog

Algo de errado com os archives, mas
será que tem have com esse erro ?

obs: Estou no modo nocatalog o crosschek faz a checagem com
o control file ?

Vou fazer o backup do archive levar para lá, e catalogar eles
e rodar o restore denovo… só por via de dúvidas.

continuando…

vamos catalogar:

RMAN> catalog backuppiece ‘/u03/wis/full_wis_692811273_2’;

using target database control file instead of recovery catalog
cataloged backuppiece
backup piece handle=/u03/wis/full_wis_692811273_2 recid=1 stamp=692982164

RMAN> catalog backuppiece ‘/u03/wis/full_wis_692814747_3’;

cataloged backuppiece
backup piece handle=/u03/wis/full_wis_692814747_3 recid=2 stamp=692982200

RMAN> catalog backuppiece ‘/u03/wis/full_wis_692824194_4’;

cataloged backuppiece
backup piece handle=/u03/wis/full_wis_692824194_4 recid=3 stamp=692982216

RMAN> list backup of database summary ;

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
——- — — – ———– ————— ——- ——- ———- —
2 B F A DISK 21-JUL-09 1 1 NO TAG20090721T163226

rodando novamente após essas mudanças!!

creating datafile fno=1 name=/u03/wis/system01.dbf
released channel: C1
released channel: C2
released channel: C3
released channel: C4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/23/2009 15:05:28
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘/u02/oracle/oradata/wis/system01.dbf’

mesmo erro !
Sei que estou fazendo algo errado mas quero saber aonde?

[vieriParticipante]

+ info…

RMAN> list backup ;

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
1 Full 6.05M DISK 00:00:00 21-JUL-09
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20090721T153433
Piece Name: /u03/wis/full_wis_692811273_2
Control File Included: Ckp SCN: 5256320567 Ckp time: 21-JUL-09

BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
2 Full 50.58G DISK 00:00:00 21-JUL-09
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20090721T163226
Piece Name: /u03/wis/full_wis_692814747_3
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
1 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/system01.dbf
2 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/undotbs1.dbf
3 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/sysaux01.dbf
4 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/data_entrega.dbf
5 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/data_entrega_small.dbf
6 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/gkoscf_dtau.dbf
7 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/gkoscf_inau.dbf
8 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/gkoscf_indx.dbf
9 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/indx_entrega.dbf
10 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_asstec.dbf
11 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_cestqhist_32m.dbf
12 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_detprep_32m.dbf
13 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_hist_256k.dbf
14 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_hist_32m.dbf
15 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_hist_5m.dbf
16 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_hist_64m.dbf
17 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_inet.dbf
18 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_sge.dbf
19 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_trcmovestq_64m.dbf
20 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_wis_256k.dbf
21 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_wis_32m.dbf
22 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_data_wis_5m.dbf
23 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_asstec.dbf
24 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_cestqhist_32m.dbf
25 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_detprep__32m.dbf
26 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_hist_256k.dbf
27 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_inet.dbf
28 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_sge.dbf
29 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_trcmovestq_64m.dbf
30 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_wis_256k.dbf
31 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_wis_32m.dbf
32 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tbs_indx_wis_5m.dbf
33 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/tools.dbf
34 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/undotbs2.dbf
35 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/users.dbf
36 Full 5256322985 21-JUL-09 /u02/oracle/oradata/wis/gkoscf_data.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
3 Full 6.05M DISK 00:00:00 21-JUL-09
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20090721T163226
Piece Name: /u03/wis/full_wis_692824194_4
Control File Included: Ckp SCN: 5256327637 Ckp time: 21-JUL-09

[Rodrigo AlmeidaParticipante]

Vamos lá…

Vamos fazer os passos desde o início.

[ SERVIDOR 1]

1) Faça um backup assim.

run {
sql ‘alter system archive log current’;
backup full database include current contolfile plus archivelog;
}
|
|—-> Só por garantia.

2) Passe os BSs para o outro servidor [ SERVIDOR 2 ]

3) Crie o PFILE e altere os parâmetros necessários que não existe no [ SERVIDOR 2]

[ NO SERVIDOR 2 ]

4) Inicia a instância

#> sqlplus “/ as sysdba”

SQL> startup pfile=/;

5) Restaura o CONTROL FILE

RMAN> restore controlfile from ‘ alter database mount;
RMAN> exit

6) Faça um CROSSCHECK do backup

RMAN> CROSSCHECK backup;
RMAN> CROSSCHECK copy;
RMAN> CROSSCHECK backup of database;
RMAN> CROSSCHECK backup of controlfile;
RMAN> CROSSCHECK archivelog all;

7) Catalog os seus BSs que está no SERVIDOR 2.

RMAN> CATALOG backuppiece ‘′;

8) Verifique o LIST BACKUP se está tudo certo!

RMAN> list backup;

9) CATALOGAR

RMAN> catalog backuppiece ”;

10) RESTAURAR A BASE

RMAN> run {
set newname for datafile 1 to ”;
restore database;
switch datafile all;
recover database;
}

Veja agora!!!

[Autor]

Posts