Menu de navegação

[Sousa04Participante]

Pessoal estou tendo alguns problemas em relação a criação de um ambiente Database Guard.

fiz os procedimentos para criação porém no momento que o rman lê o backup ele diz que não é possível ler, não encontrado. Se puderem me ajudar agradeço

eis aqui os passos

$ rman target sys@defesa auxiliary sys@def_stdb
Recovery Manager: Release 10.2.0.1.0 – Production on Thu Dec 9 02:22:18 2010

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

target database Password:
connected to target database: DEFESA (DBID=2865415059, not open)
auxiliary database Password:
connected to auxiliary database: DEFESA (not mounted)

RMAN>

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY;

Starting Duplicate Db at 09-DEC-10
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

contents of Memory Script:
{
restore clone standby controlfile;
sql clone ‘alter database mount standby database’;
}
executing Memory Script

Starting restore at 09-DEC-10
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: copied control file copy
input filename=/home/oracle/control_p_standby.bkp
output filename=+SISTEMA/def_stdb/controlfile/control01.ctl
output filename=+CONTROL/def_stdb/controlfile/control02.ctl
Finished restore at 09-DEC-10

sql statement: alter database mount standby database
released channel: ORA_AUX_DISK_1

contents of Memory Script:
{
set newname for tempfile 1 to
“+SISTEMA/def_stdb/datafile/temp_01.dbf”;
switch clone tempfile all;
set newname for datafile 1 to
“+SISTEMA/def_stdb/datafile/system_01.dbf”;
set newname for datafile 2 to
“+SISTEMA/def_stdb/datafile/undo_01.dbf”;
set newname for datafile 3 to
“+SISTEMA/def_stdb/datafile/sysaux_01.dbf”;
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to +SISTEMA/def_stdb/datafile/temp_01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 09-DEC-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +SISTEMA/def_stdb/datafile/system_01.dbf
restoring datafile 00002 to +SISTEMA/def_stdb/datafile/undo_01.dbf
restoring datafile 00003 to +SISTEMA/def_stdb/datafile/sysaux_01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/backup_alterado03lul8k5
ORA-19870: error reading backup piece /home/oracle/backup_alterado03lul8k5
ORA-19505: failed to identify file “/home/oracle/backup_alterado03lul8k5”
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +SISTEMA/def_stdb/datafile/system_01.dbf
restoring datafile 00002 to +SISTEMA/def_stdb/datafile/undo_01.dbf
restoring datafile 00003 to +SISTEMA/def_stdb/datafile/sysaux_01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/backup_puro01lul3rr
ORA-19870: error reading backup piece /home/oracle/backup_puro01lul3rr
ORA-19505: failed to identify file “/home/oracle/backup_puro01lul3rr”
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

creating datafile fno=1 name=+SISTEMA/def_stdb/datafile/system_01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/09/2010 02:29:09
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘+SISTEMA/def_stdb/datafile/system_01.dbf’

abs

[Sousa04Participante]

Aqui estão os backups

rodei o comando validate e não apresentou problema algum.

RMAN> list backup
2> ;

List of Backup Sets

BS Key Type LV Size Device Type Elapsed Time Completion Time

---

1 Full 230.02M DISK 00:01:19 03-DEC-10
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20101203T163403
Piece Name: /home/oracle/backup_puro01lul3rr
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name

---

1 Full 162805 03-DEC-10 +SISTEMA/defesa/datafile/system_01.dbf
2 Full 162805 03-DEC-10 +SISTEMA/defesa/datafile/undo_01.dbf
3 Full 162805 03-DEC-10 +SISTEMA/defesa/datafile/sysaux_01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

---

2 Full 7.89M DISK 00:00:20 03-DEC-10
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20101203T163530
Piece Name: +FLASH_R_A/defesa/autobackup/2010_12_03/s_736791998.256.736792547
Control File Included: Ckp SCN: 162805 Ckp time: 03-DEC-10
SPFILE Included: Modification time: 03-DEC-10

BS Key Type LV Size Device Type Elapsed Time Completion Time

---

3 Full 230.21M DISK 00:00:51 03-DEC-10
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20101203T175516
Piece Name: /home/oracle/backup_alterado03lul8k5
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name

---

1 Full 165567 03-DEC-10 +SISTEMA/defesa/datafile/system_01.dbf
2 Full 165567 03-DEC-10 +SISTEMA/defesa/datafile/undo_01.dbf
3 Full 165567 03-DEC-10 +SISTEMA/defesa/datafile/sysaux_01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

---

4 Full 7.89M DISK 00:00:05 03-DEC-10
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20101203T175613
Piece Name: +FLASH_R_A/defesa/autobackup/2010_12_03/s_736796720.257.736797377
Control File Included: Ckp SCN: 165567 Ckp time: 03-DEC-10
SPFILE Included: Modification time: 03-DEC-10

---

RMAN> validate backupset 1,2,3,4
2> ;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /home/oracle/backup_puro01lul3rr
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup_puro01lul3rr tag=TAG20101203T163403
channel ORA_DISK_1: validation complete, elapsed time: 00:00:17
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece +FLASH_R_A/defesa/autobackup/2010_12_03/s_736791998.256.736792547
channel ORA_DISK_1: restored backup piece 1
piece handle=+FLASH_R_A/defesa/autobackup/2010_12_03/s_736791998.256.736792547 tag=TAG20101203T163530
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /home/oracle/backup_alterado03lul8k5
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup_alterado03lul8k5 tag=TAG20101203T175516
channel ORA_DISK_1: validation complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece +FLASH_R_A/defesa/autobackup/2010_12_03/s_736796720.257.736797377
channel ORA_DISK_1: restored backup piece 1
piece handle=+FLASH_R_A/defesa/autobackup/2010_12_03/s_736796720.257.736797377 tag=TAG20101203T175613
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03

RMAN>

---

ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
AUTOBACKUP MIRROR COARSE DEC 09 02:00:00 Y s_736791998.256.736792547
AUTOBACKUP MIRROR COARSE DEC 09 02:00:00 Y s_736796720.257.736797377
ASMCMD> pwd
+flash_r_a/defesa/autobackup/2010_12_03
ASMCMD>

[Sousa04Participante]

$ ls -ltrh
total 469M
drwxr-xr-x 6 oracle oinstall 4.0K Jul 2 2005 database
-rwxrwxrwx 1 oracle oinstall 231M Dec 3 16:35 backup_puro01lul3rr
-rwxrwxrwx 1 oracle oinstall 231M Dec 3 17:56 backup_alterado03lul8k5

[Autor]

Posts