DB - Play with ARCHIVED LOGs
PT : Brincar com ARCHIVED LOGs
EN : Play with ARCHIVED LOGs
#Let's distillate a bit the +FRA - new db - Lets generate to 2 archived logs with
alter system switch logfile;
SQL> set lines 200
SQL> select * from V$RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 0 0 0
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
7 rows selected.
SQL> alter system switch logfile;
System altered.
SQL> select * from V$RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 0.2 0 1
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
7 rows selected.
SQL> alter system switch logfile;
System altered.
SQL> select * from V$RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 0.2 0 2
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
#
#Now lets play with RMAN
#
RMAN> list backup;
using target database control file instead of recovery catalog
specification does not match any backup in the repository
RMAN> BACKUP ARCHIVELOG ALL DELETE ALL INPUT;
Starting backup at 01-OCT-16
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=1 STAMP=924096057
input archived log thread=1 sequence=10 RECID=2 STAMP=924096084
input archived log thread=1 sequence=11 RECID=3 STAMP=924096215
channel ORA_DISK_1: starting piece 1 at 01-OCT-16
channel ORA_DISK_1: finished piece 1 at 01-OCT-16
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2016_10_01/o1_mf_annnn_TAG20161001T132335_cyz75qvp_.bkp tag=TAG20161001T132335 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2016_10_01/o1_mf_1_9_cyz70sgb_.arc RECID=1 STAMP=924096057
archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2016_10_01/o1_mf_1_10_cyz71nvr_.arc RECID=2 STAMP=924096084
archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2016_10_01/o1_mf_1_11_cyz75q4v_.arc RECID=3 STAMP=924096215
Finished backup at 01-OCT-16
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 978.00K DISK 00:00:01 01-OCT-16
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20161001T132335
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2016_10_01/o1_mf_annnn_TAG20161001T132335_cyz75qvp_.bkp
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 9 895024 01-OCT-16 896346 01-OCT-16
1 10 896346 01-OCT-16 896357 01-OCT-16
1 11 896357 01-OCT-16 896431 01-OCT-16
RMAN> list backup summary;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1 B A A DISK 01-OCT-16 1 1 NO TAG20161001T132335
SQL> select * from V$RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 0 0 0
BACKUP PIECE .02 0 1
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
7 rows selected.
-----
Obrigado pela leitura, espero que este post o tenha ajudado :)
Thank you for reading, hope this post was helpful :)
Comments