Home » RDBMS Server » Backup & Recovery » backup archivelog all delete input
backup archivelog all delete input [message #281358] Fri, 16 November 2007 08:58 Go to next message
garry143
Messages: 17
Registered: November 2007
Junior Member
Hi there,

I have question about backup archivelog all delete input command.
Follwoing is output of my show all command
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'e:\flash_recove
ry_area\bblprd02\backupset\control_file_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME
TO 'D:\ORACLE\PRODUCT\10.2.\DB_1\DATABASE\SNCFBBLPRD02.ORA'; # default

I just ran backup archivelog all delete input cmd. and all my archivelogs are gone. i don't do tape backups, our sys admin does it.. and itz a dev database, and im not sure if we do take tape backups of this database. So my questions is where did all the archivelogs are gone. Did rman saved them somwhere???
Any help would be appreciated.
Thanks
Re: backup archivelog all delete input [message #281367 is a reply to message #281358] Fri, 16 November 2007 09:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They are deleted after backup as specified.

Regards
Michel
Re: backup archivelog all delete input [message #281372 is a reply to message #281358] Fri, 16 November 2007 10:24 Go to previous messageGo to next message
garry143
Messages: 17
Registered: November 2007
Junior Member
thanx for ur reply , but where r the backups stored
Re: backup archivelog all delete input [message #281374 is a reply to message #281372] Fri, 16 November 2007 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Where you specify it in the backup command.
In the flash recovery area by default.

Regards
Michel
Re: backup archivelog all delete input [message #281377 is a reply to message #281358] Fri, 16 November 2007 10:34 Go to previous messageGo to next message
garry143
Messages: 17
Registered: November 2007
Junior Member
i jus ran the follwoing cmd
backup archivelog all delete input
n my archivelogs disappeared
so r they stored in flash r area now
Re: backup archivelog all delete input [message #281380 is a reply to message #281377] Fri, 16 November 2007 10:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Don't use IM speak
2/ They are nowhere but in the backup which is in the FRA

Regards
Michel

[Updated on: Fri, 16 November 2007 10:43]

Report message to a moderator

Previous Topic: report obsolete
Next Topic: Database needs recovery (3 merged)
Goto Forum:
  


Current Time: Sun Dec 04 18:56:26 CST 2016

Total time taken to generate the page: 0.10029 seconds