Printable View
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.
Code: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
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.
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.
How about alter database read only, or startup restrict.
Why does exp '/ as sysdba' doesnt ask passowrd? while
sqlplus '/ as sysdba' asked one?
because I made a typing mistakeQuote:
Originally posted by kris123
Why does exp '/ as sysdba' doesnt ask passowrd? while
sqlplus '/ as sysdba' asked one?
lol:D but i didnt made typing mistake when i issued the command
at my server;)
you probably did becaause you need some fancy combo of 's which i can never remember
something like this I thinks
Code:exp \"/ as sysdba\"
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.
post your full export line then
exp '/ as sysdba'
sqlplus '/as sysdba'
:rolleyes:
you didnt read the post before where I said you have to put the \'s round it as well for exp / imp