oracle备份还原

备份

#!/bin/bash

export ORACLE_SID=LOCALSID
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=/u01/oracle/product/11.2.0/dbhome_1

$ORACLE_HOME/bin/rman target / << EOF
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup as compressed backupset database format '/dbbackup/full_dbbackup_%T_%d_%U                                                                                                                                                             ';
delete noprompt obsolete;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
EOF

还原

rman target /
restore controlfile from '/dbbackup/c-1644883930-20220103-00';
 connect target /
  startup mount;
  
 run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
 RESTORE DATABASE ;
 RECOVER DATABASE ;
 release channel c1;
release channel c2;
release channel c3;
release channel c4;
}