Note_Tech
All technological notes.
Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham
Backup - Colde Backup and Hot Backup
Lab: Perform a cold database backup
- Create a directory to preserve the backup.
mkdir -p /u01/app/oracle/donttouch
- Perform a cold database backup.
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: Perform a hot database backup
- Create a hot backup to the RMAN configured location.
sqlplus / as sysdba
-- confirm fra is enable
show parameter db_recovery_file_dest
exit
- Perform the backup to the default location.
rman target /
BACKUP DATABASE;
EXIT;