OraFAQ Forum: Backup & Recovery » backup ran in two different media causing backup failures

Home » RDBMS Server » Backup & Recovery » backup ran in two different media causing backup failures (solaris 10 oracle 10.2.0.3)

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

backup ran in two different media causing backup failures [message #355635]

Sun, 26 October 2008 12:39

pavan27
Messages: 50
Registered: December 2006
Location: bangalore

Member

hello experts,

one of my production archive backup are failing. when i look archive log summary, i found backup is ran on two different media.

usually we take archive backup on Tape, one backup is ran on disk from there onwards all my backup are failing.

correct me if i am worng. if backup is ran two different media
will is cause failures.

2142    B  A  A SBT_TAPE    24-OCT-08       1       1       NO         TAG20081024T013305
2143    B  F  A SBT_TAPE    24-OCT-08       1       1       NO         ARCHIVESET_CTL
2144    B  A  A SBT_TAPE    24-OCT-08       1       1       NO         TAG20081024T043237
[B]2145    B  F  A DISK        24-OCT-08       1       1       NO         ARCHIVESET_CTL[/B]
2146    B  F  A SBT_TAPE    25-OCT-08       1       1       NO         TAG20081025T090111
2147    B  F  A SBT_TAPE    25-OCT-08       1       1       NO         TAG20081025T090111
2148    B  F  A SBT_TAPE    25-OCT-08       1       1       NO         TAG20081025T090111
2149    B  F  A SBT_TAPE    25-OCT-08       1       1       NO         ARCHIVESET_CTL
2150    B  A  A SBT_TAPE    25-OCT-08       1       1       NO         TAG20081025T215354
2151    B  A  A SBT_TAPE    25-OCT-08       1       1       NO         TAG20081025T215354

please guide me to fix this problme.

Report message to a moderator

Re: backup ran in two different media causing backup failures [message #355649 is a reply to message #355635]

Sun, 26 October 2008 19:05

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What is the output of show all and can you post your backup script ?

Do you happen to have a log of the backups that you conducted during this time ?

Report message to a moderator

Re: backup ran in two different media causing backup failures [message #355653 is a reply to message #355649]

Sun, 26 October 2008 21:45

pavan27
Messages: 50
Registered: December 2006
Location: bangalore

Member

Ebrian,

Thanks for reply. here is the show all content.
i did not see any log file for this. i believe some one ran this script instead of our shell script.

is there any possibility to track it. or at least log file.

my question is there any reason to backup failures after backup on the disk?
could you please clarify me?

is there any possibility to get log file based on tag?

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
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 '/opt/mis/oracle/product/10.2.0.2/dbs/snapcf_UMGPRD2.f'; # default

[Updated on: Sun, 26 October 2008 21:46]

Report message to a moderator

Re: backup ran in two different media causing backup failures [message #355654 is a reply to message #355653]

Sun, 26 October 2008 21:58

ebrian
Messages: 2794
Registered: April 2006

Senior Member

pavan27 wrote on Sun, 26 October 2008 22:45

my question is there any reason to backup failures after backup on the disk?

I'm still not sure what you mean by this ?

You can backup to disk and sbt if the channels are being allocated manually, which seems to be the case since nothing appears to be configured with your show all output.

For logging information, you may want to check V$RMAN_BACKUP_JOB_DETAILS.

Report message to a moderator

Re: backup ran in two different media causing backup failures [message #355663 is a reply to message #355654]

Sun, 26 October 2008 23:43

pavan27
Messages: 50
Registered: December 2006
Location: bangalore

Member

my question is

in the past we are taking backup on tape.
on 24th the backup was ran on the disk. from there onwards
backup on tape are failing.

so what i am thinking is if we change the media from tape to disk
and disk to tape, will it cause any problem.

Report message to a moderator

Re: backup ran in two different media causing backup failures [message #355802 is a reply to message #355663]

Mon, 27 October 2008 11:18

ebrian
Messages: 2794
Registered: April 2006

Senior Member

That should not cause any problems at all.

Report message to a moderator

Previous Topic:	Change path of backup archivelogs
Next Topic:	RMAN DELETE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 12:48:18 CST 2024