Home » RDBMS Server » Backup & Recovery » Re: ALTER DATABASE OPEN RESETLOGS;--updated
Re: ALTER DATABASE OPEN RESETLOGS;--updated [message #70857] Tue, 30 July 2002 08:55 Go to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
there was some HTML formatting mistakes in the prior post.

1. Type "rman target user_name/password@(connect_string nocatalog"
2. Type the following command: "list copy of database archivelog all;"
This command lists all of the archive logs
3. You need to remove any archive logs that exist in
the resulting list that do not exist on the disk
drive. You will need the key value (first column in
the list). Type the following to delete an archive
log: "change archivelog <key> delete;"
You can also use a comma separated list if you have
several archivelogs to delete.
4. Rerun the command in step 2 to verify that the
archivelog has indeed been deleted.

5. Exit RMAN and retry the backup.
Re: ALTER DATABASE OPEN RESETLOGS;--updated [message #70862 is a reply to message #70857] Wed, 31 July 2002 00:09 Go to previous message
Phil Allwood
Messages: 2
Registered: July 2002
Junior Member

The command in step2 displays the following command (probably due to the fact that I said it was an 8.1.7 database when it is actually an 8.0.5! Sorry!)

Recovery Manager: Release - Production

RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-06005: connected to target database: DS

RMAN> list copy of database archivelog all;

RMAN-00569: ================error message stack follows================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "ARCHIVELOG_": expecting one of: "DEVICE_, FROM_
, LIKE_, SEMI_, SKIP_, TAG_, UNTIL_" etc..
RMAN-01007: at line 1 column 23 file: standard input

Previous Topic: RMAN problem
Next Topic: RMAN-06000:
Goto Forum:

Current Time: Sat Sep 23 06:55:04 CDT 2023