Re: How can be configured an expire period for archivelogs?

"Alexander Prohorenko" <alexander.prohorenko_at_gmail.com> a écrit dans le message de news:1106832640.490635.50510_at_z14g2000cwz.googlegroups.com...
| Hello.
|
| I have used Oracle Enterprise Manager (Oracle10g) for configuring
| backup policy.
|
| Maintenance -> Configure Backup Settings -> Policy ->
| Retention Policy
|
| I have checked "Retain backups that are necessary for a recovery to any
| time within the specified number of days (point-in-time recovery)" and
| configured to "5" days. However, I have archivelogs for a much longer
| period:
|
| oracle_at_downtown:~>ls -al /u03/flash_recovery_area/ORADB/archivelog/
| total 24
| drwxr----- 10 oracle oinstall 512 Jan 27 00:39 .
| drwxr----- 5 oracle oinstall 512 Jan 25 13:03 ..
| drwxr----- 2 oracle oinstall 512 Jan 17 18:35 2005_01_17
| drwxr----- 2 oracle oinstall 512 Jan 18 18:41 2005_01_18
| drwxr----- 2 oracle oinstall 512 Jan 19 12:36 2005_01_19
| drwxr-x--- 2 oracle oinstall 1024 Jan 23 21:52 2005_01_23
| drwxr-x--- 2 oracle oinstall 1024 Jan 24 23:26 2005_01_24
| drwxr-x--- 2 oracle oinstall 3072 Jan 25 23:29 2005_01_25
| drwxr-x--- 2 oracle oinstall 1024 Jan 26 23:29 2005_01_26
| drwxr-x--- 2 oracle oinstall 1024 Jan 27 14:54 2005_01_27
|
| So, the question is, how can I configure how much days to keep
| archivelogs for? And why does it ignore my current settings?
| Thank you.
|

The question is: "When did you make your previous datafile backups?". If you didn't backup your datafiles between 01/17 and 01/23, Oracle have to keep the backup of archived logs from the previous backup of datafiles to be able to recover at, for instance, 01/23, 01/24 and so on.

Regards
Michel Cadot Received on Thu Jan 27 2005 - 11:50:50 CST