Export dump with database in mount state

[paragmaydeo]

Hi,

I have a very basic question on the backup.

I have a special requirement and time constraint.

S, I want to know whether I can run export dump with Database in mount state? Also, will there be any loss of information or any data or any chances of loosing such data/information?

Thanks,
Parag.

[davey23uk]

C:\exp '/as sysdba' full=y file=ds.dmp

Export: Release 10.1.0.2.0 - Production on Sat Mar 19 16:42:34 2005

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


EXP-00004: invalid username or password
Username: / as sysdba

EXP-00008: ORACLE error 1219 encountered
ORA-01219: database not open: queries allowed on fixed tables/views only
EXP-00000: Export terminated unsuccessfully

[BV1963]

It is common knowledge, (at least it should be) that export / import will only work when DB is open. If you want to restrict users while exporting/ importing , startup your database in resticted more and run exp/imp as an user with restrict access privilege granted.

[slimdave]

If you are worried about other sessions changing data while it is being exported, then specify consistent=y, which changes the export session's transaction isolation level to a read-only serializable mode.

[kris123]

How about alter database read only, or startup restrict.

Why does exp '/ as sysdba' doesnt ask passowrd? while
sqlplus '/ as sysdba' asked one?

[davey23uk]

Originally posted by kris123

Why does exp '/ as sysdba' doesnt ask passowrd? while
sqlplus '/ as sysdba' asked one?

because I made a typing mistake

[kris123]

lol but i didnt made typing mistake when i issued the command
at my server

[davey23uk]

you probably did becaause you need some fancy combo of 's which i can never remember

[davey23uk]

something like this I thinks

exp \"/ as sysdba\"

[kris123]

ur confusing me hun....
what i mean to say is exp '/ as sysdba' is ok and runs fine without
a password. but sqlplus '/ as sysdba' runs and is asking a password.