RMAN archivlog / noarchivlog

Rman

archive log mode

[oracle@wctsrv0058 ~]$ . oraenv
ORACLE_SID = [TSH1] ? BRIDGE
[oracle@wctsrv0058 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 2 13:12:04 2019

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence     68
Current log sequence           70
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  2083368 bytes
Variable Size             188745176 bytes
Database Buffers           88080384 bytes
Redo Buffers                6303744 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence     68
Next log sequence to archive   70
Current log sequence           70
SQL>

alter database noarchivelog;

alter database open; 
archive log list;
alter system switch logfile;

Configuration ControlFile

$ rman

connect target / ;
show all;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/backups/hot/%T_%d_%F';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/data/backups/hot/%T_%d_%U';

ou

connect target / ;
show all;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backups/%d/hot/%T_%d_%F';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backups/%d/hot/%T_%d_%U';

rman backup

manual

crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt obsolete;

backup incremental level 0 tag 'database level 0' database plus archivelog tag 'archives level 0';
delete noprompt obsolete;

report need backup;
list backup summary;

script

Cold

 ./stop_database.sh BIPRD
 ./backup_cold_BIPRD.sh
 ./start_database.sh BIPRD

Hot

 sauve_hot.sh BIPRD