This features allows you to mount your dump file(s) as a read-only database; once mounted you can access the tables in the database with your desired select queries.
you'll need to setup a smallish scratch database for managing the mount
it's possible to make non-persistent changes to data; this consists of allocating (optional) disk space to hold any modified pages (these changes will not be reflected in the database dump file(s)
For an example of setting up the scratch and archive databases, see the Reference manual entry for the create archive database command.
+0 – Thanks @markp. I search it. I think i need disk area for archive database. Right? my database size is nearly 100 Gb. Dump size 60 Gb. I saw there is an archive db disk in my database which has 200 mb. Is it enough? How much size should i need? I read 1/256 rate (so i think i have ~390 mb for 100 GB dump or dbsize) , is it right? — Oct 04, 2018 at 13:48
+1 – the proposed size sounds about right; keep in mind the documentation is giving you (rough) estimates; I'd probably go with 400MB and then try mounting the db dump file(s) ... it'll either succeed for fail; if it fails, add some more space (or drop/recreate as larger); it may take a few attempts to find a size that works for you; the 'good' news is that it take little time to (re)create the archive/scratch dbs for testing — Oct 04, 2018 at 13:51
+0 – How much should i need log segment area? I add 500M scratch_log_dev but it said 1 task(s) are sleeping waiting for space to become available in the log segment for database scratchdb. ... — Oct 05, 2018 at 11:25
+0 – I've update my answer with a link to an example of creating/using the scratch and archive databases; as for the size of the log ... the scratch db should need much space so, how much space did you give it initially? if you've got the space, I'd just allocate a 100MB-200MB chunk and go from there. — Oct 05, 2018 at 11:52
+0 – In scratch db, it was created 100M data and 100M log. Then i added 400MB log, 500Mb log and 1000Mb log with alter database .. log on ... MB ... — Oct 05, 2018 at 14:30