-
Is log_file_name_convert allowed in run block.
Is log_file_name_convert allowed in run block.
I have 3 log group on target(source).Each has 2 members.
target ->aux
u01/oradata/prod/redo01.log ->/ora1/oradata/aux//redo01.log
/u02/oradata/prod/redo01b.log->/ora2/oradata/aux//redo0b.log
/u01/oradata/prod/redo02.log->/ora1/oradata/aux//redo02.log
/u02/oradata/prod/redo02b.log-/ora2/oradata/aux//redo02b.log
/u01/oradata/prod/redo03.log->/ora1/oradata/aux//redo03.log
/u02/oradata/prod/redo03b.log->/ora2/oradata/aux//redo03b.log
run {
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;
set until time "to_date('24-Jun-11 10:22:00','DD-MON-YY HH24:MI:SS')";
DUPLICATE TARGET DATABASE TO "test"
PFILE=/opt/oracle/product/10.2/db_1/dbs/inittest.ora
DB_FILE_NAME_CONVERT='/u01/oradata/prod/', '/ora1/oradata/test/'
log_file_name_convert='/u01/oradata/prod/','/ora1/oradata/test/','/u02/oradata/prod/','/ora2/oradata/test/'
release channel aux1;
release channel aux2;
}
-
Originally Posted by sksktx
DB_FILE_NAME_CONVERT='/u01/oradata/prod/', '/ora1/oradata/test/'
log_file_name_convert='/u01/oradata/prod/','/ora1/oradata/test/','/u02/oradata/prod/','/ora2/oradata/test/'
}
This parameters are used in the pfile right ?
you may please refer the below link
http://download.oracle.com/docs/cd/B...pdb.htm#441883
Thanks/Gopu
-
You either use the db_file_name_convert and log_file_name_convert in the pfile, or you can use set filename/tempfile for n to '/oracle/oradata/sidname...'; and before you open the database you need to rename the online logs with an alter database rename file 'from file' tofile';
I dynamically generate the clone script during the backup process, which makes it easier to do the cloning on any database whether I am cloning from and to a database on the same server or cloning from one server to another, even if the two servers can't talk to each other.
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
|