1: Session Check.
2: Some common ORA error codes
3: How to enable the password fro listener
4: Troubleshooting
5: Datapump I
6: DataPump II
7: ASM configuration
8: Using a password file
9:Creating an AWR (Automatic Workload Repository) Report
10: Oracle DBA Interview Questions and Answers
11: How to use CRONTAB
12: Oracle Tables
13: Cloning database with RMAN Catalog
14: Manually Cloning a Database (Hot Backup Cloning)
15: Managing Database Links
16: Constraints
17: Managing the Online Redo Logs
18: Tablespace Management
19: Manual Installation of Oracle Database on (ASM)
20: Cheat Sheet for Oracle DBA
21: Useful Scripts
22: Using NID utility of Oracle to change the Database Name
23: Applying database Patch (Opatch).
2: Some common ORA error codes
3: How to enable the password fro listener
4: Troubleshooting
5: Datapump I
6: DataPump II
7: ASM configuration
8: Using a password file
9:Creating an AWR (Automatic Workload Repository) Report
10: Oracle DBA Interview Questions and Answers
11: How to use CRONTAB
12: Oracle Tables
13: Cloning database with RMAN Catalog
14: Manually Cloning a Database (Hot Backup Cloning)
15: Managing Database Links
16: Constraints
17: Managing the Online Redo Logs
18: Tablespace Management
19: Manual Installation of Oracle Database on (ASM)
20: Cheat Sheet for Oracle DBA
21: Useful Scripts
22: Using NID utility of Oracle to change the Database Name
23: Applying database Patch (Opatch).
can i use system01.dbf file in another instance ??
ReplyDeletebecause my system01.dbf was missing and
i m nt having backup for it ....
If you do not have a backup then restore is out of question. System datafile is missing so you cannot have a functional database. Had it been any other data file, then one could have taken a stab at it by off-lining the missing files and open the database.
Delete