export ORACLE_SID= (write your SID here)
export ORACLE_BASE= (write your ORACLE BASE here)
export ORACLE_HOME= (write your ORACLE_HOME here)
export PATH=$PATH:${ORACLE_HOME}/bin
rman target=/ <
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO ‘/(write backup directory here)/autobackup_control_file%F’;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
run {
ALLOCATE CHANNEL RMAN_BACK_CH01 TYPE DISK;
CROSSCHECK BACKUP;
BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT
‘/(write backup directory here)/databasefiles_%d_%u_%s_%T’;
sql ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT
‘/(write backup directory here)/archivelogs_%d_%u_%s_%T’
DELETE INwrite;
BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT
‘/(write backup directory here)/controlfile_%d_%u_%s_%T’;
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;
RELEASE CHANNEL RMAN_BACK_CH01;
}
EXIT;
EOF
Hot Backup Script for RMAN
Subscribe to:
Post Comments (Atom)
ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%'
This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user ...
-
CONCURRENT MANAGER ISSUES IN APPS R12 Status code and Phase code for Concurrent requests Here is what the abbreviation for ...
-
Application version : R12.2.10 DB version : 19.17.0 ERROR APP-FND-01388: Cannot read value for profile option CONC_KEEP_BLANK_FILES in rout...
-
1. Lookups -- ------------- FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/ aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APP...
No comments:
Post a Comment