Question in Duplicate Standby DB

All posts relating to Oracle database administration.

Moderator: Tim...

Question in Duplicate Standby DB

Postby peterx » Sun Jun 09, 2013 5:42 pm

hi Tim,

I try to follow your doc:
http://www.oracle-base.com/articles/11g ... _11gR2.php
to make the data guard setting

Code: Select all
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jun 10 01:19:35 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRIMARY (DBID=1654743499)
connected to auxiliary database: PRIMARY (not mounted)

RMAN> DUPLICATE TARGET DATABASE
  FOR STANDBY
  FROM ACTIVE DATABASE
  DORECOVER
  SPFILE
    SET db_unique_name='PRIMARY1' COMMENT 'Is standby'
    SET LOG_ARCHIVE_DEST_2='SERVICE=PRIMARY ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARY'
    SET FAL_SERVER='PRIMARY' COMMENT 'Is primary'
  NOFILENAMECHECK;2> 3> 4> 5> 6> 7> 8> 9>

Starting Duplicate Db at 10-JUN-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=135 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/u01/app/oracle/product/11.2.0.1/db_1/dbs/orapwPRIMARY' auxiliary format
 '/u01/app/oracle/product/11.2.0.1/db_1/dbs/orapwPRIMARY'   targetfile
 '/u01/app/oracle/product/11.2.0.1/db_1/dbs/spfilePRIMARY.ora' auxiliary format
 '/u01/app/oracle/product/11.2.0.1/db_1/dbs/spfilePRIMARY.ora'   ;
   sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0.1/db_1/dbs/spfilePRIMARY.ora''";
}
executing Memory Script

Starting backup at 10-JUN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=150 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=36 device type=DISK
Finished backup at 10-JUN-13

sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0.1/db_1/dbs/spfilePRIMARY.ora''

