Database Backup and Recovery (MOSC)

MOSC Banner

Backup on 9i

edited Mar 31, 2012 2:50AM in Database Backup and Recovery (MOSC) 9 commentsAnswered ✓
   Hi all,
   My db is 9.2.0.4 64 bit on Unix AIX and size about 300GB

   Because of I need create new database (copy of primary db) for testing but run on Linux OS, so I must use export/import to do this work. I want ask about some parameters to make exporting faster

    + BUFFER: Calculate buffer size may help fetch more row at a time (buffer_size = rows_in_array * maximum_row_size). If I export from remote machive (another server not server that exist db), this value still effect ? And if it still effect, buffer size is RAM that oracle (maybe oracle client) get to serve exporting ?.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center