Oracle基于RMAN的不完全恢复(四)
ivileges
SQL> conn / as sysdba
Connected.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/ZWC/arch
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL> insert into zhongwc.t_rec values(7,'ggg');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system switch logfile;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/ZWC/arch
Oldest online log sequence 5
Next log sequence to archive 7
Current log sequence 7
SQL> insert into zhongwc.t_rec values(8,'hhh');
1 row created.
SQL> commit
2 ;
Commit complete.
SQL> alter system switch logfile;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/ZWC/arch
Oldest online log sequence 6
Next log sequence to archive 8
Current log sequence 8
SQL> select * from zhongwc.t_rec;
ID NAME
---------- ----------
1 aaa
2 bbb
3 ccc
4 ddd
5 eee
6 fff
7 ggg
8 hhh
8 rows selected.
SQL> set linesize v$log;
SP2-0268: linesize option not a valid number
SQL> set linesize 300
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------------- ------------ -----------------------
1 1 7 52428800 512 1 YES ACTIVE 3409862 05-FEB-2013 14:00:59 3409878 05-FEB-2013 14:01:19
2 1 8 52428800 512 1 NO CURRENT 3409878 05-FEB-2013 14:01:19 2.8147E+14
3 1 6 52428800 512 1 YES ACTIVE 3409682 05-FEB-2013 13:59:11 3409862 05-FEB-2013 14:00:59
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@zwc ~]$ conn / as sysdba
-bash: conn: command not found
[oracle@zwc ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Feb 5 14:06:02 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@zwc ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Feb 5 14:06:17 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights rese