ALTER DATABASE OPEN RESETLOGS; [message #70811] |
Fri, 26 July 2002 05:57 |
Phil
Messages: 32 Registered: March 2001
|
Member |
|
|
I am trying to backup the archive logs for an oracle 8.1.7 database. The backup starts but is looking for archivelog number 1. This log was accidentally deleted, I have tried the above statement but svrmgr says that it is an invalid command unless an incomplete recovery has been performed. How else can I reset the logs?
Cheers
|
|
|
Re: ALTER DATABASE OPEN RESETLOGS; [message #70812 is a reply to message #70811] |
Fri, 26 July 2002 12:10 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
I am assuming u r using rman. If u r u need to crosscheck your repository with your DB. Connect and run:
RMAN> change archivelog all crosscheck;
This command is used when you have a corrupt or missing archive log.
|
|
|
Re: ALTER DATABASE OPEN RESETLOGS; [message #70845 is a reply to message #70811] |
Mon, 29 July 2002 23:55 |
Phil
Messages: 32 Registered: March 2001
|
Member |
|
|
we are not using a recovery catalog, the error messages we receive from the backup software are as follows:
Recovery Manager: Release 8.0.5.0.0 - Production
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-06005: connected to target database: DS
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DS,OB2BARLIST=IXOS_DS_ARCHIVE)';
4> backup incremental level 0 filesperset 1
5> format 'IXOS_DS_ARCHIVE<DS_%s:%t:%p>.dbf'
6> archivelog all delete input
7> ;
8> }
9>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev_0
RMAN-08500: channel dev_0: sid=31 devtype=SBT_TAPE
RMAN-03022: compiling command: backup
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: dev_0
RMAN-00569: ================error message stack follows================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log L:ORADATADSARCDS0000000001.ARC not found or out of sync with catalog
Regards
Phil
|
|
|
Re: ALTER DATABASE OPEN RESETLOGS; [message #70847 is a reply to message #70811] |
Tue, 30 July 2002 03:12 |
Phil Allwood
Messages: 2 Registered: July 2002
|
Junior Member |
|
|
we are not using a recovery catalog, the error messages we receive from the backup software are as follows:
Recovery Manager: Release 8.0.5.0.0 - Production
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-06005: connected to target database: DS
RMAN-06089: archived log L:ORADATADSARCDS0000000001.ARC not found or out of sync with catalog
Regards
Phil
|
|
|
Re: ALTER DATABASE OPEN RESETLOGS; [message #70851 is a reply to message #70811] |
Tue, 30 July 2002 05:45 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
At this point I do not know how to tell the control file how to ignore the file. I would suggest logging a call with Oracle or maybe someone on the message board has had this problem and knows how to fix it.
|
|
|