Home » RDBMS Server » Backup & Recovery » RMAN-08132 during backup archive logs on physical standby database.
RMAN-08132 during backup archive logs on physical standby database. [message #215981] Wed, 24 January 2007 09:06 Go to next message
fl@kimik-it.gl
Messages: 3
Registered: January 2007
Junior Member
Hi

After a long period working without any problems the backup have started to fail.

From the logfile:

Starting backup at 24-JAN-07
channel c1: starting compressed archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2055 recid=831 stamp=612702836
channel c1: starting piece 1 at 24-JAN-07
channel c1: finished piece 1 at 24-JAN-07
piece handle=/home/backup/table_comp_sby/PROD/ar_612702872_575_1 tag=TAG20070124T111432 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:08
channel c1: deleting archive log(s)
archive log filename=/home/backup/arch/PROD/1_2055_591458889.dbf recid=831 stamp=612702836
Finished backup at 24-JAN-07
RMAN-08132: WARNING: cannot update recovery area reclaimable file list
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of REFAF command on default channel at 01/24/2007 11:14:41
ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only


The problem has started after a shutdown/startup of the database.

Have tried Metalink and Google without any luck.

Info:
OS: SLES 9 SP2 64 bit.
DB: Oracle 10.2.0.1.0 64 bit.


What can I do to solve this problem ?
Re: RMAN-08132 during backup archive logs on physical standby database. [message #215988 is a reply to message #215981] Wed, 24 January 2007 09:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
ORA-01219: database not open: queries allowed on fixed tables/views only

Error seems to be self explanative.
If that is not your case, it may be bug#Bug 4459962.
Check metalink
Re: RMAN-08132 during backup archive logs on physical standby database. [message #216016 is a reply to message #215988] Wed, 24 January 2007 11:50 Go to previous messageGo to next message
fl@kimik-it.gl
Messages: 3
Registered: January 2007
Junior Member
Hi

It was something else than expected.

It looked like someone had copied the orapw$ORACLE_SID file from master to standby after changeing system password.

I created a new orapw$ORACLE_SID on the standby, and that solved the problem.
Re: RMAN-08132 during backup archive logs on physical standby database. [message #434839 is a reply to message #216016] Fri, 11 December 2009 03:34 Go to previous message
vahidtaj
Messages: 1
Registered: December 2009
Location: iran
Junior Member
you need to run below procedure to clear the entire backup piece section of the controlfile:
SQL> execute dbms_backup_restore.resetcfilesection(13);
regards.
vahid tajbakhsh
Previous Topic: retrieving oradata files
Next Topic: Decide size of LEVEL 0 RMAN backups
Goto Forum:
  


Current Time: Sat Apr 27 03:07:52 CDT 2024