Обсуждение: Database separation for backup
Hi,
Is there any way to keep each database in separate partition ie) separate folder for each database.
I would like to do the dabase level backup in storage side, for that If I am able to separate the database in folderwise, I can allocate separate partition for each database. Then I can take the backup in each partition.
Your recommendation and suggestion are welcome.
Regards
Karthikeyan.N
Nagalingam, Karthikeyan wrote: > Hi, > > Is there any way to keep each database in separate partition ie) > separate folder for each database. > > I would like to do the dabase level backup in storage side, for that > If I am able to separate the database in folderwise, I can allocate > separate partition for each database. Then I can take the backup in > each partition. > > Your recommendation and suggestion are welcome. > > Regards > Karthikeyan.N > > I guess tablespace will be of your use and also you can directly use softlink to link database directory in data/base<databaseoid> to the desired folder. With Regards --Ashish