Показать сообщение отдельно
  #11  
Старый 30.07.2010, 18:09
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,211
По умолчанию

[[email protected] ~]$ vi rmanscript.rman

Код:
RUN {
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
BACKUP INCREMENTAL LEVEL 0 TAG testbackup DATABASE PLUS ARCHIVELOG;
BACKUP CURRENT CONTROLFILE SPFILE;
}
[[email protected] ~]$ rman target /

RMAN> @rmanscript.rman



RMAN> BACKUP INCREMENTAL LEVEL 1 TAG testbackup DATABASE PLUS ARCHIVELOG;

RMAN> list backup of database;

Код:
List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Incr 0  305.53M    DISK        00:01:15     06-JAN-12
        BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: TESBACKUP
        Piece Name: /u01/app/oracle/fast_recovery_area/ORA112/backupset/2012_01_06/o1_mf_nnnd0_TESBACKUP_7jgddvyw_.bkp
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/system01.dbf
  2    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/sysaux01.dbf
  3    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/undotbs01.dbf
  4    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/users01.dbf
  5    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/my_indexes01.dbf
  6    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/my_data01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18      Incr 1  488.00K    DISK        00:02:13     06-JAN-12
        BP Key: 18   Status: AVAILABLE  Compressed: YES  Tag: TESBACKUP
        Piece Name: /u01/app/oracle/fast_recovery_area/ORA112/backupset/2012_01_06/o1_mf_nnnd1_TESBACKUP_7jgfl0oo_.bkp
  List of Datafiles in backup set 18
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/system01.dbf
  2    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/sysaux01.dbf
  3    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/undotbs01.dbf
  4    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/users01.dbf
  5    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/my_indexes01.dbf
  6    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/my_data01.dbf
RMAN>
__________________
Телеграм чат

Последний раз редактировалось Marley; 06.01.2012 в 20:26.
Ответить с цитированием