Help needed in setting up Auxiliary database in RMAN

[vdolphin]

Iam trying to setup an Auxiliary database for my RMAN. Iam enclosing the command iam running and the Error message generated. Any ideas.....Please ?????????????

------------------------------------------------------------------------
run {
allocate auxiliary channel newdb1 type disk;
allocate auxiliary channel newdb2 type disk;
allocate auxiliary channel newdb3 type disk;
allocate auxiliary channel newdb4 type disk;
set newname for datafile 1 TO 'd:\oracle\oradata\dup\SYSTEM01.dbf';
set newname for datafile 2 TO 'd:\oracle\oradata\dup\RBS01.dbf';
set newname for datafile 3 TO 'd:\oracle\oradata\dup\USERS01.dbf';
set newname for datafile 4 TO 'd:\oracle\oradata\dup\TEMP01.dbf';
set newname for datafile 5 TO 'd:\oracle\oradata\dup\TOOLS01.dbf';
set newname for datafile 6 TO 'd:\oracle\oradata\dup\INDX01.dbf';
set newname for datafile 7 TO 'd:\oracle\oradata\dup\DR01.dbf';
set newname for datafile 8 TO 'd:\oracle\oradata\dup\CATTBS.dbf';
duplicate target database to dup LOGFILE
GROUP 1 ('D:\ORACLE\ORADATA\DUP\REDO03.LOG') SIZE 200k REUSE,
GROUP 2 ('D:\ORACLE\ORADATA\DUP\REDO02.LOG') SIZE 200k REUSE,
GROUP 3 ('D:\ORACLE\ORADATA\DUP\REDO01.LOG') SIZE 200k REUSE;
}

------------------------------------------------------------------------

Iam getting the following error message...Any ideas ???
------------------------------------------------------------------------

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "dup" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 32 MAXINSTANCES 16 MAXLOGHISTORY 1815 LOGFILE GROUP 1 ( ''D:\ORACLE\ORADATA\DUP\REDO03.LOG'' ) SIZE 204800 REUSE, GROUP 2 ( ''D:\ORACLE\ORADATA\DUP\REDO02.LOG'' ) SIZE 204800 REUSE, GROUP 3 ( ''D:\ORACLE\ORADATA\DUP\REDO01.LOG'' ) SIZE 204800 REUSE DATAFILE ''D:\ORACLE\ORADATA\DUP\SYSTEM01.DBF'' CHARACTER SET WE8ISO8859P1
RMAN-03023: executing command: sql
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: newdb1
RMAN-08031: released channel: newdb2
RMAN-08031: released channel: newdb3
RMAN-08031: released channel: newdb4
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-03006: non-retryable error occurred during execution of command: sql
RMAN-07004: unhandled exception during command execution on channel clone_default
RMAN-20000: abnormal termination of job step
RMAN-11003: failure during parse/execution of SQL statement: CREATE CONTROLFILE REUSE SET DATABASE "dup" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 32 MAXINSTANCES 16 MAXLOGHISTORY 1815 LOGFILE GROUP 1 ( 'D:\ORACLE\ORADATA\DUP\REDO03.LOG' ) SIZE 204800 REUSE, GROUP 2 ( 'D:\ORACLE\ORADATA\DUP\REDO02.LOG' ) SIZE 204800 REUSE, GROUP 3 ( 'D:\ORACLE\ORADATA\DUP\REDO01.LOG' ) SIZE 204800 REUSE DATAFILE 'D:\ORACLE\ORADATA\DUP\SYSTEM01.DBF' CHARACTER SET WE8ISO8859P1
RMAN-11001: Oracle Error: ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : 'D:\ORACLE\ORADATA\DUP\SYSTEM01.DBF'

Recovery Manager complete.

------------------------------------------------------------------------

[Thomasps]

Hi..What is your requirement for the auxilary database? Is it for catalog?
Thanks
Thomas

[vdolphin]

Yes...Iam setting up a recovery catalog and the Auxiliary DB is meant for recovering tablespaces in an Archivelog files...Is there an alternative to what Iam doing????

[Thomasps]

Hi..

Database 1 = Database to be backed up
Database 2 = Catalog Database. ( Newly created database)


1. First create a new database in any system which is in the network where you are going to deposit your catalog.

2. Create a new tablespace in the new database RMAN_TS

CREATE TABLESPACE RMAN_TS DATFILE SIZE 30M AUTOEXTENT ON;

3. Create a user RMAN.

CREATE USER RMAN IDENTIFIED BY DEFAULT TABLESPACE RMAN_TS TEMPORARY TABLESPACE ;

4. GRANT DBA TO RMAN;

5. GRANT RECOVERY_CATALOG_OWNER TO RMAN;


Start the Rman in the new database:
C:\Rman

rman> connect catalog rman/

Rman> CREATE CATALOG

The catalog tables will be created in the new database.

Exit RMAN



Go to the Database 1.
1. Create a Net8 connection to the catalog databse (Database 2 ) say RMAN_CS.

2. Start the database 1
3. Start RMAN in Databse 1 system

4. Rman> CONNECT TARGET INTERNAL/ - Connecting to the databse 1


5. Rman> CONNECT CATALOG RMAN/ @RAMN_CS - Connecting to the Catalog Database.

6. Rman> REGISTER DATABASE - Registering the database in the catalog.


7. Create the RMAN Backup

RUN {
allocate channel ch1 type disk;
backup database;
release channel ch1;}

Or you can use more advansed commands...

8. Then use the command RESYNC CATALOG to sync. the catalog and the control file.


Hope this will serve you..

Thanks
Thomas P S
royxavier@yahoo.com

[vdolphin]

Thanks Thomas,

I followed your instructions...now how do I do a point-in-time tablespace recover thru' RMAN...could you help me with the script, as the oracle documentation is very vague on that...