Prev | Current Page 665 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

258.630244583
input datafile file number=00004 name=+DATA/dw/datafile/users.259.630244583
channel ORA_DISK_1: starting piece 1 at 29-AUG-07
channel ORA_DISK_1: finished piece 1 at 29-AUG-07
piece handle=+RECOV/dw/backupset/2007_08_29/
nnndf0_tag20070829t181238_0.292.63190
775 tag=TAG20070829T181238 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:26
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 29-AUG-07
channel ORA_DISK_1: finished piece 1 at 29-AUG-07
piece handle=+RECOV/dw/backupset/2007_08_29/
nnsnf0_tag20070829t181238_0.293.631908931 tag=TAG20070829T181238
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 29-AUG-07
Starting Control File and SPFILE Autobackup at 29-AUG-07
piece handle=+RECOV/dw/autobackup/2007_08_29/
s_631908935.294.631908947 comment=NONE
Finished Control File and SPFILE Autobackup at 29-AUG-07
RMAN> sql 'alter system archive log current';
sql statement: alter system archive log current
RMAN>
The alter system command ensures that we have archived logs for all transactions, including
those that occurred while the backup was taking place; this ensures that we can perform media
recovery after restoring this backup.
Note that the SPFILE is backed up twice, the second time along with the control file.


Pages:
653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677
katalog portfele męskie west grysieciowe22 samochody