Advertisement

06.05.2008 at 06:57AM PDT, ID: 23460156
[x]
Attachment Details

Oracle RMAN backup of archivelogs

Asked by dan_glos in Oracle 10.x

Tags: oracle, Oracle 10g, ORA-19715: invalid format for generated name

Hi,

I tend to do an RMAN coldback of my DB using a "backup database" command in RMAN and it works fine.

I am trying to use RMAN to backup the archivelogs but it keeps spitting out the following errors:

ORA-19715: invalid format c for generated name
ORA-27302: failure occurred at: slgpn

I got it to run if I used the format option and specified the output without any format parameters but it then failed once it got to the backing up the control and spfile's.

Can someone please tell me what I am doing wrong and how to correct?

I would also be interested to see examples of anyones RMAN scripts if they are willing to share, if not.. no worries :)

Thanks

DanStart Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:

RMAN> show all;
 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 35;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/rman/%F_control_file_%d_%t_%U';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/backup/rman/%f_backup_%d_%t_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/backup/rman/%F_snapcf_arcsight_%d_%t_%U';
 
RMAN>
 
 
 
RMAN> backup archivelog all format '/backup/rman/archive_logs/archive_logs';
 
Starting backup at 05-JUN-08
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=80 recid=80 stamp=655421475
channel ORA_DISK_1: starting piece 1 at 05-JUN-08
channel ORA_DISK_1: finished piece 1 at 05-JUN-08
piece handle=/backup/rman/archive_logs/archive_logs tag=TAG20080605T084814 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 02:30:10
Finished backup at 05-JUN-08
 
Starting Control File and SPFILE Autobackup at 05-JUN-08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 06/05/2008 11:18:25
ORA-19715: invalid format c for generated name
ORA-27302: failure occurred at: slgpn
 
Keywords: Oracle RMAN backup of archivelogs
Title
1 rman
2 Archivelogs with export
3 RMAN and archivelogs
4 RMAN Backup on Oracle 9i RAC
5 archivelog - nologging
6 oracle 9.2 -rman backup set up-d…
 
Loading Advertisement...
 
[+][-]06.05.2008 at 07:25AM PDT, ID: 21719808

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.05.2008 at 07:34AM PDT, ID: 21719927

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.05.2008 at 08:16AM PDT, ID: 21720491

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]06.05.2008 at 08:36AM PDT, ID: 21720755

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle 10.x
Tags: oracle, Oracle 10g, ORA-19715: invalid format for generated name
Sign Up Now!
Solution Provided By: rolutola
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.05.2008 at 08:57AM PDT, ID: 21720992

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.06.2008 at 12:59AM PDT, ID: 21727044

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.06.2008 at 01:23AM PDT, ID: 21727154

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628