Menu de navegação

[CassorieloParticipante]

Pessoal,

Tenho meu banco no modo archivelog e fiz o seguinte script para backup on-line:

———————————————————————————————————–
#!/bin/bash

DATA=`date +%d/%m/%y_%R`
CAT=/bin/cat

# Muda o TAG para a data e horario atual
#

$CAT > /home/oracle/bkp_database < show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u02/backup/bkp_ctl_%d_%F’;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/u02/backup/bkp_%d_%T’;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u02/backup/bkp_snapcf_veranfp.f’;
———————————————————————————————————–
Após a execução do script este foi o feedback do RMAN:

———————————————————————————————————–
[oracle@201-74-189-106-mc ~]$ ./re_hotbackup_rman

Recovery Manager: Release 10.2.0.1.0 – Production on Mon Feb 18 00:10:33 2008

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

connected to target database: VERANFP (DBID=1526270677)

RMAN> run {
2> sql ‘ALTER TABLESPACE SYSTEM BEGIN BACKUP’;
3> sql ‘ALTER TABLESPACE UNDOTBS1 BEGIN BACKUP’;
4> sql ‘ALTER TABLESPACE SYSAUX BEGIN BACKUP’;
5> sql ‘ALTER TABLESPACE USERS BEGIN BACKUP’;
6> BACKUP FULL DATABASE TAG “BACKUP_18/02/08_00:10”;
7> sql ‘ALTER TABLESPACE SYSTEM END BACKUP’;
8> sql ‘ALTER TABLESPACE UNDOTBS1 END BACKUP’;
9> sql ‘ALTER TABLESPACE SYSAUX END BACKUP’;
10> sql ‘ALTER TABLESPACE USERS END BACKUP’;
11> }
12>
using target database control file instead of recovery catalog
sql statement: ALTER TABLESPACE SYSTEM BEGIN BACKUP

sql statement: ALTER TABLESPACE UNDOTBS1 BEGIN BACKUP

sql statement: ALTER TABLESPACE SYSAUX BEGIN BACKUP

sql statement: ALTER TABLESPACE USERS BEGIN BACKUP

Starting backup at 18-FEB-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=149 devtype=DISK
RMAN-06554: WARNING: file 1 is in backup mode
RMAN-06554: WARNING: file 2 is in backup mode
RMAN-06554: WARNING: file 3 is in backup mode
RMAN-06554: WARNING: file 4 is in backup mode
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/oradata/veranfp/system01.dbf
input datafile fno=00003 name=/u02/oradata/veranfp/sysaux01.dbf
input datafile fno=00002 name=/u02/oradata/veranfp/undotbs01.dbf
input datafile fno=00004 name=/u02/oradata/veranfp/users01.dbf
channel ORA_DISK_1: starting piece 1 at 18-FEB-08
channel ORA_DISK_1: finished piece 1 at 18-FEB-08
piece handle=/u02/backup/bkp_VERANFP_20080218 tag=BACKUP_18/02/08_00:10 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 18-FEB-08

Starting Control File and SPFILE Autobackup at 18-FEB-08
piece handle=/u02/backup/bkp_ctl_VERANFP_c-1526270677-20080218-01 comment=NONE
Finished Control File and SPFILE Autobackup at 18-FEB-08

sql statement: ALTER TABLESPACE SYSTEM END BACKUP

sql statement: ALTER TABLESPACE UNDOTBS1 END BACKUP

sql statement: ALTER TABLESPACE SYSAUX END BACKUP

sql statement: ALTER TABLESPACE USERS END BACKUP

Recovery Manager complete.

———————————————————————————————————–
Minhas perguntas são as seguintes:

1- Como seria um restore/recover para este meu backup em caso de um crash na partição dos datafiles, grupo de redo e ctls?

2- Fora este backup preciso copiar os archives ou eles estão inclusos no backup database full?

Estou estudando RMAN e estou com estas dúvidas e ficarei muito grato pela ajuda de algum dos grandes profissionais que tem aqui, o que também espero ser daqui a algum tempo.

Valeu,
Leandro

[Autor]

Posts