Note_Tech

All technological notes.


Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

Backup - Colde Backup and Hot Backup

Back


Lab: Perform a cold database backup

mkdir -p /u01/app/oracle/donttouch
rman target /

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;

-- backup to a separate location
BACKUP DATABASE FORMAT "/u01/app/oracle/donttouch/backup_%U";

ALTER DATABASE OPEN;
EXIT;

lab_cold_recovery01


Lab: Perform a hot database backup

sqlplus / as sysdba
-- confirm fra is enable
show parameter db_recovery_file_dest
exit
rman target /
BACKUP DATABASE;
EXIT;

TOP