This made my day . 2774 1 4214 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4214_661394635.dbf I was asked by my manager to take the archivelog backup of a 10.2.0.4 database using RMAN every two hours for a production database on sun solaris.Definitely, i am not going to sit at every 2nd hour and take the backup manually.So,best was to write a shell script and put it in cron job.Cron is a unix, solaris utility that allows tasks to be automatically run in the background at regular intervals by the cron daemon.Now the question was What will i write in the shell script.I can set the crontab for every 2 hrs and i can use something like from time sysdate-1/12 . - - - - >, Pre-Process and Post-Process Scripts 1 4230 1023228173 02-FEB-10 1023299832 02-FEB-10, [oracle@aires-testb arch]$ ls -lrt

When connected to RMAN as the root container, you can backup one or more PDBs using the following command. Getting Started with Virtualization There are two ways to back up pluggable databases. Thrd Seq Low SCN Low Time Next SCN Next Time allocate channel c1 type disk; - - ORACLE_HOME=/u01/app/11.2.0.4/db_home; export ORACLE_HOME Contact me info@learnomate.org. 950 2.22M DISK 00:00:01 02-FEB-10 - - I tested it on my test db and it worked as needed . Fill in your details below or click an icon to log in: You are commenting using your WordPress.com account.

2769 1 4209 A 01-FEB-10 /oracle_db_storage/testb/arch/1_4209_661394635.dbf 2764 1 4204 A 01-FEB-10 /oracle_db_storage/testb/arch/1_4204_661394635.dbf (LogOut/ 954 39.53M DISK 00:00:08 02-FEB-10 1 4229 1023219613 02-FEB-10 1023228173 02-FEB-10, List of Archived Log Copies 1 4213 1018859257 02-FEB-10 1019928942 02-FEB-10 2772 1 4212 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4212_661394635.dbf

947 5.77M DISK 00:00:03 02-FEB-10 - - RMAN> sql alter system switch logfile; sql statement: alter system switch logfile, List of Archived Log Copies Thrd Seq Low SCN Low Time Next SCN Next Time skipping archive log file /oracle_db_storage/testb/arch/1_4208_661394635.dbf; already backed up 1 time(s) 2782 1 4222 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4222_661394635.dbf 1 4231 1023299832 02-FEB-10 1023299888 02-FEB-10 Piece Name: /oracle_db_storage/rman/arch/ARCH_1092_1_24l507qs, List of Archived Logs in backup set 947 piece handle=/oracle_db_storage/rman/arch/ARCH_1098_1_2al50dhm tag=TAG20100202T102350 comment=NONE skipping archive log file /oracle_db_storage/testb/arch/1_4221_661394635.dbf; already backed up 1 time(s) BP Key: 951 Status: AVAILABLE Compressed: YES Tag: TAG20100202T085623 Specifies the date after which RMAN should back up files that have no backups. 2780 1 4220 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4220_661394635.dbf This switches the logfile at start of backup, then backs up all logs and deletes them. BP Key: 947 Status: AVAILABLE Compressed: YES Tag: TAG20100202T084620 RMAN> list backup tag=TAG20100202T102350; BS Key Size Device Type Elapsed Time Completion Time >, Cross-Hypervisor Restores (VM Conversion) 2763 1 4203 A 01-FEB-10 /oracle_db_storage/testb/arch/1_4203_661394635.dbf delete noprompt archivelog all backed up 1 times to disk completed before sysdate 1/2; >, General Information for All Hypervisors >, Enabling Application-Consistent Backups

951 2.24M DISK 00:00:01 02-FEB-10 2762 1 4202 A 01-FEB-10 /oracle_db_storage/testb/arch/1_4202_661394635.dbf >, File Indexing for Virtual Machines skipping archive log file /oracle_db_storage/testb/arch/1_4206_661394635.dbf; already backed up 1 time(s) 2786 1 4226 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4226_661394635.dbf 1 4216 1022083432 02-FEB-10 1022864419 02-FEB-10, BS Key Size Device Type Elapsed Time Completion Time BP Key: 950 Status: AVAILABLE Compressed: YES Tag: TAG20100202T084810 - - Change), You are commenting using your Twitter account. 1 4226 1023219527 02-FEB-10 1023219584 02-FEB-10 2787 1 4227 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4227_661394635.dbf - - - - skipping archive log file /oracle_db_storage/testb/arch/1_4201_661394635.dbf; already backed up 1 time(s) skipping archive log file /oracle_db_storage/testb/arch/1_4207_661394635.dbf; already backed up 1 time(s) - - - - Piece Name: /oracle_db_storage/rman/arch/ARCH_1091_1_23l507qs, List of Archived Logs in backup set 949 not backed up integer times :- Backs up only those archived logs that have not been backed up at least integer times. EOF. - - - - 2765 1 4205 A 01-FEB-10 /oracle_db_storage/testb/arch/1_4205_661394635.dbf skipping archive log file /oracle_db_storage/testb/arch/1_4229_661394635.dbf; already backed up 1 time(s) skipping archive log file /oracle_db_storage/testb/arch/1_4212_661394635.dbf; already backed up 1 time(s) channel ORA_DISK_2: sid=935 devtype=DISK 2771 1 4211 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4211_661394635.dbf Piece Name: /oracle_db_storage/rman/arch/ARCH_1093_1_25l507r1, List of Archived Logs in backup set 948 input archive log thread=1 sequence=4232 recid=2792 stamp=709899830 skipping archive log file /oracle_db_storage/testb/arch/1_4226_661394635.dbf; already backed up 1 time(s) #sql alter system switch logfile; 2766 1 4206 A 01-FEB-10 /oracle_db_storage/testb/arch/1_4206_661394635.dbf Caution: Your use of any information or materials on this website is entirely at your own risk. what if the cron didnt run at the time it was supposed to?????? #sql alter system switch logfile; 949 157.76M DISK 00:00:28 02-FEB-10 crosscheck archivelog all; (LogOut/ -rw-r 1 oracle oinstall 1370094592 Feb 2 02:20 ARCH_20l4vguu_1_1 -rw-r 1 oracle oinstall 2329600 Feb 2 08:48 ARCH_1094_1_26l507ua 2767 1 4207 A 01-FEB-10 /oracle_db_storage/testb/arch/1_4207_661394635.dbf 2775 1 4215 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4215_661394635.dbf

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:09 Thrd Seq Low SCN Low Time Next SCN Next Time 948 3.66M DISK 00:00:02 02-FEB-10 RMAN> backup as compressed backupset archivelog all not backed up 1 times format /oracle_db_storage/rman/arch/ARCH_%s_%p_%u; Starting backup at 02-FEB-10

