Answer Posted / pvenkiroyal

select to_char(startup_time,'hh24:mi:ss dd-mom-yy') from
v$instance;

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2451

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1135

---

What is the difference between clustered and non-clustered index? : sql server DBA

1096

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2446

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1946

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2372

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2446

---

how does an oracle clusterware manage crs resources?

1100

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1767

---

What are the commands used in dcl? : sql server DBA

1084

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1739

---

what do you understand by fine-grained auditing?

1066

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1206

---

What types of replication are supported in sql server? : sql server DBA

1305

---

What purpose does the model database server? : sql server DBA

1205

---