OraFAQ Forum: Backup & Recovery » Archivelog Backup

Home » RDBMS Server » Backup & Recovery » Archivelog Backup (10.2.0.3;windows server x64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Archivelog Backup [message #636509]

Mon, 27 April 2015 04:53

surmaa013
Messages: 20
Registered: April 2015
Location: delhi

Junior Member

Hi all ,

Since there is full Rman backup in run on our DB server .So in case of full recovery Do I need to backup the archive files also ?

Report message to a moderator

Re: Archivelog Backup [message #636511 is a reply to message #636509]

Mon, 27 April 2015 05:24

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Full cold or hot backup?
Do you want to restore only the backup or recover up to a specific time? (or to put it clearer, in case of disk failure, do you want to lose all transactions since the last backup or not?).

[Updated on: Mon, 27 April 2015 05:25]

Report message to a moderator

Re: Archivelog Backup [message #636512 is a reply to message #636509]

Mon, 27 April 2015 05:40

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

RMAN Backup Database documentation.

Report message to a moderator

Re: Archivelog Backup [message #636520 is a reply to message #636511]

Mon, 27 April 2015 06:22

surmaa013
Messages: 20
Registered: April 2015
Location: delhi

Junior Member

Hi ,

we take full hot backup on daily basis . No I dont want to lose any transaction .

Report message to a moderator

Re: Archivelog Backup [message #636530 is a reply to message #636520]

Mon, 27 April 2015 07:16

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

surmaa013 wrote on Mon, 27 April 2015 06:22

Hi ,

we take full hot backup on daily basis . No I dont want to lose any transaction .

then you should also be backing up your archivelogs .... and your control files .... and your spfile

And to prevent your archivelog destination from filling up and locking the database, you should be deleting the archivelogs after they are backed up.

Report message to a moderator

Re: Archivelog Backup [message #636535 is a reply to message #636530]

Mon, 27 April 2015 07:52

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

you should be deleting the archivelogs after they are backed up.

or use DELETE INPUT option of BACKUP command.

Report message to a moderator

Re: Archivelog Backup [message #636574 is a reply to message #636535]

Tue, 28 April 2015 08:11

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Michel Cadot wrote on Mon, 27 April 2015 07:52

Quote:
you should be deleting the archivelogs after they are backed up.

or use DELETE INPUT option of BACKUP command.

Yes, that is one way of deleting the archivelogs after they are backed up. Actually, that is exactly the method I use and prefer, but I know other people do it a bit differently.

rman> backup archivelog delete all input;

Report message to a moderator

Re: Archivelog Backup [message #636575 is a reply to message #636574]

Tue, 28 April 2015 08:13

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

I'm sure it's only a typo but that command should read:

RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;

Report message to a moderator

Re: Archivelog Backup [message #636579 is a reply to message #636575]

Tue, 28 April 2015 08:57

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

gazzag wrote on Tue, 28 April 2015 08:13

I'm sure it's only a typo but that command should read:

RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;

No typo.
ARCHIVELOG ALL

and

DELETE ALL INPUT

are two different things.

Report message to a moderator

Re: Archivelog Backup [message #636580 is a reply to message #636579]

Tue, 28 April 2015 09:12

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Apr 28 15:09:25 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target /

connected to target database: XE (DBID=XXXXXXXXXX)

RMAN> backup archivelog delete all input;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "delete": expecting one of: "all, from, high, like, low, scn, sequence, time, until"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>

RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;

Starting backup at 28-APR-15
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=3 STAMP=876484816
input archived log thread=1 sequence=2 RECID=4 STAMP=877683579
input archived log thread=1 sequence=3 RECID=5 STAMP=878223661
input archived log thread=1 sequence=4 RECID=6 STAMP=878224266
channel ORA_DISK_1: starting piece 1 at 28-APR-15
channel ORA_DISK_1: finished piece 1 at 28-APR-15
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2015_04_28\O1_MF_ANNNN_TAG20150428T151106_BMZ57TO2_.
BKP tag=TAG20150428T151106 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2015_04_08\O1_MF_1_1_BLB2KZYQ_.ARC RECID=
3 STAMP=876484816
archived log file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2015_04_22\O1_MF_1_2_BMGO7BVT_.ARC RECID=
4 STAMP=877683579
archived log file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2015_04_28\O1_MF_1_3_BMZ4NX0L_.ARC RECID=
5 STAMP=878223661
archived log file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2015_04_28\O1_MF_1_4_BMZ57SYW_.ARC RECID=
6 STAMP=878224266
Finished backup at 28-APR-15

RMAN>

[Updated on: Tue, 28 April 2015 09:13]

Report message to a moderator

Previous Topic:	tablespace defragmentation
Next Topic:	Restore of Fresh Backup giving 06026 RMAN error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 00:57:04 CST 2025