Chinaunix首页 | 论坛 | 博客
  • 博客访问: 894620
  • 博文数量: 101
  • 博客积分: 2256
  • 博客等级: 大尉
  • 技术积分: 1481
  • 用 户 组: 普通用户
  • 注册时间: 2011-04-19 17:52
文章存档

2017年(1)

2013年(2)

2012年(25)

2011年(73)

分类: Oracle

2011-12-25 22:30:30

1.       windows环境

笔记本上的硬件环境;

操作系统:windows xp 32

数据库实例名:orcl2

用户名/密码:orcl2/orcl2

IP地址:192.168.2.3

2.       linux环境

笔记本上的虚拟机系统;

操作系统:redhat linux 5 32

数据库实例名:orcl

用户名/密码:scott/tiger

IP地址:192.168.2.5

3.       windows上面的数据库作为恢复目录,linux上的数据库作为目标数据库;

4.在linux系统上,用控制文件的方式来rman操作脚本如下;

[oracle@localhost ~]$ ifconfig
bash: ifconfig: command not found
[oracle@localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-DEC-2011 15:37:35

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.jacky)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
[oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-DEC-2011 15:37:43

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.jacky)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                26-DEC-2011 15:37:45
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.jacky)(PORT=1521)))
Services Summary...
Service "PL***tProc" has 1 instance(s).
  Instance "PL***tProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 26 15:38:09 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> archive log liset
SP2-0718: illegal ARCHIVE LOG option
SQL> archive log list
ORA-01034: ORACLE not available
SQL> startup mount
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1219040 bytes
Variable Size              92276256 bytes
Database Buffers          197132288 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     6
Next log sequence to archive   8
Current log sequence           8
SQL> alter database open
  2  ;

Database altered.

SQL> show user;
USER is "SYS"
SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      orcl
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
ORCL

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ su -
鍙d护锛?[root@localhost ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 00:0C:29:80:90:87 
          inet addr:192.168.2.5  Bcast:192.168.2.255  Mask:255.255.255.0
          inet6 addr: fe80::20c:29ff:fe80:9087/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:22 errors:0 dropped:0 overruns:0 frame:0
          TX packets:46 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:5013 (4.8 KiB)  TX bytes:8236 (8.0 KiB)
          Interrupt:169 Base address:0x2000

lo        Link encap:Local Loopback 
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:3692 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3692 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:3756577 (3.5 MiB)  TX bytes:3756577 (3.5 MiB)

[root@localhost ~]# su - oracle
[oracle@localhost ~]$ ping 192.168.2.3
PING 192.168.2.3 (192.168.2.3) 56(84) bytes of data.
64 bytes from 192.168.2.3: icmp_seq=1 ttl=128 time=8.04 ms
64 bytes from 192.168.2.3: icmp_seq=2 ttl=128 time=0.818 ms
64 bytes from 192.168.2.3: icmp_seq=3 ttl=128 time=0.855 ms
64 bytes from 192.168.2.3: icmp_seq=4 ttl=128 time=0.189 ms

--- 192.168.2.3 ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 2999ms
rtt min/avg/max/mdev = 0.189/2.477/8.046/3.226 ms

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Dec 26 17:18:00 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1295949506)

RMAN> show all
2> ;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_ORCL.f'; # default

RMAN> exit;


