Home » RDBMS Server » Backup & Recovery » RMAN: full backup error after incomplete RECOVERY
RMAN: full backup error after incomplete RECOVERY [message #160639] Mon, 27 February 2006 20:54 Go to next message
hannah00
Messages: 37
Registered: March 2005
Member
Hi all,

After testing a INCOMPLETELY RECOVERY of the database, I took a full backup right away then I have an errors as below:

Starting backup at 27-FEB-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 02/27/2006 16:17:55
ORA-06550: line 1, column 109:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated



But if I shutdown this databae right after imcomplete RECOVERY and run the full backup then everything worked fine.

Why am I getting the errors, I don't think we have to shutdown the DB after incomplete recovery, do we??? Is there a glitch somewhere on my backup/recovery strategy????

thanks all.
Re: RMAN: full backup error after incomplete RECOVERY [message #160733 is a reply to message #160639] Tue, 28 February 2006 03:46 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
hannah00 wrote on Mon, 27 February 2006 20:54

Hi all,

1.After testing a INCOMPLETELY RECOVERY of the database, I took a full backup right away then I have an errors as below:

2.But if I shutdown this databae right after imcomplete RECOVERY and run the full backup then everything worked fine.

thanks all.


Sorry, don't understand what's the difference between 1 and 2.

Can you show the problem clearly? What you have done after the recovery? What's your scripts for backup?

[Updated on: Tue, 28 February 2006 03:47]

Report message to a moderator

Re: RMAN: full backup error after incomplete RECOVERY [message #160815 is a reply to message #160639] Tue, 28 February 2006 08:11 Go to previous messageGo to next message
hannah00
Messages: 37
Registered: March 2005
Member
Ok the problem is:

After INCOMPLETE RECOVERY, I run the full backup and I got the error as shown above; however, if I shutdown the DB clean after INCOMPLETE RECOVERY and startup the database then run the backup and the full backup running fine.

The question is "is it a normal procedure (shutdown the DB) after INCOMPLETE BACKUP"??? If not, why am I getting the above error???

Re: RMAN: full backup error after incomplete RECOVERY [message #160828 is a reply to message #160815] Tue, 28 February 2006 09:44 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
I don't think "shutdown db" is required if you are sure the db is in a consistent status. Shutdown and restart the db will make sure that the db is in a consistent status.

Alex zeng
Previous Topic: Media recovery
Next Topic: clonning a database
Goto Forum:
  


Current Time: Wed Apr 24 05:19:22 CDT 2024