RMAN catalog 的创建和使用 - 数据库编程

eded for archived log

archive log filename=/u01/app/oracle/oradata/orcl/arch/log_1_117_733069427.arc recid=111 stamp=733171369

Crosschecked 1 objects

RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile

RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile

RMAN> list archivelog all;

List of Archived Log Copies

KeyThrd SeqS Low TimeName

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

4651117A 22-OCT-10 /u01/app/oracle/oradata/orcl/arch/log_1_117_733069427.arc

5531118A 23-OCT-10 /u01/app/oracle/oradata/orcl/arch/log_1_118_733069427.arc

5691119A 23-OCT-10 /u01/app/oracle/oradata/orcl/arch/log_1_119_733069427.arc

9.基于SCN来备份归档日志

RMAN> run{

2> allocate channel ch1 device type disk;

3> backup as compressed backupset

4> archivelog from scn 848043

5> format='/u01/app/oracle/bk/rmbk/arc_%d_%U'

6> tag='arc';

7> release channel ch1;

8> }

10.镜像备份

RMAN> run{

2> allocate channel ch1 device type disk;

3> backup as copy datafile 1,4

4> format '/u01/app/oracle/bk/rmbk/df_%d_%U'

5> tag 'copybak';

6> release channel ch1;}

11.其它

RMAN> crosscheck backupset;

RMAN> change backupset 1

RMAN> validate backupset

RMAN> validate backupset 635;

RMAN catalog 的创建和使用(二)