Tryb Archivelog i autobackup control file

Linux

Uwaga
Domyślna opcja NOARCHIVELOG jest wystarczająca, aby zapewnić ochronę przed błędami systemu operacyjnego oraz błędami samej instancji bazy.

shutdown immediate
su - oracle
sqlplus /nolog
connect / as sysdba
startup mount exclusive;
alter database archivelog;
archive log start;
alter database open;

lub

shutdown immediate
startup mount
alter database archivelog;
alter database open;

Konfiguracja Archivelog

show parameter log_archive_dest;

Konfiguracja obszaru FRA (Flash Recovery Area)

alter system set db_recovery_file_dest_size=10G;
alter system set db_recovery_file_dest=' /opt/backup/fra' ;

Konfiguracja lokalizacji archivelog

alter system set log_archive_dest_1=' location=/opt/backup/archivelog1' ;
alter system set log_archive_dest_2=' location=USE_DB_RECOVERY_FILE_DEST' ;

su - oracle
rman target orcl/PASSWORD
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Nov 30 07:09:30 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: ORCL (DBID=1390091403)
RMAN> configure controlfile autobackup on;
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> exit