Debug Trace=Debug

Debug trace=debug.log

Restore Process July 4th:

RMAN:

NLS_LANG=American_America.WE8ISO8859P1

NLS_NUMERIC_CHARACTERS=.,

NLS_SORT=binary

NLS_DATE_FORMAT=YYYY-MM-DD HH:MI:SS

TARGET:
NLS_LANG=American_America.WE8ISO8859P1

NLS_NUMERIC_CHARACTERS=.,

NLS_SORT=binary

NLS_DATE_FORMAT=YYYY-MM-DD HH:MI:SS

Auxiliary:

NLS_LANG=American_America.WE8ISO8859P1

NLS_NUMERIC_CHARACTERS=.,

NLS_SORT=binary

NLS_DATE_FORMAT=YYYY-MM-DD HH:MI:SS

Backup script:

run {

allocate channel t1 type 'SBT_TAPE'

parms 'ENV=(nsr_server=earth01,NSR_DATA_VOLUME_POOL=RMAN Pool)';

setlimit channel t1 kbytes 2097150;

backup full filesperset 4 (database format 'bu_%d_s%sp%pt%t');

}

Restore Script:

Run {

allocate auxiliary channel t1 type 'SBT_TAPE';

set newname for datafile 1 to '/u02/oracle/zenadata/d1/system01.dbf';

set newname for datafile 2 to '/u02/oracle/zenadata/d2/rbs01.dbf';

set newname for datafile 3 to '/u02/oracle/zenadata/d3/zenad01.dbf';

set newname for datafile 4 to '/u02/oracle/zenadata/d4/zenax01.dbf';

duplicate target database to ZENA

logfile '/u02/oracle/zenadata/d1/log1a.log' size 1m,

'/u02/oracle/zenadata/d2/log2a.log' size 1m,

'/u02/oracle/zenadata/d3/log1b.log' size 1m,

'/u02/oracle/zenadata/d4/log2b.log' size 1m;

}

Error message:

Cannot find datafiles

Changed backup script to include logfiles;

run {

allocate channel t1 type 'SBT_TAPE'

parms 'ENV=(nsr_server=earth01,NSR_DATA_VOLUME_POOL=RMAN Pool)';

setlimit channel t1 kbytes 2097150;

backup full filesperset 4

format 'bu_%d_s%sp%pt%t'

(database include current controlfile);

sql "ALTER SYSTEM ARCHIVE LOG CURRENT";

backup

format 'bu_%d_s%sp%pt%t'

(archivelog all delete input);

}

Ran the same Restore:

LOG:
RMAN-06005: connected to target database: XMEN (DBID=772271611)

RMAN-06008: connected to recovery catalog database

RMAN-06020: connected to auxiliary database

RMAN> run {

2> allocate auxiliary channel t1 type 'SBT_TAPE';

3> set newname for datafile 1 to '/u02/oracle/zenadata/d1/system01.dbf';

4> set newname for datafile 2 to '/u02/oracle/zenadata/d2/rbs01.dbf';

5> set newname for datafile 3 to '/u02/oracle/zenadata/d3/zenad01.dbf';

6> set newname for datafile 4 to '/u02/oracle/zenadata/d4/zenax01.dbf';

7> duplicate target database to ZENA

8> logfile '/u02/oracle/zenadata/d1/log1a.log' size 1m,

9> '/u02/oracle/zenadata/d2/log2a.log' size 1m,

10> '/u02/oracle/zenadata/d3/log1b.log' size 1m,

11> '/u02/oracle/zenadata/d4/log2b.log' size 1m;

12> }

13>

RMAN-03022: compiling command: allocate

RMAN-03023: executing command: allocate

RMAN-08030: allocated channel: t1

"ZENAr.log" 149 lines, 5425 characters

RMAN-03026: error recovery releasing channel resources

RMAN-08031: released channel: t1

RMAN-00571: ======

RMAN-00569: ======ERROR MESSAGE STACK FOLLOWS ======

RMAN-00571: ======

RMAN-03002: failure during compilation of command

RMAN-03013: command type: Duplicate Db

RMAN-03015: error occurred in stored script Memory Script

RMAN-03002: failure during compilation of command

RMAN-03013: command type: recover

RMAN-03002: failure during compilation of command

RMAN-03013: command type: recover(1)

RMAN-06136: ORACLE error from auxiliary database: ORA-06550: line 1, column 166:

PLS-00553: character set name is not recognized

ORA-06550: line 0, column 0:

PL/SQL: Compilation unit analysis terminated

RMAN-06031: could not translate database keyword

Updated tar. There are numerous bugs listed for this error and she doesn’t seem to get it.

Deleted zena database

sqlplus target database

alter system archive log current

ran clone script again per Metalink note:

Same error:

Updated tar.

One note said to update the NLS parameter from the rman session. Update tar to ask how to do this.

SELECT * FROM V$NLS_PARAMETERS

WHERE PARAMETER = 'NLS_CHARACTERSET';

NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

Bug: 878554

449516

1160035 bug fixed in 9.2

SHUTDOWN and Restarted all databases

Target: alter session archive log current