Answer / braj123

Requirements for database restore using RMAN point in time:
* database must be running in Archive Log mode.
* Must have the full backup of the database and redologs
of the period from the backup and current time(find by SCN
NUMBERS).

Steps:

> SHUTDOWN IMMEDIATE;
>STARTUP MOUNT;
>RUN
{
SET UNTIL SCN 1000;
# Alternatives:
# SET UNTIL TIME 'Nov 15 2004 09:00:00';
# SET UNTIL SEQUENCE 9923;
RESTORE DATABASE;
RECOVER DATABASE;
}
>alter database open resetlogs;

What are the recovery models for a database? : sql server DBA

0 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

---

Hot backup procedure?

2 Answers  

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

what r the types of backup?

5 Answers   CSC,

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---