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)
ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database
When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA add datafile '/u01/data/data15.dbf...
-
CONCURRENT MANAGER ISSUES IN APPS R12 Status code and Phase code for Concurrent requests Here is what the abbreviation for ...
-
How to clean FND_NODES table in R12.2.4 Step 1: Always apply the latest cloning patches to avoid all the bugs and fixes Step 2: ...
-
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...
No comments:
Post a Comment