-
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.
------------------------------------------------------------------------
-
Hi..What is your requirement for the auxilary database? Is it for catalog?
Thanks
Thomas
-
Help needed in setting up Auxiliary database in RMAN
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????
-
Creating Catalog for RMAN
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
-
How to do a TSPITR in RMAN
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|