Home » RDBMS Server » Server Administration » auxillary
auxillary [message #263566] Thu, 30 August 2007 06:56 Go to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
how to create auxillary database?
and tell me cmd to create dupilcate database?
i tried this one but i faced sum errors.






RMAN> run {
2> allocate channel newdb1 type disk;
3> duplicate target database to newdb;
4> db_file_name_convert=('/orcl/oracle/product/oradata/dbsib/','/orcl/oracle/product/newdb/');



orcl/oracle/product/oradata/dbsib == is my target database path




RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "db_file_name_convert": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, copy, convert, crosscheck, configure, duplicate, debug, delete, execute, endinline, flashback, host, mount, open, plsql, recover, release, replicate, report, restore, resync, }, set, setlimit, sql, switch, startup, shutdown, send, show, transport, validate"
RMAN-01007: at line 4 column 1 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "equal": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 4 column 21 file: standard input

Report message to a moderator

Re: auxillary [message #263568 is a reply to message #263566] Thu, 30 August 2007 07:05 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Look at the documentation how to create duplicate database by RMAN DUPLICATE.

There are several procedures.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb006.htm#BRADV169

Report message to a moderator

Re: auxillary [message #263887 is a reply to message #263566] Fri, 31 August 2007 04:09 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
what is auxillary instance?

how to connect to the auxillary instance?

Report message to a moderator

Re: auxillary [message #263893 is a reply to message #263566] Fri, 31 August 2007 04:14 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
i had create the password file in target database?
for dupilcate database wheather i want to create a new database in new machine?

third step gc in the document is

Creating the Duplicate Control Files
 Creating the Duplicate Online Redo Logs
 Renaming Datafiles When Duplicating a Database

if i create a new database there will be control file and everything?

am confused please guide me solution

Ensure Oracle Net Connectivity to the Auxiliary Instance
The auxiliary instance must be accessible through Oracle Net. Before proceeding,
start SQL*Plus to ensure that you can establish a connection to the auxiliary
instance. Note that you must connect to the auxiliary instance with SYSDBA
privileges, so a password file must exist.

Report message to a moderator

Re: auxillary [message #264301 is a reply to message #263566] Sun, 02 September 2007 23:35 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
i had create the password file in target database?
for dupilcate database wheather i want to create a new database in new machine?

third step gc in the document is

Creating the Duplicate Control Files
 Creating the Duplicate Online Redo Logs
 Renaming Datafiles When Duplicating a Database

if i create a new database there will be control file and everything?

am confused please guide me solution

Ensure Oracle Net Connectivity to the Auxiliary Instance
The auxiliary instance must be accessible through Oracle Net. Before proceeding,
start SQL*Plus to ensure that you can establish a connection to the auxiliary
instance. Note that you must connect to the auxiliary instance with SYSDBA
privileges, so a password file must exist.

Report message to a moderator

Re: auxillary [message #264503 is a reply to message #264301] Mon, 03 September 2007 10:07 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
for dupilcate database wheather i want to create a new database in new machine?
Not new database but you have to create oracle services through ORADIM utility.
or yes you have to also create PASSWORD file.

Regards
Taj

Report message to a moderator

Previous Topic: abort low hwm
Next Topic: Resize Datafile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 10:37:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.