Interested to Buy Any Domain ? << Click Here >> for more details...
Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?
5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?
6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?
- 11 Answers
- 27127 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohanamurali chittim
1.Ans) NO
5.Ans)go to mount state then give
alter database archivelog;
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / amsu
4. No you can't take online backup while database in
NOARCHIVELOG mode.
5. shutdown immediate
startup mount
alter database archivelog;
alter database open;
6. Best way is keep the database in archive log mode.
That will help to recover the database up to last
committed transaction. Oracle recommendation is keep
the database in archive log mode.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / ramakrishna
no we can't take a backup while in no archive log mode to
enable archive log: alter database archivelog;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / amit bhagat
6. The database should run in Archive log mode because you
cant take online if your database is running in No archive
log mode.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / m.madhusudan reddy
No
5) shut immediate
startup mount
alter database archivelog
alter database open
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / amit bhagat
1). No, online backups is not possible in Noarchive log
mode.
2) Shutdown immediate
Starup mount
alter database archivelog;
alterdatabase open;
3) Database should run in Archivelog mode so that online
backup can be taken.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / uki
DB can be turned to archive log mode by turning the
LOGRETAIN parameter to RECOVERY and/or USEREXIT to YES. DB
will be in backup pending state which in turn requires to
be taken an offline backup to bring back the db to normal.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sanju
shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / binod
Noway, it can't be possibleto take ONLINE backup if the
database is running in an noarchievelog mode..
FOR altering the database into archieve log mode the
following steps should be consider-
1.shutdown your database
2.reopen the database but this time with the "mount" option
which will mount the instance but not open it.
3.Now your database can be back up
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between LMT & DLT?
What command would you use to encrypt a PL/SQL application?
How can you enable a trace for a session?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What view would you use to determine free space in a tablespace?
How would you determine what sessions are connected and what resources they are waiting for?
How do you trace the traffic hitting a sql server? : sql server DBA
what r the types of backup?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
