Vitor Eduardo

Bom como irei precisar do script de backup online em ambiente Windows, vamos criar um arquivo com extensão bat, segue:

Backup_Online.bat

SET NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS
SET ORACLE_HOME=D:\U01\oracle\product\10.2.0\db_1
SET ORACLE_SID=ORCL
SET SCRIPT_ORACLE=D:\u01\Backup\Scripts
SET LOG_ORACLE=D:\u01\Backup\Log

%ORACLE_HOME%\bin\rman target / nocatalog cmdfile=%SCRIPT_ORACLE%\Backup_Online.rcv msglog=%LOG_ORACLE%\Backup_Online_%DATE:~4,2%.%DATE:~7,2%.%DATE:~10,4%_%TIME:~0,2%h%.LOG

Agora vamos criar o script do backup online, segue:

Backup_Online.rcv

configure controlfile autobackup ON;
configure retention policy to none;
sql ‘alter session set optimizer_mode=RULE’;

run {
#Perform allocate channel
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT ‘D:\u01\Backup\BackupBD’;

#Perform archive log current
sql ‘alter system archive log current’;
sql ‘alter system switch logfile’;

backup
as compressed backupset
full check logical database
format ‘BKP_ON_FULL_DIARIO_%U_%d_%t_%s.DBF’
tag ‘BKP_ON_FULL_DIA_%U_%d_%t_%s’
filesperset 10;

# Perform controlfile backup
backup as compressed backupset current controlfile
format ‘bkp_controlfile_%F_%U_%d_%t_%s.rman’
tag ‘bkp_controlfile_%F_%U_%d_%t_%s’;

# Perform SPFILE backup
backup as compressed backupset spfile
format ‘bkp_spfile_%U_%d_%t_%s.rman’
tag ‘bkp_spfile_%U_%d_%t_%s’;

# Perform trace’s do controlfile
sql ‘alter database backup controlfile to trace’;
}
Abraço!

Bom como irei precisar do script de backup archive em ambiente Windows, vamos criar um arquivo com extensão bat, segue:

Backup_archive.bat

SET NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS
SET ORACLE_HOME=D:\U01\oracle\product\10.2.0\db_1
SET ORACLE_SID=ORCL
SET SCRIPT_ORACLE=D:\u01\Backup\Scripts
SET LOG_ORACLE=D:\u01\Backup\Log

%ORACLE_HOME%\bin\rman target / nocatalog cmdfile=%SCRIPT_ORACLE%\Bkp_archive.rcv msglog=%LOG_ORACLE%\Bkp_archive_%DATE:~4,2%.%DATE:~7,2%.%DATE:~10,4%_%TIME:~0,2%h%

Agora vamos criar o script de archive segue:

Bkp_archive.rcv

configure controlfile autobackup off;
configure retention policy to none;

sql ‘alter session set optimizer_mode=RULE’;

run {
# Perform allocate channel
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT ‘D:\u01\Backup\BackupBD’;

#   Perform archive log current
sql ‘alter system   archive log current’;
sql ‘alter system   switch logfile’;

backup check logical
format ‘BKP_ARC_DIARIO_%U_%d_%t_%s.ARC’
tag ‘BKP_ARC_DIARIO_%U_%d_%t_%s’
filesperset 10
(archivelog all delete input
skip inaccessible );
}

Abraço!

Bom gostaria de documentar alguns passos que fiz em um restore no ambiente windows, segue:

