Prev | Current Page 667 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

289.631843233
ARCHIVELOG MIRROR COARSE AUG 29 07:00:00 Y
thread_1_seq_101.290.631869317
Chapter 12: Using Recovery Manager (RMAN) 437
ARCHIVELOG MIRROR COARSE AUG 29 14:00:00 Y
thread_1_seq_102.291.631893633
ARCHIVELOG MIRROR COARSE AUG 29 18:00:00 Y
thread_1_seq_103.295.631908977
ASMCMD> ls -l autobackup
Type Redund Striped Time Sys Name
Y 2007_08_29/
ASMCMD> ls -l autobackup/2007_08_29
Type Redund Striped Time Sys Name
AUTOBACKUP MIRROR COARSE AUG 29 18:00:00 Y s_631908935.294.631908947
ASMCMD>
As an alternative, you can use RMAN??™s list command to see these backups as they are
cataloged in the target database control file and the RMAN repository. There are four backupsets,
one for a previous full database backup, and three others: a more recent full backup containing
the datafiles themselves, one for the explicit SPFILE backup, and one for the implicit SPFILE and
control file backup.
RMAN> list backup by backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
163 Full 1.25G DISK 00:03:57 25-AUG-07
BP Key: 165 Status: AVAILABLE Compressed: NO Tag:
TAG20070825T215501
Piece Name:
+RECOV/dw/backupset/2007_08_25/
nnndf0_tag20070825t215501_0.271.631576525
List of Datafiles in backup set 163
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2315404 25-AUG-07
+DATA/dw/datafile/system.


Pages:
655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679
www.books61.hobbitstory.com tanie noclegi międzyzdroje pokoje windsurfing Władysławowo noclegi e-lady