| Re: ALTER DATABASE OPEN RESETLOGS;--updated [message #70857] |
Tue, 30 July 2002 08:55  |
 |
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  |
Phil Allwood
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
Hi,
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 8.0.5.0.0 - 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
RMAN>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
