I went to a customer yesterday to deploy the RMAN backup. when running the shell script, I was prompted that I could not find the archive log, because the customer only performed the EXPDP logical export backup for the database, and each
I went to a customer yesterday to deploy the RMAN backup. when running the shell script, I was prompted that I could not find the archive log, because the customer only performed the EXPDP logical export backup for the database, and each
-Rw-r ----- 1 oracle oinstall 606 K Sep 24 ora10g-4175411955_20140924_859118422_297.arc
-Rw-r ----- 1 oracle oinstall 166 M Sep 24 :02 ora10g-4175411955_20140924_859118425_298.db
-Rw-r ----- 1 oracle oinstall 610 K Sep 24 ora10g-4175411955_20140924_859118562_299.arc
-Rw-r ----- 1 oracle oinstall 7.3 M Sep 24 :02 ora10g-c-4175411955-20140924-01.ctl
As you can see, the backups are all completed, and two log backup sets (arc), one Database Backup set (db), and the control file backup set (ctl) are generated ), note that because I have written the % s parameter in the script, we can find the order of RMAN backup from the time and sequence generated by the backup set generated above:
1. Back up the archive log files of existing databases that can be backed up
2. Back up the database
3. Switch the logs to back up the archived logs after full-Database Backup (even if you do not use RMAN> SQL "alter system archive log current"; to manually switch)
4. Backup of control files (including spfile, generated in the same backup set)
We can take a look at the detailed log output to have a deeper understanding of this sequence:
Starting backup at 24-914
Current log archived
Using channel ORA_DISK_1
Channel ORA_DISK_1: starting compressed archive log backupset
Channel ORA_DISK_1: specifying archive log (s) in backup set
Input archive log thread = 1 sequence = 11 recid = 216 stamp = 859118422
Channel ORA_DISK_1: starting piece 1 at 24-914
Channel ORA_DISK_1: finished piece 1 at 24-914
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 24-914
Starting backup at 24-914
Using channel ORA_DISK_1
Channel ORA_DISK_1: starting compressed full datafile backupset
Channel ORA_DISK_1: specifying datafile (s) in backupset
Input datafile fno = 00001 name =/u01/app/oracle/oradata/ora10g/system01.dbf
Input datafile fno = 00003 name =/u01/app/oracle/oradata/ora10g/sysaux01.dbf
Input datafile fno = 00002 name =/u01/app/oracle/oradata/ora10g/undotbs01.dbf
Input datafile fno = 00005 name =/u01/app/oracle/oradata/ora10g/example01.dbf
Input datafile fno = 00006 name =/u01/app/oracle/oradata/ora10g/zlm01.dbf
Input datafile fno = 00004 name =/u01/app/oracle/oradata/ora10g/users01.dbf
Channel ORA_DISK_1: starting piece 1 at 24-914
Channel ORA_DISK_1: finished piece 1 at 24-914
Channel ORA_DISK_1: backup set complete, elapsed time: 00:02:16
Finished backup at 24-914
Starting backup at 24-914
Current log archived
Using channel ORA_DISK_1
Channel ORA_DISK_1: starting compressed archive log backupset
Channel ORA_DISK_1: specifying archive log (s) in backup set
Input archive log thread = 1 sequence = 12 recid = 217 stamp = 859118561
Channel ORA_DISK_1: starting piece 1 at 24-914
Channel ORA_DISK_1: finished piece 1 at 24-914
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 24-914
Starting Control File and SPFILE Autobackup at 24-914
Finished Control File and SPFILE Autobackup at 24-914