Home » RDBMS Server » Backup & Recovery » Archivelogs error
Archivelogs error [message #219047] Mon, 12 February 2007 12:36 Go to next message
Ksaravan
Messages: 17
Registered: January 2007
Location: Portland
Junior Member
What the below command will do? When i included in the below command im getting some error. Ex. I detelete Feb 1- 5 day archival i deleted manually.

backup as COMPRESSED BACKUPSET tag '%TAG' archivelog all;

Its failing because its looking Feb first archival folder under flash_reocery_area. But my question is why its looking Feb 1st archival. From when it will archive? what is the starting point if i give the above statement.



ORA-19625: error identifying file /u14/db10gr2/flash_recovery_area/DB10GR2/archi
velog/2007_02_01/o1_mf_1_14_2w4ysl8n_.arc



Regards
KS
Re: Archivelogs error [message #219057 is a reply to message #219047] Mon, 12 February 2007 13:53 Go to previous messageGo to next message
Ksaravan
Messages: 17
Registered: January 2007
Location: Portland
Junior Member
The below command is in 10g Rel 2 document.

BACKUP DEVICE TYPE sbt
ARCHIVELOG ALL FROM TIME 'SYSDATE-10'
DELETE ALL INPUT;

I dont want to delete archival files. just i want to take 1 day file daily. so

backup as COMPRESSED BACKUPSET tag '%TAG' archivelog all FROM TIME 'SYSDATE-1';

it's failing MAN-00558: error encountered while parsing input commands

can you please let me know can i use like this or not?
KS.
Re: Archivelogs error [message #219190 is a reply to message #219057] Tue, 13 February 2007 09:31 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Always use CODE tags for readable post.
Always post what you did, exact commands and exact errors you got (your session).
Describing what you did will not help much.
Previous Topic: Comparing Oracle 9i with 10g
Next Topic: Oracle 9i - Cannot delete Archived Redolog files
Goto Forum:
  


Current Time: Sat Dec 03 08:23:22 CST 2016

Total time taken to generate the page: 0.06872 seconds