Recovery Manager complete.
[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 26 17:20:28 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> desc v$flash_recovery_area_usage;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_TYPE                                          VARCHAR2(12)
 PERCENT_SPACE_USED                                 NUMBER
 PERCENT_SPACE_RECLAIMABLE                          NUMBER
 NUMBER_OF_FILES                                    NUMBER

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE                   0                         0               0
ONLINELOG                     0                         0               0
ARCHIVELOG                 1.73                         0               2
BACKUPPIECE                   0                         0               0
IMAGECOPY                     0                         0               0
FLASHBACKLOG                  0                         0               0

6 rows selected.

SQL> show user;
USER is "SYS"
SQL> show parameter control_file_record_keep_time;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
SQL> alter system set control_file_record_keep_time=14 scope=spfile;

System altered.

5.       在windows操作系统上面用恢复目录操作的脚本如下:


Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>tnsping orcl3
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-12月-2011 20:49
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
已使用的参数文件:
E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 19
OK (30 毫秒)
C:\Documents and Settings\Administrator>ping 192.168.2.5 -t
Pinging 192.168.2.5 with 32 bytes of data:
Reply from 192.168.2.5: bytes=32 time<1ms TTL=64
Reply from 192.168.2.5: bytes=32 time<1ms TTL=64
Reply from 192.168.2.5: bytes=32 time<1ms TTL=64
Reply from 192.168.2.5: bytes=32 time<1ms TTL=64
Ping statistics for 192.168.2.5:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms
Control-C
^C
C:\Documents and Settings\Administrator>set oracle_sid=orcl2
C:\Documents and Settings\Administrator>set oracle_sid
oracle_sid=orcl2
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 12月 25 20:50:58 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn / as sysdba;
已连接。
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> desc dba_users;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 USERNAME                                  NOT NULL VARCHAR2(30)
 USER_ID                                   NOT NULL NUMBER
 PASSWORD                                           VARCHAR2(30)
 ACCOUNT_STATUS                            NOT NULL VARCHAR2(32)
 LOCK_DATE                                          DATE
 EXPIRY_DATE                                        DATE
 DEFAULT_TABLESPACE                        NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE                      NOT NULL VARCHAR2(30)
 CREATED                                   NOT NULL DATE
 PROFILE                                   NOT NULL VARCHAR2(30)
 INITIAL_RSRC_CONSUMER_GROUP                        VARCHAR2(30)
 EXTERNAL_NAME                                      VARCHAR2(4000)
SQL> select username from dba_users;
USERNAME
------------------------------
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
SCOTT
ORCL2
RMAN
OUTLN
MDSYS
ORDSYS
USERNAME
------------------------------
CTXSYS
ANONYMOUS
EXFSYS
DMSYS
WMSYS
XDB
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
MDDATA
DIP
USERNAME
------------------------------
TSMSYS
已选择23行。
SQL> desc dba_sys_privs;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 GRANTEE                                   NOT NULL VARCHAR2(30)
 PRIVILEGE                                 NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                       VARCHAR2(3)
SQL> select * from dba_sys_privs where grantee='RMAN';
GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
RMAN                           UNLIMITED TABLESPACE                     NO
SQL> conn rman/rman;
已连接。
SQL> show user;
USER 为 "RMAN"

SQL> select * from session_roles order by role;
ROLE
------------------------------
DBA
DELETE_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
EXP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
HS_ADMIN_ROLE
IMP_FULL_DATABASE
JAVA_ADMIN
JAVA_DEPLOY
OLAP_DBA
RECOVERY_CATALOG_OWNER
ROLE
------------------------------
SCHEDULER_ADMIN
SELECT_CATALOG_ROLE
WM_ADMIN_ROLE
XDBADMIN
XDBWEBSERVICES
已选择16行。
SQL> desc user_tablespaces;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                NOT NULL NUMBER
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENTS                               NOT NULL NUMBER
 MAX_EXTENTS                                        NUMBER
 PCT_INCREASE                                       NUMBER
 MIN_EXTLEN                                         NUMBER
 STATUS                                             VARCHAR2(9)
 CONTENTS                                           VARCHAR2(9)
 LOGGING                                            VARCHAR2(9)
 FORCE_LOGGING                                      VARCHAR2(3)
 EXTENT_MANAGEMENT                                  VARCHAR2(10)
 ALLOCATION_TYPE                                    VARCHAR2(9)
 SEGMENT_SPACE_MANAGEMENT                           VARCHAR2(6)
 DEF_TAB_COMPRESSION                                VARCHAR2(8)
 RETENTION                                          VARCHAR2(11)
 BIGFILE                                            VARCHAR2(3)
SQL> select tablespace_name,contents from user_tablespaces;
TABLESPACE_NAME                CONTENTS
------------------------------ ---------
SYSTEM                         PERMANENT
UNDOTBS1                       UNDO
SYSAUX                         PERMANENT
TEMP                           TEMPORARY
USERS                          PERMANENT
ORCL2BK                        PERMANENT
CATLSS                         PERMANENT
已选择7行。

SQL>

C:\Documents and Settings\Administrator>rman target catalog
恢复管理器: Release 10.2.0.1.0 - Production on 星期日 12月 25 21:08:13 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
连接到目标数据库: ORCL (DBID=1295949506)
连接到恢复目录数据库
RMAN> register database;
注册在恢复目录中的数据库
正在启动全部恢复目录的 resync
完成全部 resync
RMAN> show all
2> ;
RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_ORC
RMAN> configure default device type to disk;
新的 RMAN 配置参数:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
已成功存储新的 RMAN 配置参数
正在启动全部恢复目录的 resync
完成全部 resync
RMAN> configure device type disk parallelism 2;
新的 RMAN 配置参数:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
已成功存储新的 RMAN 配置参数
正在启动全部恢复目录的 resync
完成全部 resync
RMAN> configure controlfile autobackup on;
新的 RMAN 配置参数:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
已成功存储新的 RMAN 配置参数
正在启动全部恢复目录的 resync
完成全部 resync
RMAN> show all
2> ;
RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_ORC
RMAN> configure retention policy to redundancy 3;
新的 RMAN 配置参数:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
已成功存储新的 RMAN 配置参数
正在启动全部恢复目录的 resync
完成全部 resync
RMAN> report schema;
数据库方案报表
永久数据文件列表
===========================
文件大小 (MB) 表空间           回退段数据文件名称
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/orcl/system01.dbf
2    85       UNDOTBS1             YES     /u01/app/oracle/oradata/orcl/undotbs01.dbf
3    240      SYSAUX               NO      /u01/app/oracle/oradata/orcl/sysaux01.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/orcl/users01.dbf
临时文件列表
=======================
文件大小 (MB) 表空间           最大大小 (MB) 临时文件名称
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/orcl/temp01.dbf
RMAN> backup archivelog all delete input;
启动 backup 于 25-12月-11
当前日志已存档
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=146 devtype=DISK
分配的通道: ORA_DISK_2
通道 ORA_DISK_2: sid=153 devtype=DISK
通道 ORA_DISK_1: 正在启动存档日志备份集
通道 ORA_DISK_1: 正在指定备份集中的存档日志
输入存档日志线程 =1 序列 =7 记录 ID=1 时间戳=770491497
通道 ORA_DISK_1: 正在启动段 1 于 26-12月-11
通道 ORA_DISK_2: 正在启动存档日志备份集
通道 ORA_DISK_2: 正在指定备份集中的存档日志
输入存档日志线程 =1 序列 =8 记录 ID=2 时间戳=770917537
输入存档日志线程 =1 序列 =9 记录 ID=3 时间戳=770925281
通道 ORA_DISK_2: 正在启动段 1 于 26-12月-11
通道 ORA_DISK_2: 已完成段 1 于 26-12月-11
段句柄=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_12_26/o1_mf_annnn_TAG201112
通道 ORA_DISK_2: 备份集已完成, 经过时间:00:00:06
通道 ORA_DISK_2: 正在删除存档日志
存档日志文件名 =/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_12_26/o1_mf_1_8_7
存档日志文件名 =/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_12_26/o1_mf_1_9_7
通道 ORA_DISK_1: 已完成段 1 于 26-12月-11
段句柄=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_12_26/o1_mf_annnn_TAG201112
通道 ORA_DISK_1: 备份集已完成, 经过时间:00:00:07
通道 ORA_DISK_1: 正在删除存档日志
存档日志文件名 =/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_12_21/o1_mf_1_7_7
完成 backup 于 25-12月-11
启动 Control File and SPFILE Autobackup 于 25-12月-11
段 handle=/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_12_26/o1_mf_s_770925292
完成 Control File and SPFILE Autobackup 于 25-12月-11
RMAN> list backup;

备份集列表
===================
BS 关键字  大小       设备类型占用时间 完成时间
------- ---------- ----------- ------------ ----------
1042    10.18M     DISK        00:00:04     26-12月-11
        BP 关键字: 1044   状态: AVAILABLE  已压缩: NO  标记: TAG20111226T175443
段名:/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_12_26/o1_mf_annnn_TAG20111226
  备份集 1042 中的已存档日志列表
  Thrd Seq     低 SCN    短时间     下一个 SCN   下一次
  ---- ------- ---------- ---------- ---------- ---------
  1    8       591004     21-12月-11 619745     26-12月-11
  1    9       619745     26-12月-11 625594     26-12月-11
BS 关键字  大小       设备类型占用时间 完成时间
------- ---------- ----------- ------------ ----------
1043    28.84M     DISK        00:00:06     26-12月-11
        BP 关键字: 1045   状态: AVAILABLE  已压缩: NO  标记: TAG20111226T175443
段名:/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_12_26/o1_mf_annnn_TAG20111226
  备份集 1043 中的已存档日志列表
  Thrd Seq     低 SCN    短时间     下一个 SCN   下一次
  ---- ------- ---------- ---------- ---------- ---------
  1    7       560270     30-11月-11 591004     21-12月-11
BS 关键字  类型 LV 大小       设备类型 经过时间 完成时间
------- ---- -- ---------- ----------- ------------ ----------
1054    Full    6.80M      DISK        00:00:00     26-12月-11
        BP 关键字: 1056   状态: AVAILABLE  已压缩: NO  标记: TAG20111226T175452
段名:/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_12_26/o1_mf_s_770925292_7hjk
  包括的控制文件: Ckp SCN: 625618       Ckp 时间: 26-12月-11
  包含的 SPFILE: 修改时间: 26-12月-11
RMAN>

 

阅读(1794) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~