Banco : Oracle 9i
rman 9i
Para facilitar o ententimento . fiz o roteiro .
No final mostra o erro no qual nao consegui solucionar . Alguem pode me ajudar ?
1 Passo : Criar script
2 Passo : delete obsolete; -- Deletar arquivos cuja a retenção tenha
expirado . Nosso caso 1 dia .
3 Passo : resync catalog; -- Deve executar sempre que tiver mudança de
estrutura de banco , Mas fiz por segurança
4 Passo : RUN{EXECUTE SCRIPT buceta;} -- Execução
5 Passo : list backup; Validar o Backup – Listou
6 Passo : restore datafile 5; Recuperando
7 Passo :
-- Pelo fato de estar em archive e necessário fazer esse procedimento
por causa do sincronismo do ambiente
SQL> recover datafile '/u04/oradata/rsd0/rsd0_sia_dat_peq_02.dbf';
Media recovery complete.
SQL> alter database open;
LOG PASSO 4
[...]
Starting backup at 27-JUN-12
current log archived
channel d1: starting archive log backupset
channel d1: specifying archive log(s) in backup set
input archive log thread=1 sequence=83662 recid=73 stamp=786762424
input archive log thread=1 sequence=83663 recid=74 stamp=786891171
input archive log thread=1 sequence=83664 recid=75 stamp=787065451
input archive log thread=1 sequence=83665 recid=76 stamp=787068841
input archive log thread=1 sequence=83666 recid=77 stamp=787068852
channel d1: starting piece 1 at 27-JUN-12
channel d1: finished piece 1 at 27-JUN-12
piece handle=/u03/backup/rsd0_teste/bkp_arc_RSD0_517_787068863 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:10
channel d1: deleting archive log(s)
archive log filename=/u02/archive/rsd0/arch_rsd0_83662_.dat recid=73
stamp=786762424
archive log filename=/u02/archive/rsd0/arch_rsd0_83663_.dat recid=74
stamp=786891171
archive log filename=/u02/archive/rsd0/arch_rsd0_83664_.dat recid=75
stamp=787065451
archive log filename=/u02/archive/rsd0/arch_rsd0_83665_.dat recid=76
stamp=787068841
archive log filename=/u02/archive/rsd0/arch_rsd0_83666_.dat recid=77
stamp=787068852
Finished backup at 27-JUN-12
Starting Control File and SPFILE Autobackup at 27-JUN-12
piece handle=/u01/app/oracle/product/9.2.0/dbs/c-2847253212-20120627-01
comment=NONE
Finished Control File and SPFILE Autobackup at 27-JUN-12
released channel: d1
LOG PASSO 5
[...]
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3273 Full 1G DISK 00:00:35 27-JUN-12
BP Key: 3329 Status: AVAILABLE Tag: BUCETA
Piece Name: /u03/backup/rsd0_teste/bkp_dados_RSD0_510_787068553
List of Datafiles in backup set 3273
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 5966301251593 27-JUN-12 /u04/oradata/rsd0/drsys01.dbf
61 Full 5966301251593 27-JUN-12 /u04/oradata/rsd0/cwmlite01.dbf
77 Full 5966301251593 27-JUN-12
/u04/oradata/rsd0/rsd0_audit_ind_med_11.d
bf
78 Full 5966301251593 27-JUN-12
/u04/oradata/rsd0/rsd0_audit_dat_med_17.d
bf
79 Full 5966301251593 27-JUN-12
/u04/oradata/rsd0/rsd0_audit_dat_med_18.d
bf
80 Full 5966301251593 27-JUN-12
/u04/oradata/rsd0/rsd0_audit_ind_med_12.d
bf
[…]
LOG DO PASSO 1
RMAN> print script buceta;
printing stored script: buceta
{
allocate channel d1 type disk;
sql "alter system archive log current";
backup
tag buceta
# Formato dos Arquivos de datafiles
format "/u03/backup/rsd0_teste/bkp_dados_%d_%s_%t"
(database include current controlfile);
sql "alter system archive log current";
Change Archivelog All Crosscheck;
backup
# Formato dos Arquivos de Archivelogs
format "/u03/backup/rsd0_teste/bkp_arc_%d_%s_%t"
(archivelog all delete input);
}
LOG PASSO 6
RMAN> restore datafile 5;
Starting restore at 27-JUN-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=21 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /u04/oradata/rsd0/drsys01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/27/2012 14:25:02
ORA-19573: cannot obtain exclusive enqueue for datafile 5
RMAN>
..
www.servercom.com.br
------------------------------------
--------------------------------------------------------------------------------------------------------------------------
>Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira
>responsabilidade de seus remetentes.
Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
--------------------------------------------------------------------------------------------------------------------------
>Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » Procedure »
>Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE:
>http://www.oraclebr.com.br/
------------------------------------------------------------------------------------------------------------------------
Links do Yahoo! Grupos
<*> Para visitar o site do seu grupo na web, acesse:
http://br.groups.yahoo.com/group/oracle_br/
<*> Para sair deste grupo, envie um e-mail para:
oracle_br-unsubscr...@yahoogrupos.com.br
<*> O uso que você faz do Yahoo! Grupos está sujeito aos:
http://br.yahoo.com/info/utos.html
