Home » RDBMS Server » Backup & Recovery » Archivelog Backup (10.2.0.3;windows server x64)
icon5.gif  Archivelog Backup [message #636509] Mon, 27 April 2015 04:53 Go to next message
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 ?
Re: Archivelog Backup [message #636511 is a reply to message #636509] Mon, 27 April 2015 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
gazzag
Messages: 986
Registered: November 2010
Location: Bristol, UK
Senior Member
RMAN Backup Database documentation.
Re: Archivelog Backup [message #636520 is a reply to message #636511] Mon, 27 April 2015 06:22 Go to previous messageGo to next message
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 .
Re: Archivelog Backup [message #636530 is a reply to message #636520] Mon, 27 April 2015 07:16 Go to previous messageGo to next message
EdStevens
Messages: 981
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.
Re: Archivelog Backup [message #636535 is a reply to message #636530] Mon, 27 April 2015 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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


or use DELETE INPUT option of BACKUP command.

Re: Archivelog Backup [message #636574 is a reply to message #636535] Tue, 28 April 2015 08:11 Go to previous messageGo to next message
EdStevens
Messages: 981
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;
Re: Archivelog Backup [message #636575 is a reply to message #636574] Tue, 28 April 2015 08:13 Go to previous messageGo to next message
gazzag
Messages: 986
Registered: November 2010
Location: Bristol, UK
Senior Member
I'm sure it's only a typo but that command should read:

RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;
Re: Archivelog Backup [message #636579 is a reply to message #636575] Tue, 28 April 2015 08:57 Go to previous messageGo to next message
EdStevens
Messages: 981
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.

Re: Archivelog Backup [message #636580 is a reply to message #636579] Tue, 28 April 2015 09:12 Go to previous message
gazzag
Messages: 986
Registered: November 2010
Location: Bristol, 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:
  


Current Time: Fri Oct 19 02:22:02 CDT 2018