rman小记

SQL> shutdown immediate;

SQL> startup mount

SQL> alter database archivelog

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     16

Next log sequence to archive   18

Current log sequence           18

C:\Documents and Settings\Administrator>rman nocatalog

RMAN> connect target /

connected to target database: ORCL (DBID=1237605652)

using target database controlfile instead of recovery catalog

RMAN> backup database;

Starting backup at 05-2月 -10

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=160 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF

input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF

input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01.DB

F

input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DB

F

input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF

RMAN> list backupset;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1       Full    534M       DISK        00:01:12     05-2月 -10

        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20100205T215443

        Piece Name: C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\

2010_02_05\O1_MF_NNNDF_TAG20100205T215443_5PR8S3XR_.BKP

  List of Datafiles in backup set 1

  File LV Type Ckp SCN    Ckp Time   Name

  ---- -- ---- ---------- ---------- ----

  1       Full 437697     05-2月 -10 C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTE

M01.DBF

  2       Full 437697     05-2月 -10 C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOT

BS01.DBF

  3       Full 437697     05-2月 -10 C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAU

X01.DBF

  4       Full 437697     05-2月 -10 C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS

01.DBF

  5       Full 437697     05-2月 -10 C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMP

LE01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2       Full    2M         DISK        00:00:01     05-2月 -10

        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20100205T215443

        Piece Name: C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\

2010_02_05\O1_MF_NCSNF_TAG20100205T215443_5PR8VJK2_.BKP

  Controlfile Included: Ckp SCN: 437697       Ckp time: 05-2月 -10

  SPFILE Included: Modification time: 01-2月 -10

RMAN> backup incremental level=0 database;