| Full backup problem in OEM (OMS) using RMAN [message #60099] |
Thu, 15 January 2004 12:30  |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
Hi,
I'm running Oracle 9.2.0.4.0 on Solars 5.8. Recently I configured backup on OEM (running on OMS) USING RMAN (Recovery catalog database). The job is created using OEM by 1. Create backup configuration 2. Create Backup. When the job runs, it creates the following output. It looks like the backup is partially done and there are warnings about 1_188.arc archive file missing. And another warning about "objects cannot be deleted due to mismatched status". And to use CROSSCHECK.
I don't care about old archive logs. I just want a new backup from now on and use new archive logs. How can I fix this ??? I have multiplexed the logs. HELP PLEASE!!!. All I wanted to do is make this job work, without having to worry about the old 1_188.arc log.
Here's the output from the job:
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
connected to target database: ACDREP (DBID=3216716961)
RMAN>
connected to recovery catalog database
RMAN>
RMAN> run {
2> allocate channel Channel1 type disk format '/opt/dbsdta32/rmanbackups/b_%u_%p_%c';
3> backup
4> ( database include current controlfile );
5>
6> backup ( archivelog all delete input );
7>
8> }
allocated channel: Channel1
channel Channel1: sid=11 devtype=DISK
Starting backup at JAN 14 2004 23:05:12
channel Channel1: starting full datafile backupset
channel Channel1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=/opt/dbsdta02/acdrep/system01.dbf
input datafile fno=00008 name=/opt/dbsdta22/acdrep/tools01.dbf
input datafile fno=00002 name=/opt/dbsdta02/acdrep/undotbs01.dbf
channel Channel1: starting piece 1 at JAN 14 2004 23:05:14
channel Channel1: finished piece 1 at JAN 14 2004 23:06:19
piece handle=/opt/dbsdta32/rmanbackups/b_05fbii1a_1_1 comment=NONE
channel Channel1: backup set complete, elapsed time: 00:01:05
channel Channel1: starting full datafile backupset
channel Channel1: specifying datafile(s) in backupset
input datafile fno=00009 name=/opt/dbsdta22/acdrep/users01.dbf
input datafile fno=00005 name=/opt/dbsdta02/acdrep/example01.dbf
input datafile fno=00010 name=/opt/dbsdta02/acdrep/xdb01.dbf
input datafile fno=00006 name=/opt/dbsdta02/acdrep/indx01.dbf
input datafile fno=00003 name=/opt/dbsdta02/acdrep/cwmlite01.dbf
input datafile fno=00004 name=/opt/dbsdta02/acdrep/drsys01.dbf
input datafile fno=00007 name=/opt/dbsdta02/acdrep/odm01.dbf
channel Channel1: starting piece 1 at JAN 14 2004 23:06:20
channel Channel1: finished piece 1 at JAN 14 2004 23:07:25
piece handle=/opt/dbsdta32/rmanbackups/b_06fbii3c_1_1 comment=NONE
channel Channel1: backup set complete, elapsed time: 00:01:05
Finished backup at JAN 14 2004 23:07:25
Starting backup at JAN 14 2004 23:07:26
current log archived
released channel: Channel1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/14/2004 23:07:31
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /opt/dbsdta32/rdbms/log/archacdrep/1_188.arc
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
RMAN> allocate channel for maintenance device type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=11 devtype=DISK
RMAN> delete obsolete device type disk;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 310 JAN 12 2004 10:37:10
Backup Piece 312 JAN 12 2004 10:37:10 /opt/dbsdta32/rmanbackups/b_02fbbtco_1_1
Backup Set 333 JAN 12 2004 13:18:02
Backup Piece 335 JAN 12 2004 13:18:02 /opt/dbsdta32/rmanbackups/b_03fbc6ql_1_1
Backup Set 334 JAN 12 2004 13:18:56
Backup Piece 336 JAN 12 2004 13:18:56 /opt/dbsdta32/rmanbackups/b_04fbc6sc_1_1
Archive Log 253 DEC 27 2003 02:16:15 /opt/dbsdta32/rdbms/log/archacdrep/1_188.arc
Archive Log 254 DEC 28 2003 05:48:24 /var/oracle/9.2.0/rdbms/log/archacdrep/1_191.arc
Archive Log 255 DEC 28 2003 05:48:24 /opt/dbsdta32/rdbms/log/archacdrep/1_191.arc
Archive Log 256 DEC 29 2003 07:10:58 /var/oracle/9.2.0/rdbms/log/archacdrep/1_192.arc
Archive Log 257 DEC 29 2003 07:10:58 /opt/dbsdta32/rdbms/log/archacdrep/1_192.arc
Archive Log 258 DEC 29 2003 13:57:50 /var/oracle/9.2.0/rdbms/log/archacdrep/1_193.arc
Archive Log 259 DEC 29 2003 13:57:50 /opt/dbsdta32/rdbms/log/archacdrep/1_193.arc
Archive Log 260 DEC 29 2003 14:05:18 /var/oracle/9.2.0/rdbms/log/archacdrep/1_194.arc
Archive Log 261 DEC 29 2003 14:05:18 /opt/dbsdta32/rdbms/log/archacdrep/1_194.arc
Archive Log 262 DEC 29 2003 14:10:42 /var/oracle/9.2.0/rdbms/log/archacdrep/1_195.arc
Archive Log 263 DEC 29 2003 14:10:42 /opt/dbsdta32/rdbms/log/archacdrep/1_195.arc
Archive Log 264 DEC 29 2003 14:12:00 /var/oracle/9.2.0/rdbms/log/archacdrep/1_196.arc
Archive Log 265 DEC 29 2003 14:12:00 /opt/dbsdta32/rdbms/log/archacdrep/1_196.arc
Archive Log 266 DEC 30 2003 17:17:00 /var/oracle/9.2.0/rdbms/log/archacdrep/1_197.arc
Archive Log 267 DEC 30 2003 17:17:00 /opt/dbsdta32/rdbms/log/archacdrep/1_197.arc
Archive Log 268 DEC 31 2003 18:34:22 /var/oracle/9.2.0/rdbms/log/archacdrep/1_198.arc
Archive Log 269 DEC 31 2003 18:34:22 /opt/dbsdta32/rdbms/log/archacdrep/1_198.arc
Archive Log 270 JAN 01 2004 19:55:57 /var/oracle/9.2.0/rdbms/log/archacdrep/1_199.arc
Archive Log 271 JAN 01 2004 19:55:57 /opt/dbsdta32/rdbms/log/archacdrep/1_199.arc
Archive Log 272 JAN 02 2004 23:14:18 /var/oracle/9.2.0/rdbms/log/archacdrep/1_200.arc
Archive Log 273 JAN 02 2004 23:14:18 /opt/dbsdta32/rdbms/log/archacdrep/1_200.arc
Archive Log 276 JAN 03 2004 02:16:23 /var/oracle/9.2.0/rdbms/log/archacdrep/1_201.arc
Archive Log 277 JAN 03 2004 02:16:23 /opt/dbsdta32/rdbms/log/archacdrep/1_201.arc
Archive Log 274 JAN 03 2004 02:16:22 /var/oracle/9.2.0/rdbms/log/archacdrep/1_202.arc
Archive Log 275 JAN 03 2004 02:16:22 /opt/dbsdta32/rdbms/log/archacdrep/1_202.arc
Archive Log 278 JAN 03 2004 02:16:25 /var/oracle/9.2.0/rdbms/log/archacdrep/1_203.arc
Archive Log 279 JAN 03 2004 02:16:25 /opt/dbsdta32/rdbms/log/archacdrep/1_203.arc
Archive Log 280 JAN 04 2004 03:56:13 /var/oracle/9.2.0/rdbms/log/archacdrep/1_204.arc
Archive Log 281 JAN 04 2004 03:56:13 /opt/dbsdta32/rdbms/log/archacdrep/1_204.arc
Archive Log 282 JAN 05 2004 05:16:12 /var/oracle/9.2.0/rdbms/log/archacdrep/1_205.arc
Archive Log 283 JAN 05 2004 05:16:12 /opt/dbsdta32/rdbms/log/archacdrep/1_205.arc
Archive Log 284 JAN 05 2004 05:51:03 /var/oracle/9.2.0/rdbms/log/archacdrep/1_206.arc
Archive Log 285 JAN 05 2004 05:51:03 /opt/dbsdta32/rdbms/log/archacdrep/1_206.arc
Archive Log 286 JAN 05 2004 18:05:23 /var/oracle/9.2.0/rdbms/log/archacdrep/1_207.arc
Archive Log 287 JAN 05 2004 18:05:23 /opt/dbsdta32/rdbms/log/archacdrep/1_207.arc
Archive Log 350 JAN 12 2004 13:19:02 /var/oracle/9.2.0/rdbms/log/archacdrep/1_219.arc
Archive Log 351 JAN 12 2004 13:19:02 /opt/dbsdta32/rdbms/log/archacdrep/1_219.arc
Archive Log 356 JAN 13 2004 14:55:48 /var/oracle/9.2.0/rdbms/log/archacdrep/1_220.arc
Archive Log 357 JAN 13 2004 14:55:48 /opt/dbsdta32/rdbms/log/archacdrep/1_220.arc
Archive Log 359 JAN 14 2004 18:45:59 /opt/dbsdta32/rdbms/log/archacdrep/1_221.arc
Archive Log 358 JAN 14 2004 18:45:58 /var/oracle/9.2.0/rdbms/log/archacdrep/1_221.arc
deleted backup piece
backup piece handle=/opt/dbsdta32/rmanbackups/b_03fbc6ql_1_1 recid=3 stamp=515251029
deleted backup piece
backup piece handle=/opt/dbsdta32/rmanbackups/b_04fbc6sc_1_1 recid=4 stamp=515251084
deleted archive log
archive log filename=/var/oracle/9.2.0/rdbms/log/archacdrep/1_219.arc recid=436 stamp=515251142
deleted archive log
archive log filename=/opt/dbsdta32/rdbms/log/archacdrep/1_219.arc recid=437 stamp=515251142
deleted archive log
archive log filename=/var/oracle/9.2.0/rdbms/log/archacdrep/1_220.arc recid=438 stamp=515343348
deleted archive log
archive log filename=/opt/dbsdta32/rdbms/log/archacdrep/1_220.arc recid=439 stamp=515343348
deleted archive log
archive log filename=/opt/dbsdta32/rdbms/log/archacdrep/1_221.arc recid=441 stamp=515443559
deleted archive log
archive log filename=/var/oracle/9.2.0/rdbms/log/archacdrep/1_221.arc recid=440 stamp=515443558
Deleted 8 objects
RMAN-06207: WARNING: 36 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
List of Mismatched objects
==========================
Object Type Filename/Handle
--------------- ---------------------------------------------------
Backup Piece /opt/dbsdta32/rmanbackups/b_02fbbtco_1_1
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_188.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_191.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_191.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_192.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_192.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_193.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_193.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_194.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_194.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_195.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_195.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_196.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_196.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_197.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_197.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_198.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_198.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_199.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_199.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_200.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_200.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_201.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_201.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_202.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_202.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_203.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_203.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_204.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_204.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_205.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_205.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_206.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_206.arc
Archivelog /var/oracle/9.2.0/rdbms/log/archacdrep/1_207.arc
Archivelog /opt/dbsdta32/rdbms/log/archacdrep/1_207.arc
RMAN>
RMAN> **end-of-file**
RMAN>
Recovery Manager complete.
child process exited abnormally
|
|
|
|
|
|
| Re: Full backup problem in OEM (OMS) using RMAN [message #60101 is a reply to message #60100] |
Thu, 15 January 2004 14:36  |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
Hi,
I tried a crosscheck, but I'm getting the following error. PLEASE HELP.
oraadm: rman catalog=rman/xxx@rcat1 target=sys/xxx@acdrep
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ACDREP (DBID=3216716961)
connected to recovery catalog database
RMAN> crosscheck archivelog all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 01/15/2004 16:36:13
ORA-19550: cannot use backup/restore functions while using dispatcher
|
|
|
|
| Re: Full backup problem in OEM (OMS) using RMAN [message #60102 is a reply to message #60101] |
Thu, 15 January 2004 15:01 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You should use a dedicated server connection ( and not a shared server/dispatcher) when executing backup/restore commands.
IF you are on the same server as the target database,you could simply connect through ipc as
export ORACLE_SID=acdrep
rman target sys/xxx catalog rman/xxx@rcat1
IF you are on a remote node,then connect through tns connect string thats configured to use dedicated server(not SERVER=SHARED)
-Thiru
|
|
|
|
|
|
|
|
| Re: Full backup problem in OEM (OMS) using RMAN [message #179097 is a reply to message #60099] |
Sun, 25 June 2006 10:16 |
rajd
Messages: 6
Registered: June 2006
|
Junior Member |
|
|
Hi,
I have similar kind of problem where rman is asking for old archivelog. I am not using any catalog instead using nocatalog
rman taret /
RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
RMAN> backup archivelog all;
Starting backup at 25-JUN-06
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/25/2006 11:04:00
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u02/arch/dcsdb/1_984_586298089.dbf
ORA-17503: ksfdopn:4 Failed to open file /u02/arch/dcsdb/1_984_586298089.dbf
ORA-17500: ODM err:File does not exist
Please help me .
Thanks
Sujit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
