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?
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 |
Give two examples of how you might determine the structure of the table DEPT.
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What command would you use to create a backup control file?
Explain how you would restore a database using RMAN to Point in Time?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
1)how to Take Backup in sql server 2005 from Flash Drive
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the different sql server versions you have worked on? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
Explain the use of table functions.