Administrador

RMAN

Mario Aldana – DBA

. Protecting

. Reconstructing

Mario Aldana – DBA

Mario Aldana – DBA

Requirements:
. Open instance . Archivelog : SQL> archive log list

Mario Aldana –DBA

Archivelog:
. Location : $ mkdir $ chmod u+g+o

rwx 111=7

Mario Aldana – DBA

Archivelog:
. Configuration : SQL> ALTER SYSTEM SET log_archive_dest_1='location=' scope = spfile;SQL> shutdown immediate
SQL> startup mount SQL> alter database archivelog; SQL> alter database open;

SQL> ALTER SYSTEM SWITCH LOGFILE;

Mario Aldana – DBA

Conection:
$ rman target /

$rman target sys/*****@stringconnect
$ rman target sys/*****@stringconnect log D:\oracle\TLOB1\Backup\msglog.log append

Mario Aldana – DBA

Environmet:
RMAN> show all;
RMAN> CONFIGURE CHANNELDEVICE TYPE DISK FORMAT ‘';

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

Mario Aldana – DBA

Backups:
RMAN> BACKUP TAG 'Copia DB Test1' AS COPY DATABASE;
RMAN> BACKUP CURRENT CONTROLFILE; RMAN>BACKUP TABLESPACE users; RMAN> BACKUP SPFILE; RMAN> BACKUP DATAFILE '/home/oracle/app/oracle/oradata/orcl/users01.dbf'; RMAN> BACKUP TAG 'Backup Nivel 0 Test' INCREMENTAL LEVEL 0 DATABASE; RMAN>BACKUP TAG 'Backup Nivel 0 Test' INCREMENTAL LEVEL 1 DATABASE;

Mario Aldana – DBA

Backup Level 0:
RMAN> BACKUP TAG 'Backup Nivel 0 Test' INCREMENTAL LEVEL 0 DATABASE;

Mario Aldana – DBABackup Level 1:
RMAN> BACKUP TAG 'Backup Nivel 0 Test' INCREMENTAL LEVEL 1 DATABASE;

Mario Aldana – DBA

Backups Validate:
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

Mario Aldana – DBAList Backups:
RMAN> LIST BACKUP OF DATABASE; V$RMAN_STATUS

Mario Aldana – DBA

Obsolete Backups:
RMAN> DELETE OBSOLETE;

Mario Aldana – DBA

Recover Database:
RMAN> STARTUP FORCE MOUNT;RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN;

Mario Aldana – DBA

Exercise:
Your core database does not work. The DBA checks and finds that a datafile cannot be...