Help - Search - Members - Calendar
Full Version: RMAN-03002, RMAN-06136, ORA-02236
Oracle DBA Forums > Oracle > Oracle Forum
OraLily
Hi:
I am doing a RMAN clone (11.1.0.7 on linux) and it were through, But I got errors at the end saying:
===
database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 1071333376 bytes

Fixed Size 1318172 bytes
Variable Size 427819748 bytes
Database Buffers 629145600 bytes
Redo Buffers 13049856 bytes
allocated channel: aux1
channel aux1: SID=426 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PRODDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 2268
LOGFILE
GROUP 1 SIZE 100 M ,
GROUP 2 SIZE 100 M ,
GROUP 3 SIZE 100 M ,
GROUP 4 SIZE 100 M ,
GROUP 5 SIZE 100 M
DATAFILE
'+DATADG/proddb/datafile/system.867.772215399'
CHARACTER SET US7ASCII

released channel: aux1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/10/2012 17:16:27
RMAN-06136: ORACLE error from auxiliary database: ORA-02236: invalid file name.
====

(I have pfile but no spfile, problem?) What is the problem?

I got the following from internet but don't where to start?
====
Error: ORA 2236
Text: invalid filename


--------------------------------------------------------------------------------
Cause: In a LOGFILE, DATAFILE, or RENAME clause, a character string literal
was expected, but not found, in a filename list.
Action: Specify filenames using character string literals and try again.
====

Thank you very much for your help in advance.
aussie_dba
Lilly,

First, review notes on an RMAN clone:

http://dba-oracle.com/t_rman_clone_copy_database.htm


********************************************8
>> oerr RMAN 06136

CODE
RMAN-06136 ORACLE error from auxiliary database: string

Cause: This message should be accompanied by other error messages indicating the cause of the error.

Action: Check the accompanying errors.


****************************************
>> oerr ORA-02236

CODE
ORA-02236: invalid file name

Cause: A character string literal was not used in the filename list of a LOGFILE, DATAFILE, or RENAME clause.

Action: Use correct syntax.


Well. it looks like the file cannot be found in the database . . . .


+DATADG/proddb/datafile/system.867.772215399'

What is the full path?

remove the +DATAG and hard=code the file name path.
burleson
Hi Lilly,

See my notes on the RMAN duplicate command:

http://www.dba-oracle.com/t_rman_duplicate...nstance_sid.htm

There is also a vodeo to watch, step-by-step.

I would be expecting to see file names in these places:

CODE
LOGFILE
GROUP 1 SIZE 100 M ,
GROUP 2 SIZE 100 M ,
GROUP 3 SIZE 100 M ,
GROUP 4 SIZE 100 M ,
GROUP 5 SIZE 100 M
DATAFILE
'+DATADG/proddb/datafile/system.867.772215399'


Like this:

CODE
logfile
group 1 ('/path/to/redo1.log') size 100M,

group 2 ('/path/to/redo2.log') size 100M,

group 3 ('/path/to/redo3.log') size 100M

character set WE8ISO8859P1

national character set utf8

datafile '/path/to/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local



http://www.dba-oracle.com/t_ora_02236.htm
OraLily
Thank you both. Your links really helped me.

May I ask, when clone a database using RMAN, where to specify which backup it takes. We have two backups every day. I don't know which one it will take.
burleson
Hi Lily,

http://dba-oracle.com/t_rman_clone_copy_database.htm

Here you specify the control file:

RMAN> restore controlfile from '/u01/oracle/product/ora10g/dbs/c-3932056136-20070213-02';

And the backuppiece:

RMAN> catalog backuppiece '/home/oracle/test/backup/o1_mf_annnn_TAG20070213T002925_2x21m6ty_.bkp';

OraLily
Our script is very simple and I don't see anywhere it says anything about backup location.

rman TARGET SYS/pass PRODDB CATALOG PRODDB/proddb@rmanback AUXILIARY sys/DBADB LOG ...
run {
SET UNTIL SEQUENCE 89165 THREAD 1;
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO "DBADB" nofilenamecheck;
}

I don't do command you gave to me before running the script.
burleson
>> DUPLICATE TARGET DATABASE

I;ve asled a RMAN expert to pop-in and advise you.
OraLily
Sir:

Now i encontered new problems as listed below. The script is very simple as listed below. Before firing the script i go to the backup log file to find the last sequence number then add 1 then put in the set until sequence 89165 thread 1. Please help to fix it.

===== script ====
run {
SET UNTIL SEQUENCE 89165 THREAD 1;
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO "DBA" nofilenamecheck;
}

====== errors ===
contents of Memory Script:
{
set until scn 11158682274;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 20-JAN-12

starting media recovery

channel aux1: starting archived log restore to default destination
channel aux1: restoring archived log
archived log thread=1 sequence=89163
channel aux1: restoring archived log
archived log thread=1 sequence=89164
channel aux1: restoring archived log
archived log thread=1 sequence=89165
channel aux1: reading from backup piece /stage_rman/rmanbackup/PROD/arch/al_773066408_215188_1
channel aux1: ORA-19870: error while restoring backup piece /stage_rman/rmanbackup/PROD/arch/al_773066408_215188_1
ORA-19504: failed to create file "+FRADG/archive/1_89165_504368731.dbf"
ORA-17502: ksfdcre:4 Failed to create file +FRADG/archive/1_89165_504368731.dbf
ORA-15173: entry 'archive' does not exist in directory '/'
...

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/19/2012 17:36:15
RMAN-03015: error occurred in stored script Memory Script
RMAN-20506: no backup of archived log found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 89163 and starting SCN of 11158664662 found to restore
burleson
Hi,

>> Please help to fix it.

SORRY, WE DO NOT HAVE THE RESOURCE TO PROVIDE TECH SUPPORT.

WE ONLY ANSWER SPECIFIC QUESTION HERE!

This is a forum for BC customers. Are you a client of ours?

If you want emergency support and you don't want to call Oracle, you can call BC at 800-766-1884 and we can assign a certified DBA to mentor you.


************************************
>> RMAN-06053: unable to perform media recovery because of missing log

Have you set up your archive logs in the RMAN catalog?


************************************
>> ORA-19504: failed to create file "+FRADG/archive/1_89165_504368731.dbf"

This sounds like a permissions issue.

Also Read this:

http://www.rampant-books.com/t_schneider_r...nge_db_name.htm

Open an SR on MOSC, that what your license fee pays for:

http://support.oracle.com

Good Luck!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.