One thing you might want to try as well is this rman script: RMAN> BACKUP TABLESPACE system, sysaux, users; SQL>SQL>SQL> select scn_to_timestamp(4336877)as timestamp from dual; TIMESTAMP04-AUG-21 03.00.21.000000000 PM. One way to remove that ambiguity is connect to the appropriate PDB.

Next time you run this, no matter how much later, it will only backup anything created since. 1997-document.write(new Date().getFullYear()); Commvault Systems Inc. All Rights Reserved. - - - - We can send you a link when your PDF is ready to download. #sql alter system archive log current; skipping archive log file /oracle_db_storage/testb/arch/1_4209_661394635.dbf; already backed up 1 time(s) -rw-r 1 oracle oinstall 165422592 Feb 2 08:46 ARCH_1091_1_23l507qs 2784 1 4224 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4224_661394635.dbf

All rights reserved. 1 4214 1019928942 02-FEB-10 1021002663 02-FEB-10 allocated channel: ORA_DISK_2 Change).

rman target /Recovery Manager: Release 10.2.0.3.0 Production on Tue Feb 2 10:20:18 2010Copyright (c) 1982, 2005, Oracle. - - - - RMAN> BACKUP INCREMENTAL FROM SCN 3164433 DATABASE FORMAT /data/rmann_%U tag SCNBACKUP; Consider following example, here we are performing DBPITR to the date time : 27-Jan-2019 15:00:00, RMAN> startup mount;connected to target database (not started)Oracle instance starteddatabase mounted, Total System Global Area 408981760 bytesFixed Size 3212896 bytesVariable Size 392941024 bytesDatabase Buffers 109051904 bytesRedo Buffers 4775936 bytes, RMAN> RUN {set until time to_date(27-JAN-2019 15:00:00,DD-MON-YYYY HH24:MI:SS);restore database;recover database;alter database open resetlogs; }. 2791 1 4231 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4231_661394635.dbf. Could you pls help how to achieve this ?. piece handle=/oracle_db_storage/rman/arch/ARCH_1097_1_29l50dhm tag=TAG20100202T102350 comment=NONE PATH=$PATH:$ORACLE_HOME/bin; export PATH Piece Name: /oracle_db_storage/testb/backup/flash_recovery_area/TESTB/backupset/2010_02_02/o1_mf_annnn_TAG20100202T032714_5pj30msg_.bkp, List of Archived Logs in backup set 946 Fri Full RMAN Backup with Archived Logs Finished backup at 02-FEB-10. #!/usr/bin/bash current log archived (/script) 1 4207 1012877056 01-FEB-10 1013474586 01-FEB-10 1 4201 1011043347 01-FEB-10 1011335909 01-FEB-10 skipping archive log file /oracle_db_storage/testb/arch/1_4202_661394635.dbf; already backed up 1 time(s) skipping archive log file /oracle_db_storage/testb/arch/1_4203_661394635.dbf; already backed up 1 time(s) 1 4219 1022870984 02-FEB-10 1022870999 02-FEB-10, BS Key Size Device Type Elapsed Time Completion Time Key Thrd Seq S Low Time Name 1 4209 1014571999 01-FEB-10 1015662867 02-FEB-10 BP Key: 946 Status: AVAILABLE Compressed: YES Tag: TAG20100202T032714

-rw-r 1 oracle oinstall 1239040 Feb 2 10:23 ARCH_1098_1_2al50dhm Thrd Seq Low SCN Low Time Next SCN Next Time (LogOut/ #delete noprompt archivelog all completed before sysdate 1; 2781 1 4221 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4221_661394635.dbf allocate channel a1 type disk;

rman target $TARGET_CONNECT_STR log=/oracle_rmanbkp/archive_$DATE.txt <, Select checkboxes from the left navigation to add pages to your PDF. BP Key: 944 Status: AVAILABLE Compressed: YES Tag: TAG20100202T021557 Starting Real time Oracle DBA Training from next week. Thrd Seq Low SCN Low Time Next SCN Next Time 2784 1 4224 A 02-FEB-10 /oracle_db_storage/testb/arch/1_4224_661394635.dbf 1 4227 1023219584 02-FEB-10 1023219598 02-FEB-10, BS Key Size Device Type Elapsed Time Completion Time Thrd Seq Low SCN Low Time Next SCN Next Time 1 4205 1012256376 01-FEB-10 1012576084 01-FEB-10 Piece Name: /oracle_db_storage/rman/arch/ARCH_1098_1_2al50dhm, List of Archived Logs in backup set 953 It is provided for educational purposes only. Piece Name: /oracle_db_storage/rman/arch/ARCH_1097_1_29l50dhm, List of Archived Logs in backup set 954 To create an image copy of a specific datafile use: How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump.