264.630244787
RMAN>
458 Oracle Database 11g DBA Handbook
To restore and recover the tablespace, we force the tablespace offline, restore and recover the
tablespace, and bring it back online:
RMAN> sql 'alter tablespace users offline immediate';
sql statement: alter tablespace users offline immediate
RMAN> restore tablespace users;
Starting restore at 04-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to
+DATA/dw/datafile/users.259.630244583
channel ORA_DISK_1: reading from backup piece
+RECOV/dw/backupset/2007_09_04/
nnndf0_tag20070904t215119_0.266.632440295
channel ORA_DISK_1: piece handle=+RECOV/dw/backupset/2007_09_04/
nnndf0_tag20070904t215119_0.266.632440295
tag=TAG20070904T215119
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 04-SEP-07
starting full resync of recovery catalog
full resync complete
RMAN> recover tablespace users;
Starting recover at 04-SEP-07
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 04-SEP-07
RMAN> sql 'alter tablespace users online';
sql statement: alter tablespace users online
RMAN>
The restore command copied the latest image or backupset copy of the datafiles in the USERS
tablespace to their original locations; the recover command applied redo from either redo log
files or incremental backups to bring the objects in the tablespace back up to the latest SCN.
Pages:
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704