– Foi instalado o software sem o banco de dados
– Foi abaixado o backup para o servidor local junto com os archive log`s
– Criado a estrutura dos arquivos do banco de dados
– Criado o serviço no windows
oradim -new -sid ORCL -startmode m
– Setar o ORACLE_SID entrar no RMAN
rman
RMAN> connect target /
– setar o dbid
RMAN> set dbid 2372943876
– Vamos restaurar o spfile do backup
RMAN> startup nomount

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘D:\ORACLE\ORA10\DATABASE\INITORCL.ORA’

trying to start the Oracle instance without parameter files …
Oracle instance started

Total System Global Area 97590928 bytes

Fixed Size 454288 bytes
Variable Size 46137344 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes

RMAN> restore spfile from ‘C:\backup\CTL_SP_BAK_C-2372943876′;

– Startar a instacia
RMAN> startup force nomount

– Verificar spfile e ver para qual lugar está apontando o controlfile e criar a estrutura
– Restaurar o controlfile

RMAN> restore controlfile from ‘C:\backup\CONTROLFILE_BACKUP_C-2372943876-20050228-00′;

– Montar o banco de dados
– Entrar na instancia e verificar o path dos caminhos dos datafiles(v$datafile) e redologs(V$logfile)
– Bom depois de criado a estrutura de diretorios apenas fazer o restore

RMAN> connect target /
RMAN> restore database;

OBS: se vc usar algum backup online voltar os archives que foram gerados no tempo do backup online para fazer o recover, segue script para fazer o restore dos archives:

Primeiro listar os backup archives no RMAN, segue:

list backup of archivelog all;

list backup of archivelog sequence between 5594 and 5884;

No banco de dados listar os archives gerados:

select NAME,SEQUENCE#,NEXT_TIME,ARCHIVED,STATUS,to_char(COMPLETION_TIME,’DD-MON-YYYY HH24:MI:SS’) from V$ARCHIVED_LOG where COMPLETION_TIME like ‘%21-MAY-12%’ order by 5;

Script de restore dos archives:

run{
sql “alter session set optimizer_mode=RULE”;
# Perform allocate channel
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT ‘D:\u01\Backup\BackupBD’;
set archivelog destination to ‘D:\u01\ArchiveLOG’;
restore archivelog from logseq=162000 until logseq=164000;
#restore archivelog all;
#restore archivelog sequence 27;
}

Realizar o recover
RMAN> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

– Abrir o banco de dados
alter database open resetlogs;

Bom galera, vou deixar um script de Backup offline aqui facil para mim no blog, pois vou precisar dele amanha, segue:

Primeiramente criar o arquivo com extensão .bat, conteudo:

SET NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS
SET ORACLE_HOME=d:\U01\oracle\product\10.2.0\db_1
SET ORACLE_SID=orcl
SET SCRIPT_ORACLE=D:\u01\Backup\Scripts
SET LOG_ORACLE=D:\u01\Backup\Log

%ORACLE_HOME%\bin\rman target / nocatalog cmdfile=%SCRIPT_ORACLE%\Bkp_Offline.rcv msglog=%LOG_ORACLE%\Bkp_Offline_%DATE:~4,2%.%DATE:~7,2%.%DATE:~10,4%_%TIME:~0,2%h%TIME:~3,2%mim.LOG

– Agora com o arquivo bat criado acima irei criar um outro script com o nome Bkp_Offline.rcv, segue:

configure retention policy to none;

run {
# Shutdown database for backups
shutdown immediate;

# Startup database for backups and put into MOUNT mode
startup mount;

# Perform allocate channel
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT ‘D:\u01\Backup\BackupBD’;

# Perform full database backup
backup as compressed backupset full
check logical database
format ‘BKP_OFF_FULL_%U_%d_%t_%s.DBF’
tag ‘BKP_OFF_FULL_%U_%d_%t_%s′
filesperset 10;

# Perform controlfile backup
backup as compressed backupset current controlfile
tag ‘bkp_controlfile’
format ‘bkp_controlfile_%d_%t_%s.rman’;

# Perform SPFILE backup
backup as compressed backupset spfile
tag ‘bkp_spfile’
format ‘bkp_spfile_%d_%t_%s.rman’;

# Open database after backup complete
sql ‘alter database open’;

# Perform trace controlfile
sql ‘alter database backup controlfile to trace’;

# Perform free channel
release channel t1;
}

Bom é isso galera

Abraço