Because
we set configure controlfile autobackup to on, we automatically back up the control file and
SPFILE whenever we do any other kind of backup or the structure of the database changes. As
a result, we don??™t need to specify SPFILE in the backup command.
436 Oracle Database 11g DBA Handbook
Taking a peek into the flash recovery area using the asmcmd tool, we see a lot of cryptic
filenames for the recent archived redo logs and the full database backup we just performed:
SQL> connect / as sysdba
Connected.
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ---------------------
db_recovery_file_dest string +RECOV
db_recovery_file_dest_size big integer 8G
SQL> select name from v$database;
NAME
------------------
DW
SQL> exit
[oracle@dw ~]$ asmcmd
ASMCMD> ls
DATA/
RECOV/
ASMCMD> cd recov/dw
ASMCMD> ls
ARCHIVELOG/
AUTOBACKUP/
BACKUPSET/
CONTROLFILE/
ONLINELOG/
ASMCMD> ls -l backupset
Type Redund Striped Time Sys Name
Y 2007_08_25/
Y 2007_08_29/
ASMCMD> ls -l backupset/2007_08_29
Type Redund Striped Time Sys Name
BACKUPSET MIRROR COARSE AUG 29 18:00:00 Y
nnndf0_TAG20070829T181238_0.292.631908775
BACKUPSET MIRROR COARSE AUG 29 18:00:00 Y
nnsnf0_TAG20070829T181238_0.293.631908931
ASMCMD> ls -l archivelog
Type Redund Striped Time Sys Name
Y 2007_08_25/
Y 2007_08_26/
Y 2007_08_27/
Y 2007_08_28/
Y 2007_08_29/
ASMCMD> ls -l archivelog/2007_08_29
Type Redund Striped Time Sys Name
ARCHIVELOG MIRROR COARSE AUG 29 00:00:00 Y
thread_1_seq_100.
Pages:
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678