Home » RDBMS Server » Backup & Recovery » restore time (10.2.0.2 solaris9)
restore time [message #350293] Wed, 24 September 2008 10:55 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,
My Backup strategy is:-
run {
     allocate channel chan1 type disk format '/data2/orabackup/BHI_1/rman/0/%d%U
.rman0';
     set limit channel chan1 kbytes=2000000;
     backup incremental level 0 filesperset 1 database;
     sql 'alter system switch logfile';
     backup archivelog until time 'sysdate-3' delete input;
     backup current controlfile tag = 'BHI_1-ctl'format = '/data2/orabackup/BHI_
1/rman/0/ctl_%d_%U';
     restore database validate check logical;
     crosscheck backup;
     crosscheck archivelog all;
     delete noprompt expired backup;
     delete noprompt expired archivelog all;
     release channel chan1;
    }

we are removing all the backup files  from OS older than one day by:-
find /data2/orabackup/BHI_1/rman/0 -name "*.rman0" -mtime +0 -exec rm {} \;

I wanted to know t what is maximum time in which I can restore
archivelog with this policy.
Re: restore time [message #350368 is a reply to message #350293] Wed, 24 September 2008 19:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Do you have another script that deletes obsolete backups? Why are you removing the backups manually?

The maximum time that you can restore archive logs is 1 days worth which is actually over 3 days old. Why are you only backing up old archive logs?
Re: restore time [message #350643 is a reply to message #350368] Thu, 25 September 2008 14:21 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian,
This is script is run by our backup dba.I am working
on streaming.So at any point of time if streaming stops it will
look for old  archivelogs to restart again.So i need minimum 
of 7 days of restore period.So you mean if somebody deletes 
the backup of archivelogs from operating system,then we cannot
restore those with Rman .What changes I can make in this script to 
make sure that i will be able to restore 7 days oldarchivelogsat any point of time.

Regards,
Varun Punj,
Re: restore time [message #350652 is a reply to message #350368] Thu, 25 September 2008 16:26 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian,
So the maximum restore time is 4days.I spoke to
Bacup DBA about the criticality of archive log restoration
If streaming is enabled.They are taking veritas netbackup
of the all the files also on operating
.So I just want to clear my doubt that
archivelog files restored from veritas backup will be good
to use by stream capture process.In other words restore
from RMAN and resotring manually form veritas backup give
same archivefiles??
Re: restore time [message #350664 is a reply to message #350652] Thu, 25 September 2008 18:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
RMAN is Streams aware and will not delete archive logs if they are needed by Streams.
Re: restore time [message #350696 is a reply to message #350293] Thu, 25 September 2008 23:02 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member

Quote:

find /data2/orabackup/BHI_1/rman/0 -name "*.rman0" -mtime +0 -exec rm {} \;


why not
"-mtime +1"

Re: restore time [message #350700 is a reply to message #350664] Thu, 25 September 2008 23:33 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian
RMAN will be aware or streaming if it stores backup 
in flashback recovery area.
But here we have manually defined the location of backup.
Please corrent me if I am wrong?

Regards,
Varun Punj,
Re: restore time [message #350785 is a reply to message #350700] Fri, 26 September 2008 06:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
RMAN is Streams aware regardless of location.
Re: restore time [message #350822 is a reply to message #350700] Fri, 26 September 2008 09:34 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
RMAN is aware of streams.
But in this case archivelogs are getting deleted
manually by the script I shown you.So I dont think I can get 
the required archivelogs in this case.Please correct me again 
If I am wrong.I am going so deep into this because of 
the criticality of streaming.

Regards,
Varun Punj
Re: restore time [message #350824 is a reply to message #350822] Fri, 26 September 2008 09:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I understand your concern. In my Streams environment, I set an appropriate retention policy and then perform a DELETE OBSOLETE and this will not remove archive logs required by Streams.

As I mentioned previously though, your script is configured to ONLY backup archivelogs that are over 3 days old. What are you planning to do if your system crashes and the last 3 days worth of archivelogs are not backed up and unrecoverable?

[Updated on: Fri, 26 September 2008 10:02]

Report message to a moderator

Re: restore time [message #350837 is a reply to message #350824] Fri, 26 September 2008 12:12 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian,
My current backup policy is taking backup of 3 days
old archivelogs.But according to you it is taking backupup
of all the archivelogs older than 3 days.I might be wrong
in this scenerio.But i checked that i am able to restore
4 days old archivelogs by  following command:-
restore archivelog from 'sysdate-4' validate;
The other concern is In your case RMAN is deleting obsolete
archivelogs so it will definitely take care of streams.But
policy set by my dba is deleting archivelogs manually from
O.S.So Rman should not take care of streaming in this case
of manual interference.I asked my dba that let RMAN take care
of archivelogs and he told me that we got space issues.So they
are taking backups of the files in the disk by VERITAS BACKUP.
Here again one question comes in my mind,restoration of archivelog  from backup
taken by Veritas backup will be  good enough for streaming
to restart.

Regards,
Varun Punj,
Re: restore time [message #350850 is a reply to message #350837] Fri, 26 September 2008 13:22 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Your script is taking backup of archivelogs OVER 3 days old. Therefore, archivelogs 3 days old and newer are not being backed up.

Can you post the output of:

restore archivelog from 'sysdate-2' validate;

Do you see any archivelogs listed ?

If you have no other choice but to delete files due to space constraints, then you should perform the following:

backup archivelog all not backed up 1 times;
delete noprompt archivelog all completed before 'sysdate-3' backed up 1 times to device type disk;


In answer to your question about restoring from tape, if needed, you can restore archivelogs from tape and register them with Streams.

[Updated on: Fri, 26 September 2008 13:24]

Report message to a moderator

Re: restore time [message #350860 is a reply to message #350850] Fri, 26 September 2008 14:26 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian,
I am posting end lines of command:-
restore archivelog until time 'sysdate-2' validate
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40243                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40244                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40245                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40246                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40247                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40248                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40249                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40250                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40251                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 8_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40252                                                                                                 9_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 0_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 1_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 2_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 3_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 4_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 5_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 6_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 7_563391362.log
channel ORA_DISK_1: scanning archive log /data/admin/BHI_1/arch/archBHI_11_40253                                                                                                 8_563391362.log
Finished restore at 26-SEP-08
Re: restore time [message #350861 is a reply to message #350850] Fri, 26 September 2008 14:29 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Yes I ann see archivelog listed with the help of:-
list archivelog all
This command is showing me archive logs from June till
25th september.
Re: restore time [message #350865 is a reply to message #350861] Fri, 26 September 2008 14:33 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
List archivelog all is showing archive logs till
26th september.Sorry to provide wrong info
If I restore archivelog from backup taken with veritas backup
do I need to do anything manually inorder to register them
for streaming Or i just need to place all the required archive 
logs at archive destination and stream will start capturing 
from required_checkpoint_scn automaically.
Regards,
Varun Punj,
Re: restore time [message #350915 is a reply to message #350865] Sat, 27 September 2008 10:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How are you seeing archivelogs from June ? Your script is configured to delete the archivelogs.

For archivelogs and Streams, check Adding an Archived Redo Log File to a Capture Process Explicitly.
Re: restore time [message #351425 is a reply to message #350293] Tue, 30 September 2008 15:04 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian,
I told Backup dba to change the script as told by you 
so that RMAN should take back up  of archivelogs not
backed up once.We have to gzip all the archivelog files 
at archive destination because of space issues.So due to
this backup of archivelog is failing.Now My DBA told me not to
take any backup of archivelogs with RMAN and to keep 
all the 5 days old zipped archive files at archive destination.He told 
me that they are backing up archive logs everyday with
veritas net backup so they can restore
archive logs any time.Please suggest me If I could go by his
suggestion in this environment where streaming is enabled
Regards,
Varun Punj,
Re: restore time [message #358512 is a reply to message #350824] Tue, 11 November 2008 12:16 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian,
I have found one bug in oracle streams.As we discussed that RMAN
is stream aware and it wont delete archivelogs needed by
STREAMS.Please see this at metalink which is saying that RMAN will
delete archivelogs:-
Bug 3741999
Regards,
Varun Punj
Re: restore time [message #358556 is a reply to message #358512] Tue, 11 November 2008 20:26 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Thanks for the information. However, you are on 10.2 so this issue should not affect you.

Are you experiencing the symptoms referred to in the bug ?
Re: restore time [message #358569 is a reply to message #358556] Tue, 11 November 2008 21:15 Go to previous message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian,
I am working on 10.2.0.2.I did not test it yet.I will do it on
test server and let you know.
Regards,
Varun Punj,
Previous Topic: export script
Next Topic: ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
Goto Forum:
  


Current Time: Wed Dec 07 18:35:33 CST 2016

Total time taken to generate the page: 0.06188 seconds