contents of Memory Script:
{
   sql clone "alter system set  db_unique_name =
 ''PRIMARY1'' comment=
 ''Is standby'' scope=spfile";
   sql clone "alter system set  LOG_ARCHIVE_DEST_2 =
 ''SERVICE=PRIMARY ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARY'' comment=
 '''' scope=spfile";
   sql clone "alter system set  FAL_SERVER =
 ''PRIMARY'' comment=
 ''Is primary'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_unique_name =  ''PRIMARY1'' comment= ''Is standby'' scope=spfile

sql statement: alter system set  LOG_ARCHIVE_DEST_2 =  ''SERVICE=PRIMARY ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARY'' comment= '''' scope=spfile

sql statement: alter system set  FAL_SERVER =  ''PRIMARY'' comment= ''Is primary'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     835104768 bytes

Fixed Size                     2217952 bytes
Variable Size                624953376 bytes
Database Buffers             201326592 bytes
Redo Buffers                   6606848 bytes

contents of Memory Script:
{
   sql clone "alter system set  control_files =
  ''/u02/oradata/PRIMARY/controlfile/o1_mf_8tw6wc9c_.ctl'', ''/u02/flash_recovery_area/PRIMARY/controlfile/o1_mf_8tw6wcf4_.ctl'' comment=
 ''Set by RMAN'' scope=spfile";
   backup as copy current controlfile for standby auxiliary format  '/u02/oradata/PRIMARY/controlfile/o1_mf_8tw6wc9c_.ctl';
   restore clone controlfile to  '/u02/flash_recovery_area/PRIMARY/controlfile/o1_mf_8tw6wcf4_.ctl' from
 '/u02/oradata/PRIMARY/controlfile/o1_mf_8tw6wc9c_.ctl';
   sql clone "alter system set  control_files =
  ''/u02/oradata/PRIMARY/controlfile/o1_mf_8tw6wc9c_.ctl'', ''/u02/flash_recovery_area/PRIMARY/controlfile/o1_mf_8tw6wcf4_.ctl'' comment=
 ''Set by RMAN'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  control_files =   ''/u02/oradata/PRIMARY/controlfile/o1_mf_8tw6wc9c_.ctl'', ''/u02/flash_recovery_area/PRIMARY/controlfile/o1_mf_8tw6wcf4_.ctl'' comment= ''Set by RMAN'' scope=spfile

Starting backup at 10-JUN-13
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0.1/db_1/dbs/snapcf_PRIMARY.f_colin tag=TAG20130610T011957 RECID=16 STAMP=817694398
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 10-JUN-13

Starting restore at 10-JUN-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=135 device type=DISK

channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 10-JUN-13

sql statement: alter system set  control_files =   ''/u02/oradata/PRIMARY/controlfile/o1_mf_8tw6wc9c_.ctl'', ''/u02/flash_recovery_area/PRIMARY/controlfile/o1_mf_8tw6wcf4_.ctl'' comment= ''Set by RMAN'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     835104768 bytes

Fixed Size                     2217952 bytes
Variable Size                624953376 bytes
Database Buffers             201326592 bytes
Redo Buffers                   6606848 bytes

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database
RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT

contents of Memory Script:
{
   set newname for tempfile  1 to
 "/u02/oradata/PRIMARY/datafile/o1_mf_temp_8tw6wohj_.tmp";
   switch clone tempfile all;
   set newname for datafile  1 to
 "/u02/oradata/PRIMARY/datafile/o1_mf_system_8tw6tplj_.dbf";
   set newname for datafile  2 to
 "/u02/oradata/PRIMARY/datafile/o1_mf_sysaux_8tw6tpmr_.dbf";
   set newname for datafile  3 to
 "/u02/oradata/PRIMARY/datafile/o1_mf_undotbs1_8tw6tpmv_.dbf";
   set newname for datafile  4 to
 "/u02/oradata/PRIMARY/datafile/o1_mf_users_8tw6tpnb_.dbf";
   backup as copy reuse
   datafile  1 auxiliary format
 "/u02/oradata/PRIMARY/datafile/o1_mf_system_8tw6tplj_.dbf"   datafile
 2 auxiliary format
 "/u02/oradata/PRIMARY/datafile/o1_mf_sysaux_8tw6tpmr_.dbf"   datafile
 3 auxiliary format
 "/u02/oradata/PRIMARY/datafile/o1_mf_undotbs1_8tw6tpmv_.dbf"   datafile
 4 auxiliary format
 "/u02/oradata/PRIMARY/datafile/o1_mf_users_8tw6tpnb_.dbf"   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u02/oradata/PRIMARY/datafile/o1_mf_temp_8tw6wohj_.tmp in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 10-JUN-13
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u02/oradata/PRIMARY/datafile/o1_mf_undotbs1_8tw6tpmv_.dbf
channel ORA_DISK_2: starting datafile copy
input datafile file number=00001 name=/u02/oradata/PRIMARY/datafile/o1_mf_system_8tw6tplj_.dbf
output file name=/u02/oradata/PRIMARY/datafile/o1_mf_system_8tw6tplj_.dbf tag=TAG20130610T012022
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:01:05
channel ORA_DISK_2: starting datafile copy
input datafile file number=00002 name=/u02/oradata/PRIMARY/datafile/o1_mf_sysaux_8tw6tpmr_.dbf
output file name=/u02/oradata/PRIMARY/datafile/o1_mf_undotbs1_8tw6tpmv_.dbf tag=TAG20130610T012022
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:00
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u02/oradata/PRIMARY/datafile/o1_mf_users_8tw6tpnb_.dbf
output file name=/u02/oradata/PRIMARY/datafile/o1_mf_sysaux_8tw6tpmr_.dbf tag=TAG20130610T012022
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:55
output file name=/u02/oradata/PRIMARY/datafile/o1_mf_users_8tw6tpnb_.dbf tag=TAG20130610T012022
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 10-JUN-13

sql statement: alter system archive log current

contents of Memory Script:
{
   backup as copy reuse
   archivelog like  "/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_10/o1_mf_1_178_8v9gbrtl_.arc" auxiliary format
 "/u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_178_%u_.arc"   archivelog like
 "/u02/flash_recovery_area/PRIMARY/archivelog/2013_06_10/o1_mf_1_179_8v9ggl2j_.arc" auxiliary format
 "/u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_179_%u_.arc"   ;
   catalog clone recovery area;
   switch clone datafile all;
}
executing Memory Script

Starting backup at 10-JUN-13
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=178 RECID=674 STAMP=817694424
channel ORA_DISK_2: starting archived log copy
input archived log thread=1 sequence=179 RECID=675 STAMP=817694546
output file name=/u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_178_48obq1qi_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
output file name=/u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_179_49obq1qi_.arc RECID=0 STAMP=0
channel ORA_DISK_2: archived log copy complete, elapsed time: 00:00:01
Finished backup at 10-JUN-13

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: /u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_179_49obq1qi_.arc
File Name: /u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_178_48obq1qi_.arc
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_179_49obq1qi_.arc
File Name: /u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_178_48obq1qi_.arc

datafile 1 switched to datafile copy
input datafile copy RECID=16 STAMP=817694547 file name=/u02/oradata/PRIMARY/datafile/o1_mf_system_8tw6tplj_.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=17 STAMP=817694547 file name=/u02/oradata/PRIMARY/datafile/o1_mf_sysaux_8tw6tpmr_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=18 STAMP=817694547 file name=/u02/oradata/PRIMARY/datafile/o1_mf_undotbs1_8tw6tpmv_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=19 STAMP=817694547 file name=/u02/oradata/PRIMARY/datafile/o1_mf_users_8tw6tpnb_.dbf

contents of Memory Script:
{
   set until scn  2405877;
   recover
   standby
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 10-JUN-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=137 device type=DISK

starting media recovery

archived log for thread 1 with sequence 178 is already on disk as file /u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_178_48obq1qi_.arc
archived log for thread 1 with sequence 179 is already on disk as file /u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_179_49obq1qi_.arc
archived log file name=/u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_178_48obq1qi_.arc thread=1 sequence=178
archived log file name=/u02/flash_recovery_area/PRIMARY1/archivelog/2013_06_10/o1_mf_1_179_49obq1qi_.arc thread=1 sequence=179
media recovery complete, elapsed time: 00:00:01
Finished recover at 10-JUN-13
Finished Duplicate Db at 10-JUN-13

RMAN>



I listed all the files:
Code: Select all
select name from v$datafile
union
select member from v$logfile
union
select name from v$controlfile
union
select name from v$tempfile;
SQL> SQL>   2    3    4    5    6    7 
NAME
--------------------------------------------------------------------------------
/u02/flash_recovery_area/PRIMARY/controlfile/o1_mf_8tw6wcf4_.ctl
/u02/flash_recovery_area/PRIMARY1/onlinelog/o1_mf_1_8v9ggof6_.log
/u02/flash_recovery_area/PRIMARY1/onlinelog/o1_mf_2_8v9ggpn1_.log
/u02/flash_recovery_area/PRIMARY1/onlinelog/o1_mf_3_8v9ggr7j_.log
/u02/flash_recovery_area/PRIMARY1/onlinelog/o1_mf_4_8v9ggt3n_.log
/u02/flash_recovery_area/PRIMARY1/onlinelog/o1_mf_5_8v9ggvn8_.log
/u02/flash_recovery_area/PRIMARY1/onlinelog/o1_mf_6_8v9ggxcw_.log
/u02/flash_recovery_area/PRIMARY1/onlinelog/o1_mf_7_8v9gh03r_.log
/u02/oradata/PRIMARY/controlfile/o1_mf_8tw6wc9c_.ctl
/u02/oradata/PRIMARY/datafile/o1_mf_sysaux_8tw6tpmr_.dbf
/u02/oradata/PRIMARY/datafile/o1_mf_system_8tw6tplj_.dbf

NAME
--------------------------------------------------------------------------------
/u02/oradata/PRIMARY/datafile/o1_mf_undotbs1_8tw6tpmv_.dbf
/u02/oradata/PRIMARY/datafile/o1_mf_users_8tw6tpnb_.dbf
/u02/oradata/PRIMARY/onlinelog/standby_redo01.log
/u02/oradata/PRIMARY/onlinelog/standby_redo02.log
/u02/oradata/PRIMARY/onlinelog/standby_redo03.log
/u02/oradata/PRIMARY1/datafile/o1_mf_temp_8v9h398x_.tmp
/u02/oradata/PRIMARY1/onlinelog/o1_mf_1_8v9ggobt_.log
/u02/oradata/PRIMARY1/onlinelog/o1_mf_2_8v9ggpko_.log
/u02/oradata/PRIMARY1/onlinelog/o1_mf_3_8v9ggr44_.log
/u02/oradata/PRIMARY1/onlinelog/o1_mf_4_8v9ggt1j_.log
/u02/oradata/PRIMARY1/onlinelog/o1_mf_5_8v9ggvkv_.log

NAME
--------------------------------------------------------------------------------
/u02/oradata/PRIMARY1/onlinelog/o1_mf_6_8v9ggx91_.log
/u02/oradata/PRIMARY1/onlinelog/o1_mf_7_8v9gh017_.log

24 rows selected.

SQL>



I expected all the files on standby nodes will be created in folder "PRIMARY".
But, seems, only temp, archive log and online redo log is created in folder "PRIMARY1".

Can you please advice, how to control the location while duplicate?

I think "RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT" make the wrong thing!

thanks.
peterx
Senior Member
 
Posts: 189
Joined: Wed Feb 09, 2011 7:07 am

Re: Question in Duplicate Standby DB

Postby Tim... » Sun Jun 09, 2013 6:05 pm

Hi.

Any files that are copied from the primary database, active or via backup, will be placed in the same location as they were on the primary database, assuming no convert parameters are set.

Any new files generated, like the online redo logs and the temp file will be located in a path based on the db_unique_name, which is what you've got.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Question in Duplicate Standby DB

Postby peterx » Mon Jun 10, 2013 1:27 am

hi Tim,

Yes, you are right! Seems, standby db_unique_name = PRIMARY1.
The temp, online redo and arch log also in PRIMARY1.

But, in the data guard setting. What is the best prastise for the standby, I expected all the files should be
inside folder "PRIMARY" just like the primary database.

Please kindly advice.


Just found this:
Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE [ID 1075908.1]
Seem, can answer all my questions, but my new company can't remote to my home testing environment.
I think I will test this in a few days.

thanks.
peterx
Senior Member
 
Posts: 189
Joined: Wed Feb 09, 2011 7:07 am

Re: Question in Duplicate Standby DB

Postby Tim... » Mon Jun 10, 2013 7:37 am

Hi.

Nice note. I've added that to the links at the end of my article. Thanks.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Question in Duplicate Standby DB

Postby peterx » Tue Jun 11, 2013 1:33 am

hi Tim,

I tested the Oracle Doc steps, and can do what i want, in the condition that standby's all stuffs created in 'PRIMARY1'.
Seems, oracle doc also created different folder for primary and standby db stuffs.

Another question want to ask while following the oracle doc:

From http://docs.oracle.com/cd/B28359_01/ser ... ection.htm
i know that:
Table 5-1 Required Redo Transport Attributes for Data Protection Modes

Code: Select all
Table 5-1 Required Redo Transport Attributes for Data Protection Modes
Maximum Availability            Maximum Performance      Maximum Protection
AFFIRM                                NOAFFIRM                         AFFIRM
SYNC                                    ASYNC                              SYNC
DB_UNIQUE_NAME                 DB_UNIQUE_NAME              DB_UNIQUE_NAME
 


From you doc:
Code: Select all
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=db11g_stby NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB11G_STBY';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;


But.., from oracle doc:
Code: Select all
alter system set LOG_ARCHIVE_DEST_2='SERVICE=boston LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston';


What is the use of "LGWR" and seems both LGWR and AFFIRM also will show "Max Performance" mode.

thanks.
peterx
Senior Member
 
Posts: 189
Joined: Wed Feb 09, 2011 7:07 am

Re: Question in Duplicate Standby DB

Postby peterx » Tue Jun 11, 2013 2:35 am

hi Tim,

I think i got a very good explaination from this URL:
http://www.juliandyke.com/Presentations/DataGuardBasics.ppt

Do you think this is all the data guard setting?

thanks.
peterx
Senior Member
 
Posts: 189
Joined: Wed Feb 09, 2011 7:07 am

Re: Question in Duplicate Standby DB

Postby Tim... » Tue Jun 11, 2013 5:56 am

Hi.

I'm not sure what you are asking me.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Question in Duplicate Standby DB

Postby peterx » Tue Jun 11, 2013 6:19 am

hi Tim,
sorry for my question!

I mean, do you think this ppt is enough to explain the Data Guard Redo Log Shipping case:
http://www.juliandyke.com/Presentations ... Basics.ppt

Code: Select all
ARCH background process
    Copies completed redo log files to standby
LGWR background process - modes are:
    ASYNC - asynchronous
        Oracle 10.1 and below
             redo written by LGWR to dedicated area in SGA
             read from SGA by LNSn background process
        Oracle 10.2 and above
             redo written by LGWR to local disk
             read from disk by LNSn background process
     SYNC - synchronous
             Redo written to standby by LGWR - modes are:
                    AFFIRM - wait for confirmation redo written to disk
                    NOAFFIRM - do not wait


If this really all the shipping case, then I can follow this to change the data guard parameter setting.

thanks.
peterx
Senior Member
 
Posts: 189
Joined: Wed Feb 09, 2011 7:07 am

Re: Question in Duplicate Standby DB

Postby Tim... » Tue Jun 11, 2013 7:14 am

Hi.

Julian is a very bright guy, so I'm sure it covers all the options that were available in 2008, when the slides were written.

If you want to know if it is still covering all the available options, there is an easy way to check. Open up the manuals online and check the contents of the slides against the documentation. You are capable of doing this just as well as me, so why don't you do it, instead of asking me to. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 9 guests

cron