Oracle SYSAUX表空间的恢复(二)
eated.
SQL> commit;
Commit complete.
3.故障模拟
[oracle@ora10g orcl]$ date
Tue Apr 2 15:56:12 CST 2013
[oracle@ora10g orcl]$
[oracle@ora10g orcl]$ mv sysaux01.dbf sysaux01.dbf.bak
[oracle@ora10g orcl]$ date
Tue Apr 2 15:56:44 CST 2013
Tue Apr 2 15:56:44 CST 2013
[oracle@ora10g orcl]$ exit
exit
SQL> insert into t1 values(8);
1 row created.
SQL> commit;
Commit complete.
SQL> insert into t1 values(9);
1 row created.
SQL> commit;
Commit complete.
SQL> insert into t1 values(10);
1 row created.
SQL> commit;
Commit complete.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 209715200 bytes
Fixed Size 1218556 bytes
Variable Size 62916612 bytes
Database Buffers 142606336 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> col name format a50
SQL> l
1* select name,STATUS from v$datafile
SQL> /
NAME STATUS
-------------------------------------------------- -------
/u01/oradata/orcl/system01.dbf SYSTEM
/u01/oradata/orcl/undotbs01.dbf ONLINE
/u01/oradata/orcl/sysaux01.dbf RECOVER
/u01/oradata/orcl/users01.dbf ONLINE
/u01/oradata/orcl/dt01.dbf ONLINE
/u01/oradata/orcl/dt02.dbf ONLINE
/u01/oradata/orcl/dt03.dbf ONLINE
7 rows selected.
restore tablespace sysaux;
restore datafile 3;
[oracle@ora10g orcl]$ ls -l /u01/rmanbak/04o632e4_ORCL_20130402
-rw-r----- 1 oracle dba 156180480 Apr 2 15:50 /u01/rmanbak/04o632e4_ORCL_20130402
RMAN> restore datafile 3;
Starting restore at 02-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u01/oradata/orcl/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/04o632e4_ORCL_20130402
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/rmanbak/04o632e4_ORCL_20130402 tag=TAG20130402T155028
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
Finished restore at 02-APR-13
RMAN> recover tablespace sysaux;
Starting recover at 02-APR-13
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 02-APR-13
SQL> select file#,name,STATUS from v$datafile;
FILE# NAME STATUS
---------- -------------------------------------------------- -------
1 /u01/oradata/orcl/system01.dbf SYSTEM
2 /u01/oradata/orcl/undotbs01.dbf ONLINE
3 /u01/oradata/orcl/sysaux01.dbf OFFLINE
4 /u01/oradata/orcl/users01.dbf ONLINE
5 /u01/oradata/orcl/dt01.dbf ONLINE
6 /u01/orada