Oracle日常操作: RMAN

amwdnuff

Oracle日常操作: RMAN



RMAN

/*压缩备份*/
RUN {
ALLOCATE CHANNEL ch0 TYPE disk maxpiecesize 10G;
BACKUP as compressed backupset DATABASE FORMAT='E:\\BACKUP\\%U' ;
BACKUP CURRENT CONTROLFILE;
SQL 'alter system switch logfile';
# backup archivelog time between 'sysdate-3' and 'sysdate';
RELEASE CHANNEL ch0;
}

/*还原控件文件*/
restore controlfile from 'E:\\backup\\C-2242568731-20080811-00'

/*还原数据文件到指定路径*/
RMAN> run{
allocate channel ch3 device type disk;
set newname for datafile 53 to 'E:\\DF_1.DBF';
set newname for datafile 54 to 'E:\\EC_5.DBF';
set newname for datafile 57 to 'F:\\DC_2.DBF';
restore database;
switch datafile all;
release channel ch3;
}

amwdnuff

Oracle日常操作: RMAN



RMAN

/*压缩备份*/
RUN {
ALLOCATE CHANNEL ch0 TYPE disk maxpiecesize 10G;
BACKUP as compressed backupset DATABASE FORMAT='E:\\BACKUP\\%U' ;
BACKUP CURRENT CONTROLFILE;
SQL 'alter system switch logfile';
# backup archivelog time between 'sysdate-3' and 'sysdate';
RELEASE CHANNEL ch0;
}

/*还原控件文件*/
restore controlfile from 'E:\\backup\\C-2242568731-20080811-00'

/*还原数据文件到指定路径*/
RMAN> run{
allocate channel ch3 device type disk;
set newname for datafile 53 to 'E:\\DF_1.DBF';
set newname for datafile 54 to 'E:\\EC_5.DBF';
set newname for datafile 57 to 'F:\\DC_2.DBF';
restore database;
switch datafile all;
release channel ch3;
}

amwdnuff

Oracle日常操作: RMAN



RMAN

/*压缩备份*/
RUN {
ALLOCATE CHANNEL ch0 TYPE disk maxpiecesize 10G;
BACKUP as compressed backupset DATABASE FORMAT='E:\\BACKUP\\%U' ;
BACKUP CURRENT CONTROLFILE;
SQL 'alter system switch logfile';
# backup archivelog time between 'sysdate-3' and 'sysdate';
RELEASE CHANNEL ch0;
}

/*还原控件文件*/
restore controlfile from 'E:\\backup\\C-2242568731-20080811-00'

/*还原数据文件到指定路径*/
RMAN> run{
allocate channel ch3 device type disk;
set newname for datafile 53 to 'E:\\DF_1.DBF';
set newname for datafile 54 to 'E:\\EC_5.DBF';
set newname for datafile 57 to 'F:\\DC_2.DBF';
restore database;
switch datafile all;
release channel ch3;
}